This repository contains the Apps Script code for the financial analytics workshop. This script is modified based on the original importJSON.gs.
To use go to Extensions > Apps Script and paste the whole ImportJSONSectors.gs file.
Don't forget to add your Sectors API Key as API_KEY to Project Settings > Script Properties.
Here are all the functions available:
| Function | Usage on Sheets |
|---|---|
| ImportCompanyIndex | =ImportCompanyIndex("index_code") |
| ImportCompanyReport | =ImportCompanyReport("stock_code", "", "noInherit") |
| ImportCompanyReportList | =ImportCompanyReportList("", "noInherit") |
- Sectors API Documentation
- Sectors API Recipe Repository
- If you're a Supertype Fellowship member, please join our Discord community for support and discussions. Any Fellowship+ members should try to maximize the use of the Discord channels for guidance and mentorship.
- Sectors on LinkedIn
- Supertype on LinkedIn
- Sectors on Instagram
- Also sign up to Sectors Newsletters for product roadmap, future workshops, and updates. We hate spam and promise to keep your email safe.