OPEN-SOURCE SCRIPT
Updated MicroStrategy Metrics
A script showing all the key MSTR metrics. I will update the script every time degen Saylor sells some more office furniture to buy BTC.
All based around valuing MSTR, aside from its BTC holdings. I.e. the true market cap = enterprise value - BTC holdings. Hence, you're left with the value of the software business + any premium/discount decided by investors.
From this we can derive:
- BTC Holdings % of enterprise value
- Correlation to BTC (in this case we use CME futures...may change this)
- Equivalent Share Price (true market cap divided by shares outstanding)
- P/E Ratio (equivalent share price divided by quarterly EPS estimates x 4)
- Price to FCF Ratio (true market cap divided by FCF (ttm))
- Price to Revenue (^ but with total revenue (ttm))
All based around valuing MSTR, aside from its BTC holdings. I.e. the true market cap = enterprise value - BTC holdings. Hence, you're left with the value of the software business + any premium/discount decided by investors.
From this we can derive:
- BTC Holdings % of enterprise value
- Correlation to BTC (in this case we use CME futures...may change this)
- Equivalent Share Price (true market cap divided by shares outstanding)
- P/E Ratio (equivalent share price divided by quarterly EPS estimates x 4)
- Price to FCF Ratio (true market cap divided by FCF (ttm))
- Price to Revenue (^ but with total revenue (ttm))
Release Notes
UpdatedRelease Notes
Updated 27/03/23Release Notes
UpdatedRelease Notes
UpdatedRelease Notes
UpdatedRelease Notes
Saylor found another $593m behind the office furnitureRelease Notes
Updated to include BTC per 100 SharesRelease Notes
UpdatedRelease Notes
Updated to include the share price denominated in BTC/ShareRelease Notes
190,000Release Notes
193,000Release Notes
Convertible Note PurchaseRelease Notes
214,246 BTCRelease Notes
226,331Release Notes
169 BTCRelease Notes
244,800Release Notes
252,220Release Notes
2BN down, $40bn to goRelease Notes
$6.6bn down, $35.4bn to goRelease Notes
12bn down, 30bn to goRelease Notes
13.5bn down, 28.5bn to goRelease Notes
15bn down, 27bn to goRelease Notes
444,262 BTCRelease Notes
446,400 BTCRelease Notes
446,400 BTCRelease Notes
447,470 BTCRelease Notes
450,000 BTCRelease Notes
461,000 BTCRelease Notes
471,107 BTCRelease Notes
506,137Release Notes
528,185 BTCOpen-source script
In true TradingView spirit, the creator of this script has made it open-source, so that traders can review and verify its functionality. Kudos to the author! While you can use it for free, remember that republishing the code is subject to our House Rules.
Disclaimer
The information and publications are not meant to be, and do not constitute, financial, investment, trading, or other types of advice or recommendations supplied or endorsed by TradingView. Read more in the Terms of Use.
Open-source script
In true TradingView spirit, the creator of this script has made it open-source, so that traders can review and verify its functionality. Kudos to the author! While you can use it for free, remember that republishing the code is subject to our House Rules.
Disclaimer
The information and publications are not meant to be, and do not constitute, financial, investment, trading, or other types of advice or recommendations supplied or endorsed by TradingView. Read more in the Terms of Use.