Updating real time data
Before you can create a macro to download real-time data from the website, you must first enable the “Developer” tab in Excel.
To do this, click “File,” then “Options.” In the Excel Options window, you will see a link labeled “Customize Ribbon.” Click that link and enable the “Developer” option in Main Tabs.
Excel Web Queries makes entering XML data feeds from websites relatively easy.
Still, you must copy and paste the XML URL address every time you want to create a new table in your spreadsheet – unless you create a macro to do it automatically.
I am also able to get the Symbols and charts open, but there seems to be a lag between the system time and the chart time till where its loaded.
I am attaching a screenshot of the same, and also the message log as you have given instructions on the documentation page.
Many sites will have an “Export to Excel” option as well, but this option will provide you with static data only current when you view it on the site.
Click one button to retrieve the data and create the table in your spreadsheet, then later click the other to refresh the displayed data.
An Excel Web Query allows you to retrieve the latest real-time data and insert it in your spreadsheet.