API Documentation

August 8, 2018
API Datasets Documentation How to Reference
Example file: (you can change it)
base = https://data.invisement.com
file = q/AAPL.csv
url = base/file
viewer = base?file

Download, Explore, or Embed


Available Datasets

Please replace TICKER with company’s ticker symbol and CIK with its CIK. For instance, Apple’s TICKER is AAPL and its CIK is 320193.


Fetch Data Files

Google Sheets

Use =importData(url) formula:

=importData(https://data.invisement.com/q/AAPL.csv) 

Python

Use pandas library

import pandas as pd
data = pd.read_csv(url)

R

data = read.csv(url(data_url))

JavaScript

Fetch the file’s url and then parse it (we recommend Papa.parse)

<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/PapaParse/4.1.2/papaparse.min.js"></script>

fetch(url)
    .then(response => response.text())
    .then(Papa.parse)
    .then(response => response.data) 
    ## output is js array of arrays [['col1', 'col2', ...]['1.1', '1.2', ...], ['2.1', '2.2', ...] ...]
    .then(whatever you want to do with parsed data);

Excel

In Excel, from menu select Data then click from Text/CSV and in File name enter url: https://data.invisement.com/q/AAPL.csv