!pip install -q python-dotenv
sec-api-io
Unofficial wrapper for the sec-api.io API. Built with nbdev.
Install and Setup
Run in terminal:
pip install sec_api_io
How to use
(Optional) Set API key with .env
file
It’s highly recommended to set your API key in a .env
file to avoid setting it in the code.
- Make a copy of the
.env.template
file in the root directory of the project. - Rename the copied file to
.env
. - Open the
.env
file and locate theSECAPIO_API_KEY
variable. - Fill in the value for the
SECAPIO_API_KEY
variable.- You can obtain a free key from sec-api.io.
- Note: The first 100 requests are free.
- Save the
.env
file next to your notebook or script.
Important Note: Depending on your geographical location, you might need to use a VPN set to a United States location to access sec-api.io API.
Let’s load the API key from .env file into the environment variable SECAPIO_API_KEY
from dotenv import load_dotenv
# Load the API key from .env file into the environment variable SECAPIO_API_KEY load_dotenv()
True
import os
from dotenv import load_dotenv
if 'SECAPIO_API_KEY' not in os.environ:
assert load_dotenv()
assert 'SECAPIO_API_KEY' in os.environ
import os
from dotenv import load_dotenv
if 'SECAPIO_API_KEY' not in os.environ:
assert load_dotenv()
assert 'SECAPIO_API_KEY' in os.environ
assert os.environ['SECAPIO_API_KEY'].strip()
Get latest 10-Q report by ticker
from sec_api_io.secapio_data_retriever import SecapioDataRetriever
= SecapioDataRetriever()
retriever # retriever = SecapioDataRetriever(api_key=...) # If you don't want to use .env file
= retriever.retrieve_report_metadata('10-Q', latest_from_ticker='AAPL')
metadata = metadata["linkToFilingDetails"]
url
assert url.startswith('https://www.sec.gov/Archives/edgar/data/')
url
'https://www.sec.gov/Archives/edgar/data/320193/000032019323000077/aapl-20230701.htm'
Download 10-Q HTML split into sections
= retriever.get_report_html('10-Q', url)
html assert html
for line in html.splitlines():
print(line[:65] + '...')
<top-level-section-separator id="part1item1" title="Financial Statemen...
<span style="color:#000000;font-family:'Helvetica',sans-serif;fon...
<top-level-section-separator id="part1item2" title="Management's Discu...
<span style="color:#000000;font-family:'Helvetica',sans-serif;fon...
<top-level-section-separator id="part1item3" title="Quantitative and Q...
<span style="color:#000000;font-family:'Helvetica',sans-serif;fon...
<top-level-section-separator id="part1item4" title="Controls and Proce...
<span style="color:#000000;font-family:'Helvetica',sans-serif;fon...
<top-level-section-separator id="part2item1" title="Legal Proceedings"...
<span style="color:#000000;font-family:'Helvetica',sans-serif;fon...
<top-level-section-separator id="part2item1a" title="Risk Factors" com...
<span style="color:#000000;font-family:'Helvetica',sans-serif;fon...
<top-level-section-separator id="part2item2" title="Unregistered Sales...
<span style="color:#000000;font-family:'Helvetica',sans-serif;fon...
<top-level-section-separator id="part2item3" title="Defaults Upon Seni...
<span style="color:#000000;font-family:'Helvetica',sans-serif;fon...
<top-level-section-separator id="part2item4" title="Mine Safety Disclo...
<span style="color:#000000;font-family:'Helvetica',sans-serif;fon...
<top-level-section-separator id="part2item5" title="Other Information"...
<span style="color:#000000;font-family:'Helvetica',sans-serif;fon...
<top-level-section-separator id="part2item6" title="Exhibits" comment=...
<span style="color:#000000;font-family:'Helvetica',sans-serif;fon...
Contributing
Follow these steps to install the project locally for development:
- Install the project with the command
pip install -e ".[dev]"
.
Note We highly recommend using virtual environments for Python development. If you’d like to use virtual environments, follow these steps instead: - Create a virtual environment
python3 -m venv .venv
- Activate the virtual environmentsource .venv/bin/activate
- Install the project with the commandpip install -e ".[dev]"