Integrate getQuote into Microsoft Excel
Please adjust the data according to your exchange permission interval. Calculations will only update for intraday data.
Make sure your query is in .csv format
Select the “Data” tab
Select “From Web”
Paste your queries URL in the “From Web” pop-up box
Select the web address that includes the API name (getQuote).
A pop-up will appear giving a summary of what will be displayed. Here you can change the specifications on the data displayed. Once everything is in place, select the “Load” button on the bottom right of the pop-up box.
Data should be displayed in a table
You have successfully linked the data into excel, however, this is a snapshot of the data. If you would like for the data to be up to date and refresh on its own. Click on the “Properties” under the Data tab.
Once the “External Data Properties” pop-up appears, you will want to click on the “Query Properties”
You can now control the refresh settings to fit your preferences.
Applicable for Microsoft Office 16 Users