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.
Can I link my nest positions pnl data to be Excel and group the positions as per my strategy in excel to track the pnl of my options strategies in excel sheet. Is it possible?
The data of Position book can’t be link to excel for now.
I have OS 64 bit and MS office( window 10) and Excel 2016 ( 64 bit). Using Nez trader 64 bit to link excel, but excel giving N/A values. I have upstox account. Please help
Ideally, the OS should be the same for Nest and Excel to use the “Link to Excel”. Please get in touch with customer support team of respective broker as it such could occur due to attributes or compatibility level.
Thank you. I couldn’t find for Option CHANHE in OI value. I can see only Open interest value in the watch list. Please let me know ow to get change in open interest values.
You may find the change in open interest values in the Snap quote/Depth. Please double click or press F6 on the options contract to open the Snap quote/Depth. In case you wish to add the change in open interest as a column in watchlist then please use DarkStocks (advanced desktop based application). Please refer to this link to know more on DarkStocks.
Please let me know how do you link the admin positions (F11) to Excel? Please help.
You cannot link Admin position to excel. You can only copy to the excel by right click on Admin positions > click on “Write to excel”.
I have OS 64 bit and MS office 32 bit.
I tried both Nest trader 32 bit as well as 64 bit, but both now able to link the data to excel.
Please support …
You are required to have the same configuration for NEST, Excel and your OS. If you have 64 bit OS then you need to have 64 bit MS office and 64 bit NEST Trader. Then you shall be able to use Link to Excel feature. If you still face the issue then please contact us at 022-61208000. Our customer service team will help you resolve your query.
I have done all the steps mentioned in link to excel from nest, but still my excel sheet continue to have ‘NA’ written. Pls help
You must be having 64 bit OS in your system. For that you have to install another NEST trader that support 64 bit OS. Kindly call us at 022-61208000 Extn:2. Our team will provide you an another NEST Trader version and instruct you on Link to Excel feature.
I followed the instructions given in this article for linking live data to excel…but all i get is #NA in excel…any help is much appreciated.
Please check whether your PC is 32 bit OS or 64 bit OS. If your system is 32 bit then you should not face any issue. If your system is 64 bit OS then please contact our customer service at 022-61208000. They shall provide you another NEST Trader application which supports with your 64 bit OS system. Basically, your system OS should match with the NEST Trader type too. If yes then you should not face any issue in Link to Excel feature.
I was just going through ur post regarding the link to excel feature in nesttrader. I tried to link but the columns are full showing #NA. Can u please solve the issue. My whatsapp.no.94972-82865. Please msg me so that u can take my system online.
As per your conversation with one of our executive, you do not have an account with us. To know how to use link to excel, you would require an ID and password to login and check this feature. Kindly open an account with us to be able to login NEST and apply link to excel settings.
Hello Trade smart,
I am facing issue #NA and I have tried infact everything.
Is there anyway you can help me working ? Infact I took am instance on cloud & tried with multiple combination of Windows/Excel etc. no luck.
Kindly contact us at 022-61208000. We may have to take your PC on remote and check the issue and work accordingly.
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?
Currently you can only link market watch to excel and not order book and trade book. However, we shall look into it.
Can you tell me how to link real-time live data to excel?
Kindly follow the steps mentioned in the above article. In case of any issues you’re facing, kindly contact us at 022-61208000.
Maximum how many stocks can be added in watchlist to use the option link to excel
How to place orders using excel sheet
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.
How to link order book and Trade book to excel?
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.