Procedure to “Link to Excel” from market watch
Open NEST with administrator rights. Right click on the market watch and click on link to excel. Paste it on the excel.
If found error of #NA while Linking to Excel in Nest, Please follow the below procedure
1. Open Excel with admin rights:
Follow the steps here to start your excel in admin right
Start Menu>>All Programs>>Microsoft Office>>Right click on Microsoft Office
Excel>>Properties>>Select compatibility>>In the Privilege Level, tick mark the “Run this program as an administrator”.
2. After opening excel with administrator rights, click on Office button at the top left corner of the excel.
3. Click on excel options>>Select Trust centre>>Trust centre settings>>Trusted locations option in the left side>>Add new location>> C:\Program Files\Microsoft Office\Office12 OR Office 14>>OK>>OK>>OK
4. Restart excel
5. Open NEST with administrator rights.
Steps to login trading terminal in admin rights
Right click on the NEST desktop icon>>Run as administrator>>follow normal login procedure.
6. Follow the above procedure mentioned in “Link to Excel” from market watch.
How to link order book and Trade book to excel?
Hello Sandesh,
Hope you must have gone through the explanation given in the above article. Please let us know what is the error you are facing. We will look into it and resolve your query.
How to place orders using excel sheet
Hello Viswanath,
Placing orders through excel depend on your strategy. This varies from trader to trader. We would request you to search the info in google for the detailed information.
Maximum how many stocks can be added in watchlist to use the option link to excel
Market watch can be linked to excel to get live streaming of data. But how to link Order book and Trade book to excel to get data about orders if pending or executed for algo-trading?
Hello Sandesh,
Currently you can only link market watch to excel and not order book and trade book. However, we shall look into it.