-
Notifications
You must be signed in to change notification settings - Fork 0
/
fmp_import.py
51 lines (33 loc) · 1.22 KB
/
fmp_import.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
# Imports
import numpy as np
import pandas as pd
import requests
import json
# References
# https://stackoverflow.com/questions/53558837/python-loop-to-pull-api-data-for-iterating-urls
# Test implementation
ticker_list = 'ABM' #['ORCL', 'ABM', 'ALJJ', 'TRN']
url = 'https://fmpcloud.io/api/v3/'
report = 'balance-sheet-statement/'
apikey = '96a549a2823d1e4a3a66379d2868f0ec'
#r = requests.get(url + report + ticker_list + ?period=quarter&apikey=96a549a2823d1e4a3a66379d2868f0ec')
r = requests.get('https://fmpcloud.io/api/v3/balance-sheet-statement/TRN?period=quarter&apikey=96a549a2823d1e4a3a66379d2868f0ec')
df = pd.read_json(json.dumps(r.json()))
obj = r.json()
print(r.status_code)
print(r == None)
print(r.json())
print(r.json() == None)
if len(r.json()) != 0:
# Looped implementation
ticker_list = ['ORCL', 'ABM', 'ALJJ', 'TRN']
result = None
for ticker in ticker_list:
r = requests.get('https://fmpcloud.io/api/v3/balance-sheet-statement/{}?period=quarter&apikey=96a549a2823d1e4a3a66379d2868f0ec'.format(ticker))
if len(r.json()) != 0:
r_df = pd.read_json(json.dumps(r.json()))
if result is None:
result = r_df
else:
result = np.concatenate((result, r_df))
print(r.url)