| # Package used to execute HTTP POST request to the API | |
| import json | |
| import urllib.request | |
| # API Key | |
| TOKEN = YOUR_API_KEY # replace YOUR_API_KEY with the API key you got from sec-api.io after sign up | |
| # API endpoint | |
| API = "https://api.sec-api.io?token=" + TOKEN | |
| # Define the filter parameters |
# Print the response. Most likely this will throw an error because we fetched a
# large amount of data (10,000 filings). Reduce the number of filings and you will see a result here.
print(json.dumps(filingsJson, indent=2)){
"total": 21521,
"filings": [
{
| def compress_filings (filings): | |
| store = {} | |
| compressed_filings = [] | |
| for filing in filings: | |
| filedAt = filing['filedAt'] | |
| if filedAt in store and store[filedAt] < 5: | |
| compressed_filings.append(filing) | |
| store[filedAt] += 1 | |
| elif filedAt not in store: | |
| compressed_filings.append(filing) |
| import xml.etree.ElementTree as ET | |
| import re | |
| import time | |
| # Download the XML version of the filing. If it fails wait for 5, 10, 15, ... seconds and try again. | |
| def download_xml (url, tries = 1): | |
| try: | |
| response = urllib.request.urlopen(url) | |
| except: | |
| print('Something went wrong. Wait for 5 seconds and try again.', tries) |
| # Download the XML for each filing | |
| # Calculate the total transaction amount per filing | |
| # Save the calculate transaction value to the filing dict with key 'nonDerivativeTransactions' | |
| def add_non_derivative_transaction_amounts (): | |
| for filing in filings: | |
| url = filing['linkToTxt'] | |
| xml = download_xml(url) | |
| nonDerivativeTransactions = calculate_transaction_amount(xml) | |
| filing['nonDerivativeTransactions'] = nonDerivativeTransactions | |
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import matplotlib
from pandas.io.json import json_normalize
def getBins (filings):
bins = {}
for index, row in filings.iterrows():
filedAt = row['filedAt']
nonDerivativeTransactions = row['nonDerivativeTransactions']
value = bins[filedAt] + nonDerivativeTransactions if filedAt in bins else nonDerivativeTransactions
bins[filedAt] = round(value, 2)
return bins
| # Set size of figure | |
| plt.rcParams['figure.figsize'] = [15, 10] | |
| # Prettify y axis: 2000000 to $2M | |
| def millions(x, pos): | |
| return '${:,.0f}M'.format(x*1e-6) | |
| fig, ax = plt.subplots() | |
| # Define bar plot | |
| ax.bar(range(len(bins)), list(bins.values()), align='center') |
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8" /> | |
| <meta | |
| name="Description" | |
| content="Stock Market News Aggregator | Article2Tickers | Reuters, Bloomberg, SeekingAlpha, WSJ, +1K more | | |
| Real-Time News Feed | Custom Filters | Text-to-Audio Reader | Ad-Free & Clean Design" | |
| /> | |
| <meta |