Exploring 10-K & 10-Q SEC Filings for Mentions of Bitcoin

in LeoFinance2 years ago (edited)

secfilings.jpg

Public companies file 10-K, 10-Q, and other documents to SEC where they disclose various financial information about the company. 10-K documents are annual reports and 10-Q documents are quarterly reports. This information is publicly available at sec.gov, and SEC has an easy to use search tool called Edgar. Using Edgar, investors can find information about companies, company filings, etc for their research.

10-K documents usually contain information about companies main operations, risk factors, various financial data, management's discussions and analysis, as well as financial statements. I was looking at Tesla's 10-K to see what they were saying about their bitcoin investment strategy. Under sub-title We hold and may acquire digital assets that may be subject to volatile market prices, impairment and unique risks of loss, they say:

In January 2021, we updated our investment policy to provide us with more flexibility to further diversify and maximize returns on our cash that is not required to maintain adequate operating liquidity. As part of the policy, which was duly approved by the Audit Committee of our Board of Directors, we may invest a portion of such cash in certain alternative reserve assets including digital assets, gold bullion, gold exchange-traded funds and other assets as specified in the future. Thereafter, we invested an aggregate $1.50 billion in bitcoin under this policy and may acquire and hold digital assets from time to time or long-term. Moreover, we expect to begin accepting bitcoin as a form of payment for our products in the near future, subject to applicable laws and initially on a limited basis, which we may or may not liquidate upon receipt.

By now Tesla's purchase of bitcoin, its interest in bitcoin and intentions to accept bitcoin as form of payment for their products is an old news. While in the document word bitcoin is mentioned 9 times, the same paragraph quoted above is mentioned in several sections.

I also looked at 10-K filed by MicroStrategy and searched for the mention of bitcoin in their filing. They mentioned bitcoin 349 times. For them it seems bitcoin is a bigger strategy. One sentence out of many explains their vision:

One strategy is to grow our enterprise analytics software business and the other strategy is to acquire and hold bitcoin.

Now I am curious how many more public companies are investing in bitcoin and taking a look at their 10-K or 10-Q reports can help with finding out. As I was preparing to see if I could automate downloading these 10-K files for multiple companies, I found this python module - sec-edgar-downloader, that makes downloading these filings super easy in couple lines of code.

Just like any other module it needs to be pip installed first as following:

pip install -U sec-edgar-downloader

Afterwards, getting needed files can be done like this:

from sec_edgar_downloader import Downloader
dl = Downloader("/path/to/valid/save/location")
dl.get("10-K", "MSFT", amount=1)

That's it.

For more details, feel free to visit the documentation here:

https://sec-edgar-downloader.readthedocs.io/en/latest/

Downloading the files is half of the work. Next steps are to go through the files, read them and find the paragraphs where bitcoin is mentions. Once files are available, more research can be done based on the what we are looking for. All of this can be automated and needed data analyzed programmatically.

I wrote a script to do just that. This scrip would go through list of company ticker symbols list and download all the documents from sec edgar. Afterwards, it locates the files in the local machines, reads them and displays all the mentions of the bitcoin if there are any. For this initial test I only used two companies mentioned above: Tesla and MicroStrategy.

At a later time, I will make a larger list of companies to explore their 10-K filings for the mentions of bitcoin. Six months ago I wrote another script that does just that, it programmatically collects the list of company ticker symbols using finviz screener. Feel free to read about it more here:

https://leofinance.io/@geekgirl/automating-finviz-screener-with-selenium-in-python

And here is the script that downloads 10-K filings and checks for mentions of bitcoin:

from sec_edgar_downloader import Downloader
from bs4 import BeautifulSoup
import os
import re

companies = ['TSLA', 'MSTR']
report = '10-K'

def get_report_path(company, report):
    os.chdir(os.path.expanduser("~"))
    path = os.getcwd()
    path = f'{path}/Desktop/edgar/sec-edgar-filings/{company}/{report}'
    os.chdir(path)
    path = os.getcwd()
    folder = os.listdir(path)[0]
    path = f'{path}/{folder}/filing-details.html'
    return path

for company in companies:
    path = f"{os.getcwd()}/Desktop/edgar/"
    dl = Downloader(path)
    dl.get(report, company, amount=1)

for company in companies:
    report_file_path = get_report_path(company, "10-K")
    soup = BeautifulSoup(open(report_file_path), "html.parser")
    count = 1
    for x in soup(text=re.compile(r'bitcoin')):
        print(count)
        print(x)
        print('----')
        count += 1

Posted Using LeoFinance Beta

Sort:  

Amazing stuff you have going on here.

I'd love to see this running and generating daily reports about 10-Ks that have some sort of mention about crypto.

Posted Using LeoFinance Beta

Thank You.

Lol they should change their name to Bitcoin strategy they way they going I wonder how his going to pivot the business with all this Bitcoin it can’t just be something to sit on they a tech company I’m sure he has other plans

He said many times that he intends to just hold their bitcoins for at least ten years.

That would be a great list of companies to have for both consideration to invest in, as well as understanding the speed of adoption crypto currency is getting with Big Corp.

Posted Using LeoFinance Beta

I really liked reading your posts. They really add value and you know i am now getting so many ideas to give small projects to the interns from different schools

Thank You.

For sure a lot of companies will start investing a bitcoin since the value is insane. By the way, you mentioned tesla? Is this a token of something that is legit? Someone DM me on discord telling me that I was selected to receive? Do you think it's just a scam or something? Sorry, just not sure and don't know what to do of it.

Posted Using LeoFinance Beta

Tesla is a company that makes Tesla cars. Discord DMs with offers and saying you are selected for something, etc are scams. Don’t click those links.

Ah, thank you very much. I'm so glad I asked.

Posted Using LeoFinance Beta

This post has been manually curated by @bhattg from Indiaunited community. Join us on our Discord Server.

Do you know that you can earn a passive income by delegating to @indiaunited. We share 80 % of the curation rewards with the delegators.

Here are some handy links for delegations: 100HP, 250HP, 500HP, 1000HP.

Read our latest announcement post to get more information.

image.png

Please contribute to the community by upvoting this comment and posts made by @indiaunited.

  • The subject of the post : Coding
  • Content-Type : Words and codes
  • Numbers of photos : 1
  • Post quality : GOOD
    The post reblogged and upvoted by me
    Thank you @geekgirl