Integration Examples

Integrate getQuote into Microsoft Excel

Please adjust the data according to your exchange permission interval. Calculations will only update for intraday data.

Step 1
Make sure your query is in .csv format
getQuote Step 1
Step 2
Open Excel

Step 3
Select the “Data” tab
getQuote Step 3
Step 4
Select “From Web”
getQuote Step 4
Step 5
Paste your queries URL in the “From Web” pop-up box
getQuote Step 5
Step 6
Select the web address that includes the API name (getQuote).
getQuote Step 6
Step 7
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.
getQuote Step 7
Step 8
Data should be displayed in a table
getQuote Step 8
Step 9
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.
getQuote Step 9
Step 10
Once the “External Data Properties” pop-up appears, you will want to click on the “Query Properties”
getQuote Step 10
Step 11
You can now control the refresh settings to fit your preferences.
getQuote Step 11

Integrate getHistory into Microsoft Excel

Step 1
Make sure your query is in .csv format
getHistory Step 1
Step 2
Open Excel

Step 3
Select the “Data” tab
getHistory Step 3
Step 4
Select “From Web”
getHistory Step 4
Step 5
Paste your queries URL in the “From Web” pop-up box
getHistory Step 5
Step 6
Select the web address that includes the API name (getQuote).
getQuote Step 6
Step 7
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.
getHistory Step 7
Step 8
Data should be displayed in a table
getHistory Step 8
Step 9
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.
getHistory Step 9
Step 10
Once the “External Data Properties” pop-up appears, you will want to click on the “Query Properties”
getHistory Step 10
Step 11
You can now control the refresh settings to fit your preferences.
getHistory Step 11