Troubles importing data with IMPORTJSON in Sheets

Excel, Google Sheets, WP, etc
1

Hey everyone, I starting testing the EOD data and immediately found an issue.

I am using ImportJSON func to import data directly from the API. It works for some keys in the JSON but not for /fundamentals/. My guess is that it’s because of the /fundamentals/ being indexed by date (which is weird).

On the other hand, this endpoint https://eodhd.com/api/eod/MCD.US provides data indexed by number sequence. It imports well with ImportJSON.

I don’t understand why the /fundamentals/ are indexed by date.

Does anyone know how to importJSON /fundamentals/ properly so that I get a table like format where the key is the column header and the values listed below, one row per year or quarter?

Thank you and much appreciated.

Current import looks like this:

23-12-31 Date 2023-12-31
23-12-31 Filing Date 2023-12-31
23-12-31 Currency Symbol EUR
23-12-31 Totalassets 187199000.00
23-12-31 Intangibleassets 22011000.00

But it should look like this

Date Symbol Reportedcurrency Cik Fillingdate
2023-12-31 CMI USD 0000026172 2024-02-12
2022-12-31 CMI USD 0000026172 2023-02-14
2021-12-31 CMI USD 0000026172 2022-02-08
2020-12-31 CMI USD 0000026172 2021-02-10
2

Hello Mark,

If you’re having trouble importing fundamental data, I recommend using the EODHD Google Sheets Add-on. It’s specifically built for EODHD data and simplifies the process by automatically structuring it into a table format.

3

I use the google sheets add-on and I really like it. The table format is much more readable and visually familiar to me.

4

@Levon_V @Simon Thanks.

I have reviewed the EOD Add-On. As far as I have seen, to update data I have to manually click around the add-on UI on the right. That does not work for me.

For my use case, I need data to be updated automatically whenever a ticker in cell XYZ changes. I have a ton of connected Sheets and Sheet tabs.

5

I’m glad you found a solution to your task :+1: