Python Tutorial 62 – Intrinsic Value Scraper for Comparing BVPS vs Price per Share Using Easy2Digital API

Discounted value of the cash that can be taken out of a business during its remaining life, is a well-known intrinsic value explanation offered by Warren Buffett. In fact, the intrinsic value calculator has a top-down and simple way out although the bottom-up and in-depth one requires more input. 

In this article, I’ll walk you through how to leverage Easy2Digital API data to build an intrinsic value scraper using Python. By the end of this piece, you can quickly scrape and consolidate 5 metrics in bulk, and find out if the symbol candidate from your list is a potential undervalued one to add to the investment queue by BVPS vs price per share. 

intrinsic value

Discounted value of the cash that can be taken out of a business during its remaining life, is a well-known intrinsic value explanation offered by Warren Buffett. In fact, the intrinsic value calculator has a top-down and simple way out although the bottom-up and in-depth one requires more input. 

In this article, I’ll walk you through how to leverage Easy2Digital API data to build an intrinsic value scraper using Python. By the end of this piece, you can quickly scrape and consolidate 5 metrics in bulk, and find out if the symbol candidate from your list is a potential undervalued one to add to the investment queue by BVPS vs price per share. 

Pros and cons to make more time by using Easy2Digital Intrinsic Value Scraper

Pros

  • Collect and consolidate any symbol data as you like in one place, which saves time to quickly check stock symbol top-down intrinsic value, and customize the dashboard to implement intrinsic value analysis
  • Specifically provide key metrics which are EV, net debt, book value, real-time outstanding shares, and price per share
  • Easy2Digital API has a free version

Cons

  • Compared to the paid software out there, It requires programming knowledge and script maintenance and upgrades
  • Activating automation using the cloud might have additional fees although the amount is small and it charges pay-as-to-go normally.

Ingredients to build the intrinsic value scraper

Python3, pandas, gspread, Google Sheet, Easy2Digital financial statement data API & token

Enterprise Value

EV is the value of a company, which is different from market capitalization. It’s notably popular to use for M&A investors. Compared to market cap, EV also considers net debt performance. So generally EV is greater than the market cap. Unless the company both doesn’t leverage debts to raise funds at all and invest in hardware and software for future growth.

EV = market cap + net debt

Enterprise value is not a static number and it does fluctuate like the market cap. The ratio between EV and market cap can imply two things. First thing first, if the case is much EV value which is greater than market cap, it implies much debt levered the company is using.

Conversely, if the case is EV value which is much closer to market cap or even less than, it implies the company less leverages debt and might be a cash cow.

Here takes the symbol aapl for the example of part of the intrinsic value scraper script: 

https://marketing-bots.herokuapp.com/api/1/symbol-enterpriseValue?symbol=&token=

Net Debt

Companies basically have two fundraising approaches. One is the debt, the other is to sell the equity. Each approach has pros and cons. In terms of debt, although it has a liability, as long as the interest rate is reasonable and stable, companies prefer a certain proportion of debt to raise funds compared to the equity approach.

Higher or lower net debt can’t tell if a company is easily liquidated or is growing exponentially, because it depends on the macro-economic factors, and bank interest rate conditions.

Net debt = Short term Debt + long term debt (Including interests) – cash / cash equivalent

For example, in 2022, USA Fed central bank keeps increasing the monetary interest rates against the severe domestic inflation issue. This approach can seriously impact the company’s profitability if they have a higher debt proportion in its fundraising portfolio.

https://marketing-bots.herokuapp.com/api/1/symbol-balanceSheetStatement?symbol=&token=

Outstanding Shares

Shares outstanding refer to a company’s stock currently held by all its shareholders, including share blocks held by institutional investors and restricted shares owned by the company’s officers and insiders.

A company’s outstanding shares are not static and might fluctuate over time. It’s like a kind of product inventory, in which inventory stack and balance reflect the market demand momentum. Moreover, this number correlates with other critical financial performance metrics and the financial ratio at the same time. Thus,  an intrinsic value monitor dashboard should reflect this by automating updating the outstanding shares using an intrinsic value scraper and easy2digital API.

Here takes the symbol aapl for the example of part of the intrinsic value scraper script:

https://marketing-bots.herokuapp.com/api/1/symbol-sharesOutstanding?symbol=&token=

intrinsic value

def shareOutstandingEasy2Digital():

symbolccc = "aapl"

easy2digitalToken = easy2digitalAPIToken

e2dAPI = requests.get('https://marketing-bots.herokuapp.com/api/1/symbol-sharesOutstanding?symbol=' + symbolccc + 'token=' + easy2digitalToken)

return e2dAPI

e2dsharesoutStanding = shareOutstandingEasy2Digital()

print(e2dsharesoutStanding)

Book Value

Book value is a term that describes the basic net worth of a company. It’s the total of its assets minus its liabilities. The book value of a company is simply its assets minus its liabilities. Thus, basically, this number represents the naked value of a company after the tides go away, such as liability, market overvalued calculation, etc

Book value = total asset – total liability

Here takes the symbol aapl for the example of part of the intrinsic value scraper script: 

https://marketing-bots.herokuapp.com/api/1/symbol-balanceSheetStatement?symbol=&token=

intrinsic value

Book value per share (BVPS) vs price per share

Book value / shares outstanding = book value per share. In a way, it reflects the real aspect of the shareholders’ equity value.

Market Cap/shares outstanding = price per share, which is being affected by supply & demand, company news, new business/products, acquisition and merger, governmental tax policy, central bank interest rate, industry/sector’s news (competitor going away, or substitute demand). Regarding the real-time price per share data feed, please refer to the other tutorial as listed below:

Python Tutorial 60 – Stock Symbol Data Scraper for Financial Ratio Analysis

Basically, when BVPS is less than the market price per share, the company is undervalued. Apart from that, there are two signals implying opportunities as well.

First thing first, the BVPS is slightly greater than the market price per share. The other is the financial ratio common sizing comparison in the same industry. Usually, we use the equation BVPS / market price per share to compare the ratio. It’s because sometimes in some industries, it’s difficult to find symbols BVPS that is less than the actual price.

Full Script of Intrinsic value scraper and Easy2Digital API Token

If you are interested in the Easy2Digital financial statement API, and the full python script of Intrinsic Value Scraper for Comparing BVPS vs Price per Share Using Easy2Digital API, please subscribe to our newsletter by adding the message “Python Tutorial 62, Financial Statement API 13”. We would send you the script immediately to your mailbox.

I hope you enjoy reading Easy2Digital financial statement API, and Python Tutorial 62 – Intrinsic Value Scraper for Comparing BVPS vs Price per Share Using Easy2Digital API. If you did, please support us by doing one of the things listed below, because it always helps out our channel.