1. Home
  2. Tiingo API
  3. Tiingo API Integrations
  4. How to Integrate the Tiingo API with XLQ
  1. Home
  2. Tiingo API
  3. How to Integrate the Tiingo API with XLQ

How to Integrate the Tiingo API with XLQ


XLQ is created by QMatix and is third-party software that allows you to important data from a variety of data sources, like the Tiingo API, into Excel.

Many of our customers are looking for Tiingo integration into Excel, and XLQ one solution customers find helpful, and is also data-source agnostic. This means it’s easy to quickly switch to Tiingo if you’re already using the software.

How to Integrate the Tiingo API with XLQ

Step 1: Get your Tiingo API Token

Get your Tiingo API token here: https://www.tiingo.com/account/api/token. You may need to create a Tiingo account if you haven’t already. Accounts are free to start and a free account is great for testing this article.

Your token is the long string of random numbers and letters:


Copy and paste that token for step 3.

Step 2: Paste the token in XLQ Settings

Go to your XLQ Preferences and select “Tiingo” from the left-hand box. From there you will see a place to enter your API Token:

Step 3: Make a query in Excel

With the token now established, you can make a query in Excel using a function such as “xlqhClose”. When using this function, make sure to set the source as “tiingo” which will then query our servers using the API token provided in the above excel.

Check out the screenshot below as an example:

Updated on August 21, 2023

Was this article helpful?

Related Articles

Leave a Comment