Tiingo static and fundamental data provider
Author: Eugene
Creation Date: 7/1/2017 6:02 AM
profile picture

Eugene

#1
MS123 LLC is proud to release a new static and fundamental provider delivers historical data for 37,000 U.S. stocks and ETFs from Tiingo. Like Yahoo!, it comes with a history of splits and dividends which can be applied on-the-fly and its data doesn't require refresh after a split or dividend.

Before using it you must register a free account at https://api.tiingo.com and then type in your API key in Data Manager > Tiingo

The provider is available for installation from our website (Extensions section):

Tiingo provider - installation link

Please read the online setup guide before using:

Tiingo provider online notes in the Wealth-Lab Wiki
profile picture

Eugene

#2
ReneW wrote in a thread that existed:

I really appreciate the new tiingo data provider.

The problem is, I have inserted my username and password
and still getting the error below.
I am pretty sure, that the password is correct.

I tested my account with the help of a little python script, where I need the api token,
and that worked.
Whats the problem here ? I would assume, my credentials, but I triple checked it.

QUOTE:
[3] BZQ Error: Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.
[0] ASHR Error: Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.
[2] BOIL Error: Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.
[1] BIB Error: Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.
[4] CEFL Error: Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.



Addon:
The quandl data provider uses the API token.... I am wondering, why accessing tiingo
has beeen realized with username/password combination instead with the API token.
profile picture

Eugene

#3
It's really unfortunate that it doesn't work for you. I have no problem downloading data from Tiingo:

QUOTE:
Updating DataSet 1 ...
[1] CEFL 899 bars 02.08.2017 899 bars added
[0] ASHR 941 bars 02.08.2017 941 bars added
[3] BOIL 1465 bars 02.08.2017 1465 bars added
[2] BIB 1843 bars 02.08.2017 1843 bars added
[4] BZQ 2045 bars 02.08.2017 2045 bars added
Update completed (2.918 sec)
----------------


Let's collect some evidence first:

1. Are your credentials from api.tiingo.com and not from some other part?
2. They are case sensitive. Have you double checked that they're entered exactly?
3. Can you log in on their API website successfully?
4. How many bandwidth and requests are left: Your API usage?

I'll mark to investigate into Auth Token authorization later this or next month but basic HTTP authorization works for me.
profile picture

ReneW

#4
QUOTE:
Let's collect some evidence first:



1.) https://api.tiingo.com/
2.) checked
3.) yes
4.) I downloaded only the ticker SPY as a test case, enough bandwith left


SOLVED:

I can login on tiingo with <username>@<email.com>

_BUT_ WL data provider works only with username <username>

Sorry!

profile picture

Eugene

#5
Okay, it was a basic check but still. Basic HTTP authorization the provider uses is so simple that there's hardly a place to fail. Maybe your username has some special characters? Or this might be something related to our different regional settings etc. It would be very hard to tell the reason given that it's impossible to reproduce.
profile picture

Eugene

#6
QUOTE:
I can login on tiingo with <username>@<email.com>

_BUT_ WL data provider works only with username <username>


Glad you solved it while I was replying :-)

Username must be username, not email or anything. It's not the "WL data provider" but it's precisely the Tiingo API that accepts an account name and does not accept an email.

I've added a note to the Wiki page. Thanks.
profile picture

Eugene

#7
Tiingo provider updated to v2018.01:

* Fixed error message on broken config file
profile picture

Panache

#8
I'm running into the same issue as ReneW using Tingo v. 2018.01.

1.) https://api.tiingo.com/
2.) checked
3.) yes
4.) I downloaded only the ticker SPY as a test case, enough bandwith left

I am only using my Tiingo Username (ie. not my email address) and Password.

QUOTE:
Updating DataSet Tiingo ...
[0] SPY Error: The remote server returned an error: (401) Unauthorized.
Update completed (0.336 sec)
----------------
profile picture

Eugene

#9
Cannot reproduce:
QUOTE:
Updating DataSet 1 ...
[0] SPY 6297 bars 30.01.2018 6297 bars added
Update completed (27.315 sec)
----------------
profile picture

