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.


    1. Trade Smart Online Article Author

      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.

    1. Trade Smart Online Article Author

      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.

  1. Sandesh Haware

    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?

    1. Trade Smart Online Article Author

      Hello Sandesh,
      Currently you can only link market watch to excel and not order book and trade book. However, we shall look into it.

  2. Sanjeev

    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.

    1. Trade Smart Online Article Author

      Hello Sanjeev,
      Kindly contact us at 022-61208000. We may have to take your PC on remote and check the issue and work accordingly.

Ask a question