NOW, NEST, TT, EXCEL2AMI FREE Setup-No Backfill (Personal Use Only)

This utility fetch realtime datafeed from NOW, NEST, TRADETIGER to Excel  and pull it into AmiBroker.

DOWNLOAD EXCELTOAMIFREE

EXCEL2AMI FREE SETUP INSTRUCTIONS:

When you run software you will see disclaimer. Click on OK to accept it.

After accepting disclaimer, you will see screen as shown above:

We will explain process to fetch data from Nest Terminal to Excel sheet.

Run NEST Trader and right click on the market watch. Select Link to Excel

and All Items.

Now open Excel and paste on the very first cell.

You will see all the columns details and rates in Excel. If they are into

coming then you need to contact your broker and get this feature

enabled.

Once you get all the columns and data in excel, Select LTD column and set

it’s format to Date and dd/mm/yyyy as shown below:

Similarly you need to set the format of LTT column to Time as HH:MM:SS

as shown below:

Save this Excel file as C:\Book1.xlsx. You can save it with any name and

any location. You need to select the same file in Excel2Ami Free by Clicking

Select ExcelWorkbook as shown below:

Make sure that name of the worksheet is same as mentioned in excel

workbook. It is case sensitive. So be careful:

Now you are ready to capture data from excel sheet. Click on Start

Capture. If essentials columns are missing in your market watch of your

terminal then you will see message like this:

After adding all the required columns click on OK on the message

displayed. You should see rates in Excel2Ami software.

This is all what is required to get data from Excel to Amibroker.