In this post we will discuss the simple procedure to export live streaming quotes from market watchlist in NOW or NEST to Microsoft Excel. Once the data is exported, we can easily set alerts, sort data and get precise price information to perform a quick data analysis. Follow the steps mentioned below.
1) Open Microsoft Excel with administrator rights.
Follow the steps below to start Excel with administrator rights.
Go to 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” box.
2) Add the NEST folder in trusted location in Excel.
Open Excel with administrator rights.
Click on Office button at the top left corner of Excel.
Click on Excel options > Select Trust center > Trust center settings > Trusted locations option in the left side > Add new location > C:\Program Files (x86)\Omnesys\NEST3\
3) Restart Excel
4) Open NOW/NEST with administrator rights.
Right click on the NOW/NEST desktop icon > Run as administrator > follow normal login procedure.
5) Use "Link to Excel" option in NEST or NOW
Right click on the market watchlist and click on "link to excel". Then go to Excel and paste it on the excel sheet.
You will be able to see realtime streaming quotes on Excel now.
1) Open Microsoft Excel with administrator rights.
Follow the steps below to start Excel with administrator rights.
Go to 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” box.
2) Add the NEST folder in trusted location in Excel.
Open Excel with administrator rights.
Click on Office button at the top left corner of Excel.
Click on Excel options > Select Trust center > Trust center settings > Trusted locations option in the left side > Add new location > C:\Program Files (x86)\Omnesys\NEST3\
3) Restart Excel
4) Open NOW/NEST with administrator rights.
Right click on the NOW/NEST desktop icon > Run as administrator > follow normal login procedure.
5) Use "Link to Excel" option in NEST or NOW
Right click on the market watchlist and click on "link to excel". Then go to Excel and paste it on the excel sheet.
You will be able to see realtime streaming quotes on Excel now.
Hi Can someone help me ? How can I get the NOW/NEST icon onto my desktop? Please email askbbj@gmail.com
ReplyDelete