Here I am going to explain how the whole thing works.
1. I will not explain how to get realtime data into into excel. That is explained adequately by Raju here-
http://www.traderji.com/intraday/60576-realtime_now_excel_amibroker.html
The exception in my case is that I am interested in FnO hence I want the following columns-
Symbol,Last Trade Time,Last Traded Price,Last Trade Qty,Option Type,Strike Price
The order of the columns in NSENOW is irrelevant. So just start NSENOW and get these columns.
2. We create a csv file(C:\MyCSV.csv) containing stock quotations from Sheet1 of the excel workbook. Just click on the Sheet called "Start".
The order of cloumns should be strictly the same as given in Sheet1. There is also one more column for date containing formula Today(). This is must in front of every share since AmiBroker requires date for importing quotations.
3. We create AmiBroker as an activeX object in excel VBA and refer to it.
4. We call AmiBroker and tell it to import the csv file we created.
5. AmiBroker imports the quotations from MyCSV.csv by referring to the NSENOW.format file that we put into its format folder.
6. We tell it to RefreshAll and it refreshes the charts.
7. This is repeatd automatically every 2 seconds with 9 scrips. I believe we can use this for upto 20 scrips easily. For more scrips, refresh interval has to be increased.
8. In AmiBroker Database Settings, we set the database as Local and Base Time interval as Tick.
We do not have to worry about naming of each and every cell in excel sheet.
This is much simpler than the DDE option isn't it?
This trick can be used to -
-import data from any other trading application that allows link to excel and get Realtime charts.
-We can also import backfil data with this
1. I will not explain how to get realtime data into into excel. That is explained adequately by Raju here-
http://www.traderji.com/intraday/60576-realtime_now_excel_amibroker.html
The exception in my case is that I am interested in FnO hence I want the following columns-
Symbol,Last Trade Time,Last Traded Price,Last Trade Qty,Option Type,Strike Price
The order of the columns in NSENOW is irrelevant. So just start NSENOW and get these columns.
2. We create a csv file(C:\MyCSV.csv) containing stock quotations from Sheet1 of the excel workbook. Just click on the Sheet called "Start".
The order of cloumns should be strictly the same as given in Sheet1. There is also one more column for date containing formula Today(). This is must in front of every share since AmiBroker requires date for importing quotations.
3. We create AmiBroker as an activeX object in excel VBA and refer to it.
4. We call AmiBroker and tell it to import the csv file we created.
5. AmiBroker imports the quotations from MyCSV.csv by referring to the NSENOW.format file that we put into its format folder.
6. We tell it to RefreshAll and it refreshes the charts.
7. This is repeatd automatically every 2 seconds with 9 scrips. I believe we can use this for upto 20 scrips easily. For more scrips, refresh interval has to be increased.
8. In AmiBroker Database Settings, we set the database as Local and Base Time interval as Tick.
We do not have to worry about naming of each and every cell in excel sheet.
This is much simpler than the DDE option isn't it?
This trick can be used to -
-import data from any other trading application that allows link to excel and get Realtime charts.
-We can also import backfil data with this
Last edited: