FMP
Google Sheet Integration
We have finally a Google Sheet Add on:
https://workspace.google.com/marketplace/app/financial_modeling_prep/262992176931You can see the tutorial here:
https://financialmodelingprep.com/developer/docs/google-sheet-add-on1. Create a new Google Sheet
2. Select Tools `>` Script Editor
3. Clik on + beside Files
4. Inside the panel click on Script
5. Name it DelayedImportJSON
6. Copy paste on the right panel the code below:
1
2
3
4
function DelayedImportJSON(url, query, parseOptions, delay, random) {
Utilities.sleep((random ? delay * Math.random() : delay) * 1000);
return ImportJSON(url, query, parseOptions);
}7. Click Save Icon
8. Clik on + beside Files
9. Inside the panel click on Script
10. Name it ImportJSON
11. Copy Past on the right panel the code from URL: https://raw.githubusercontent.com/bradjasper/ImportJSON/master/ImportJSON.gs
12. Modify the code by changing this part:
1
2
3
4
5
6
7
if (!data[row][column]) {
if (row < 2 || hasOption_(options, "noInherit")) {
data[row][column] = "";
} else {
data[row][column] = data[row-1][column];
}
}into this:
1
2
3
4
5
6
7
if (data[row][column] == null) {
if (row < 2 || hasOption_(options, "noInherit")) {
data[row][column] = "";
} else {
data[row][column] = data[row-1][column];
}
}13. Click Save Icon
14. Reload the page
15. Now to get last 3 Apple income statements you need to type =DelayedImportJSON("https://financialmodelingprep.com/api/v3/income-statement/AAPL?limit=3&apikey=YOUR_API_KEY") in a cell you want data to be.
The link to full template is here.
