Grayscale GSOL Solana Financials [NeoButane]This script shows Grayscale's GSOL financials based on the information from their website. Investors and traders like to use financials when making the decision to buy, sell, or hold.
►Usage
This script is specific to GSOL. Investors and traders use financials when making the decision to buy, sell, or hold. How one interprets financials is up to the individual. For example, investors who believe a Solana ETF is coming soon can view the "% Discount / Premium to NAV", which is currently over 600%, and decide not to buy because the premium would collapse if an ETF began trading.
►Configuration
Data select the data you'd like to display.
Show Highest label show the highest value of the entire data set.
Line Color an expression of self.
Extrapolate Data Using Average or Last Known Value Shows a line beyond the dataset, using the average of all past data or the last data point to predict newer data. % Discount / Premium to NAV, Share Premium, and SOL Per Share are supported.
→Data retrieved from Grayscale
AUM assets under management.
NAV net asset value.
Market Price market price of GSOL.
Shares Outstanding number of shares held in the open market.
→Data retrieved from Grayscale, modified by me
% Discount / Premium to NAV the % away NAV is from the market price of GSOL.
Formula: (GSOL - NAV) / NAV
Share Premium the actual $ premium of GSOL to its NAV.
Formula: GSOL - NAV
SOL Per Share the amount of SOL 1 share of GSOL can redeem. This is derived using Kraken's SOLUSD daily close prices.
Formula: Kraken's SOLUSD / NAV
SOL Price Using Market Price Premium the price of SOL if GSOL's market price was "correct" and the SOL Per Share ratio remained the same.
Formula: GSOL / SOL Per Share
►How this works
Grayscale has a spreadsheet of historical data available on their GSOL page. Since financials are not available for OTC:GSOL, I placed all the data into arrays to emulate a symbol's price (y) coordinates. UNIX time for each day, also in an array, is used as the time (x) coordinates. The UNIX arrays and data arrays are then looped to plot as lines, with data y2 being the next data point, making it appear as a continuous line.
Grayscale's GSOL was downloaded spreadsheet and opened in Excel. SOLUSD prices were exported using TradingView export function. The output of information was pasted into Pine Script. For matching up Kraken's SOLUSD prices to each Grayscale's data since GSOL does not trade daily, dates were converted to UNIX and matched with xlookup(). A library or seed will be used in the future for updating.
References
Data retrieved from Grayscale's website 2024/08/04.
www.grayscale.com
Quantity of Solana held by the trust can be seen in their filings. Ctrl + F "Quantity of
SOL "
www.grayscale.com
Q1 2024: www.grayscale.com
The high premium can partly be explained by private placement currently being closed. This means private sales can't dilute share value.
www.etf.com
Grayscale
Ethereum ETF Tracker (EET)Get all the information you need about all the different Ethereum ETF.
With the Ethereum ETF Tracker, you can observe all possible Ethereum ETF data:
ETF name.
Ticker.
Price.
Volume.
Share of total ETF volume.
Fees.
Exchange.
Custodian.
At the bottom of the table, you'll find the ETHE Premium (and ETH per Share), and day's total volume.
In addition, you can see the volume for the different Exchanges, as well as for the different Custodians.
If you don't want to display these lines to save space, you can uncheck "Show Additional Data" in the indicator settings.
The Idea
The goal is to provide the community with a tool for tracking all Ethereum ETF data in a synthesized way, directly in your TradingView chart.
How to Use
Simply read the information in the table. You can hover above the Fees and Exchanges cells for more details.
The table takes space on the chart, you can remove the extra lines by unchecking "Show Additional Data" in the indicator settings or reduce text size by changing the "Table Text Size" parameter.
Aggregate volume can be displayed directly on the graph (this volume can be displayed on any asset, such as Ethereum itself). The display can be disabled in the settings.
Bitcoin ETF Tracker (BET)Get all the information you need about all the different Bitcoin ETFs.
With the Bitcoin ETF Tracker, you can observe all possible Bitcoin ETF data:
The ETF name.
The ticker.
The price.
The volume.
The share of total ETF volume.
The ETF fees.
The exchange and custodian.
At the bottom of the table, you'll find the day's total volume.
In addition, you can see the volume for the different Exchanges, as well as for the different Custodians.
If you don't want to display these lines to save space, you can uncheck "Show Additional Data" in the indicator settings.
The Idea
The goal is to provide the community with a tool for tracking all Bitcoin ETF data in a synthesized way, directly in your TradingView chart.
How to Use
Simply read the information in the table. You can hover above the Fees and Exchanges cells for more details.
The table takes space on the chart, you can remove the extra lines by unchecking "Show Additional Data" in the indicator settings or reduce text size by changing the "Table Text Size" parameter.
Upcoming Features
As soon as we have a little more history, we'll add variation rates as well as plots to observe the breakdown between the various Exchanges and Custodians.
The Real GBTC Premium (Capriole Investments)The real Grayscale Bitcoin (GBTC) premium / discount.
Charts the premium / discount of GBTC trust versus the Bitcoin spot price.
The GBTC premium / discount is frequently calculated incorrectly as it needs to consider the amount of Bitcoin behind each share of GBTC, which changes over time.
This indicator allows for an estimate of that change through time, a more realistic representation of 1 BTC to 1 BTC within GBTC.
If the chart is red, at a discount = can buy a synthetic Bitcoin (GBTC) at a discount to the underlying asset Bitcoin.
If the chart is green, at a premium = can buy a synthetic Bitcoin (GBTC) at a premium to the underlying asset Bitcoin.
The user should also consider that to-date, GBTC charges an annual fee which depletes the value within the GBTC trust. Grayscale wants to convert GBTC to an ETF, but its applications have so far been rejected by the SEC.
If GBTC is converted to an ETF in the future, we might expect that any GBTC discount shown here will be neutralized; potentially offering an additional return to any holder of GBTC, though this cannot be known for sure until such a conversion occurs.
BTC Premium (Grayscale & Coinbase)This indicator plots the bitcoin premium on Grayscale and Coinbase in %.
