iXBRLAnalyst for Google Sheets
iXBRLAnalyst for Google Sheets is an open-source project that provides an easy-to-use Add-in for fetching financial data from our databases in Google Sheets. It is mostly intended for students to do simple financial modeling. However, since the release of iXBRLAnalyst for Excel Online, which provides the flexibility of using XBRLAnalyst on any platform and device, we strongly recommend downloading and installing it from the Microsoft AppSource store.
- Example 1: iXBRLAnalyst Primer
- Example 2: iXBRLAnalyst Normalized Financials
- Example 3: iXBRLAnalyst Monitoring SP100 Companies
If you want to modify those templates above or try them with other non SP100 companies, just use “File->Make a Copy…” menu in Google Sheets and then login in XBRLAnalyst that will appear on the top of the menu (see screenshot below). If you would like to create your own Google Sheets using XBRLAnalyst functions and data, just create or load Excel file in Google Sheets and then click “Tools -> Script editor…” and paste XBRLAnalyst script that you can download here.