Home Artists Posts Import Register

Content

The new Osprey Solana trust product is now available in the model

Please note that the price currently displayed in YELLOW will not be automatically updated. This is due to the lack of an automated price feed for the SOL and OSOL tickers at the current time. If you know how to implement this functionality as soon as possible without requiring a separate API setup let me know.

Additionally, please remember that all of my spreadsheets are designed to be copied and shared. However, I do not share them directly due to past issues with users modifying the formulas and causing errors. If you would like a copy of this spreadsheet, please go to File > Make a Copy.

I will not grant edit access to many users to avoid similar problems in the future.


Files

GBTC ETHE GSOL MSTR Premium Disc Calculator Dec 2023

MAIN SHEET DO NOT CHANGE FORMULAE BTC PRICE,GBTC,BTC per GBTC,GBTC Discount over BTC,0.00093,Was,Delta $41,131.90,$32.46,0.00089661,-11.98%,Now,0.000939664,0.0007891685043,HISTORY,$36,203.03,BTC per GBTC June 2022,0.00092277,-49%,309% To own 1 Bitcoin w GBTC you #GBTC,1115.31212,$36,203,Last m...

Comments

Anonymous

Cell D9 should probably read "OSOL..." instead of "GSOL..."?

Anonymous

I think the MSTR premium is wrong. Sheet says they have 158,400 BTC but after their latest purchase they have > 174K bitcoin. Isn't that correct? https://www.coindesk.com/markets/2023/12/04/coinbase-microstrategy-jump-in-premarket-trading-as-bitcoin-rallies/