Revilla

#10
Hello support team,

I have the Extension Tiingo Static, Real-Time and Fundamental
installed by MS123 (Eugene) in WL.
Unfortunately, I do not get any data from Tiingo. I get the message that I am not authorized.
On request to Tiingo I got the following answer.

"Hi Egbert,

WealthLab's software but it sounds like you may need your API authorization token! I'm guessing the software has a place where you can input your token.

Your API token is: cad69c8e....................

And going forward you can find your token here: https://api.tiingo.com/account/token

Let us know if this helps
Rishi "

Where can I insert the token in WL?

Best regards
Egbert
profile picture

Eugene

#11
Hi Egbert,

Please please always read the online user guide before using and/or asking questions to both support teams. You'll find your question answered in at least four places:

1. If you try to update Tiingo data not having entered a username/password, you're going to see a warning message in Wealth-Lab's "Data Update Log" view followed by explicit instructions on where to insert the password.

2. Straight in the first post of this topic (see notes in bold)

3. On the 2nd screenshot of the extension download link from where you installed it

4. And of course in the online user guide at: Tiingo Static Provider

P.S. Tiingo's API token has no use in WL. The provider uses the password from your account.
profile picture

Panache

#12
Eugene,

I'm still getting the same error message reported in post #8.

I've tried everything I can think of, including deleting TiingoClientSettings.xml and copying and pasting my username and password into the Tiingo tab in DataManager. I checked the new TiingoClientSettings.xml file and both the username and password are correct.

I can copy and paste the same username and password and get logged in at https://api.tiingo.com/. Unlike ReneW, my username is not associated with an email address, but is a random combination of 12 upper and lower case letters and numbers. My password also is a random combination of 12 upper and lower case letters and numbers.

Any thoughts as to what I might be doing wrong?
profile picture

Eugene

#13
Kurt,

It still works for me but both my login/password are shorter and lower case (since I only need them for testing). You might want to try a shorter and simpler account name AND password in lower case, or create a support ticket to pass on your credentials to me to check what goes wrong. If all else fails I'd have to experiment with replacement of Basic authorization with Token authorization.
profile picture

Eugene

#14
P.S. Or you can simply wait until the end of month when we release an update to Tiingo provider which I hope will fix this for everyone. This is going to be a breaking change: current basic authentication using login/password has proven unreliable and will get replaced with token authentication using the API key from Tiingo's website. Consequently, username/password will stop working starting from v2018.03 in March and to update any data, Wealth-Lab users will have to obtain the free API key and paste it into the Data Manager.
profile picture

Eugene

#15
What's new in v2018.03:

This version contains a breaking change. If your current version (2018.01 or 2017.07) still works for you, you may not update until you get an error on data update like Error: The remote server returned an error: (401) Unauthorized.

* Change: BREAKING CHANGE: switched to token authentication; must copy/paste your API Token from api.tiingo.com website before using

We noticed that Tiingo no longer features Basic authentication (login/password) in their API documentation pages and it fails for some WLP/D users. To resolve this issue we have switched to Token authentication. For this reason, starting from v2018.03 your saved login/password will no longer work. To make Tiingo update data again you'll have to obtain your free "API Key" at api.tiingo.com and copy/paste it (no typing !!!) into the Data Manager (Tiingo tab).
profile picture

Panache

#16
Thank you Eugene. At least for my initial DataSet just containing SPY, it works as expected with 6316 bars added.
profile picture

Eugene

#17
Kurt, glad to have helped.
profile picture

Eugene

#18
What's new in v2018.04:

* New: support for GetSessionOpen

Tiingo's EOD data does not contain the partial bar, limiting its application in Strategies which require knowledge of the open price for today's incomplete bar - like gap trading, for example.

The good news is that their IEX Real-time Data API has recently become free for use by individuals. We've plugged it in to bring support for the open price for "today".

Since the liquidity is less than other exchanges, we recommend using GetSessionOpen for large cap companies and ETFs. Price updates can be less frequent for small cap companies.
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).