Financial Data Spreadsheet [By MUQWISHI]The Financial Data Spreadsheet indicator displays tables in the form of a spreadsheet containing a set of selected financial performances of a company within the most recent reported period. Analyzing Financial data is one of the classic methods to evaluate whether the company’s stock price is overvalued or undervalued based on its income statement, balance sheet, and cash flow statement. This indicator might be practical to investors to collect needed data of a company to analyze and compare it with other companies on a TradingView chart or print it in spreadsheet form.
█ OVERVIEW
█ BEST PRACTICES
Due to strict limitations on calling request.financial() function, I tried to develop the table with the best ways to be more dynamic to move and the ability to join multiple tables into a spreadsheet. Users can add up to 20 instruments and 2 financial metrics per table. However, it’s possible to add many tables with other financial metrics, then connect them to the main table.
Credits: The idea of joining multiple tables inspired by @QuantNomad Screener for 40+ instruments
█ INDICATOR SETTINGS
1- Moving Table toward right-left up-down from its origin.
2- Hiding Column Title checkmark. Useful for adding a joined table underneath with additional instruments.
3- Hiding Instruments Title checkmark. Useful for adding a joined table on the right with other financial metrics.
4- Shade Alternate Rows checkmark. I believe it’ll make the table easier to read.
5- Selecting Financial Period. (Year, Quarter).
6- Entering a currency.
7- Choosing a financial ID for each column. There’re over 200 financial IDs. Source: What financial data is available in Pine? — TradingView
8- Optional to highlight values in between.
9- Entering the ticker’s symbol with the ability to activate/deactivate.
█ TIP
For best technical performance, use the indicator in a 1D timeframe.
Please let me know if you have any questions.
Thank you.
Fundamental Analysis
Fair Price [XSfera]The indicator allows you to quickly compare business growth rates (by default, earnings per share, EPS) and stock prices to determine overbought or undervalued.
The financial parameter as a percentage fits together several years ago, by default 5, and displays the dynamics. To date, it allows you to see how much the price is higher or lower than fair. The lag in the share price from the growth rate of the business is often called the margin of safety, which makes it safer to invest. Of course, this does not mean that the market will quickly return to a fair course, the market can live its life for a long time.
It is important that the dynamics will be incorrect if the financial parameter at the beginning of the docking is negative, for example, as in TSLA and not very correct in the case of a low base, i.e. when the company only went into profit 5 years ago.
Индикатор позволяет быстро сравнить темпы роста бизнеса (по-умолчанию прибыль на акцию, EPS ) и цены акции, для определения перекупленности или недооценки.
Финансовый параметр в процентном соотношении стыкуется несколько лет назад, по-умолчанию 5, и отображает динамику. На сегодняшний день позволяет увидеть насколько цена выше или ниже справедливой. Отставание цены акции от темпов роста бизнеса, часто называют маржой безопастности, которая позволяет безопаснее инвестировать. Само собой это не значит что рынок быстро вернется в справедливое русло, рынок может долгое время жить своей жизнью.
Важно что динамика будет неверной если финансовый параметр на начало стыковки будет отрицательным, например как в TSLA и не очень корректным в случае низкой базы, т.е. когда компания только только 5 лет назад вышла в прибыль.
The Price of Hard MoneyIf we calculate “the price of hard money” (the market capitalization weighted price of gold plus Bitcoin); we get this chart.
Since 2017, Bitcoin’s share of hard money growth has been increasing, we can see it visibly on the gold chart by a widening delta between the price of hard money and the Gold price. We can also see some interesting technical behaviours.
In 2021, Hard Money broke out and held this breakout above the 2011 Gold high. Only later in 2022 did a correction of 20% occur – typical of Golds historic volatility in periods of inflation and high interest rates.
Hard Money is at major support and we have evidence for a fundamental shift in investor capital flows away from gold and into Bitcoin.
This Indicator is useful:
- To track the market capitalization of Gold (estimated), Bitcoin and combined market capitalization of Hard Money.
- To track the price action and respective change in investor flows from Gold to Bitcoin .
Provided Bitcoin continues to suck more value out of gold with time, this chart will be useful for tracking price action of the combined asset classes into the years to come.
Quarterly Revenue Labelshow stock reported revenue on a quarter over quarter basis. change percent calculated from a rolling month to previous month basis
Multi-Polar WorldA new macro analysis tool for easily analyzing the multi-polar world's economic powerhouses / spheres of influence, making for an easy to use visual when comparing a number of statistics:
GDP, GDP per Capita, External Debt, Government Debt, Exports, Imports, Gold Reserves, Employed Persons, Military Expenditure, Population, Bank Lending Rate, Balance of Trade, Central Bank Balance Sheet, M2 Money Supply, and CPI . Includes option to provide the total for each pole, or view individually for more detailed comparison. Meant to be used when analyzing the macro-economic conditions/trends in conjunction with other "Big Picture" type indicators when adjusting your macro framework.
USTS Yield Curve InversionsVisualization of the inverted portions of the USTS yield curve.
Red means that portion of the curve is inverted.
If 1M is red, it means it's less than RRP%.
Master LTCBTC Network Value ModelThe Master LTCBTC Network Value Model takes the following 6 network values for Litecoin. It compares them to Bitcoin's network values to determine a "fair" value based on Litecoin's network usage compared to Bitcoin's.
Please apply on an LTCBTC chart. Use Black Background to view.
This also includes an average of the 6 network metrics and is colored white with a slightly large line width.
New Addresses
Total Addresses
Active Addresses
Total Volume USD
Transaction Count
# of Retail
Master Litecoin Network Value ModelThe Master Litecoin Network Value Model takes the following 6 network values for Litecoin. It compares them to Bitcoin's network values to determine a "fair" value based on Litecoin's network usage compared to Bitcoin's.
Please apply on an LTCUSD chart
This also includes an average of the 6 network metrics and is colored white with a slightly large line width.
New Addresses
Total Addresses
Active Addresses
Total Volume USD
Transaction Count
# of Retail
Quantum Vector AlertsIts the part 2 of Multiple Indicators 50EMA Cross Alerts.
Its more suitable for the seconds chart. Beside, you can use it in higher timeframe.
The input bars length is the sample size that the code will use to trigger all alert. 20 mean 20 bar after the current candle.
When you activate volume alert you can select an amount of volume that when volume cross it you will be notified. The volume of every bar is displayed in the screener below volume.
In the section percentage vector counting the script do the sum of the red vector and green vector and give a ratio. In bullish vector count percentage for alert, you can select the percentage difference that you want to receive an alert. If your sample have 3 red vectors and 7 green vectors you will receive an alert saying that there is an imbalance of 70% showing more green vectors.
You can select a variant of percentage vector. The variant will do a summation of volume. If 1 vector candle is the size of the 3 other vector, they will have the same ponderation.
Normal alert counting count the number of vectors in the bars length. You can count the red and green candle only or add the blue and violet.
Bullish vector count will show a notification when the number of green candle will appear on the chart in the selected length. The same process is valid for bearish vector count. For example, if you want 3 bullish candle in 20 bar. You select bars length 20 and bullish vector count 3.
These alerts are suitable to the hybrid system. Thanks to our teacher Trader Reality and to all the member that contribute to this great discord community.
Outliers Detector with N-Sigma Confidence Intervals (TG fork)Display outliers in either value change, volume or volume change that significantly deviate from the past.
This uses the standard deviation calculation and the n-sigmas statistical rule of significance, with 2-sigma (a value of 2) signifying that the observed value is stronger than 95% of past values, and 3-sigma 98.5% of past values, and so on for higher sigma values.
Outliers in price action or in volume can indicate a strong support for the move, and hence potentially more moves in the same direction in the future. Inversely, an insignificant move is less likely to be supported. And of course the stronger, the more support.
This indicator also doubles as a standard volume indicator if volume is selected as the source, but with the option of highlighting outliers.
Bars below significance can be uncolored (gray) to unclutter the visuals.
Differently to almost all other similar indicators, the background highlighting is dynamical, so that all values will be highlighted differently, not just 2-sigma or 3-sigma, but also 4-sigma, 5-sigma, etc, with a different value of transparency.
The dynamical transparency value can be calculated in two ways: either statically proportionally to the n-sigma but capped at 10-sigma, or either as a ratio relative to the highest observed sigma value over the defined lookback period (default: 300).
If you like this indicator, which is an extension of previously published indicators, please give some love to the original authors:
* tvjvzl :
* vnhilton :
This extension, authored by Tartigradia, extends tvjvzl's indi, implements vnhilton's idea of highlighting the background, and go further by adding dynamical background highlighting for any value of sigma, add support for volume and volume change (VolumeDiff) as inputs, add option to uncolor insignificant bars, allow plotting in both directions and more.
Enterprise Value on Earnings / FCF / FFO Band Enterprise Value per Diluted Share plotted as black line.
Bands start at 5x and stops at 30x, each represents a 5x increment.
Band Options (per Diluted Share, Fiscal Year):
①Free Cash Flow
②Operating Income
③Adjusted Funds from Operations
④Core Earnings
where:
AFfO = FFO - Unusual Income/Expenses + Tax Distortion (dafault 25% tax rate)
Core Earnings = Net Income - Unusual Income/Expenses + Tax Distortion (default 25% tax rate)
These two adjustments are coarse and watered-down, so take them with a grain of salt.
For professional assessments of Core Earnings versus GAAP Earnings you may go to David Trainer at Great Speculations(costs money). I am unaffiliated with these entities.
Tips:
①③ are unapplicable to financials.
③ may work for REIT-like companies whose depreciation is mostly overstated(e.g. hydro-elec utility companies whose dams typically don't wear out in ten years; companies with assets that APPRECIATE in reality but they D&A them anyway).
Probably none works for cyclicals, especially extreme boom-bust cyclicals such as oil, aluminum & shipping etc.
Beware unnaturally low (dividend_payout+buyback)/net_income ratio as some majority shareholders may funnel money to themselves/cronies at the expense of small shareholders.
Disclaimer: Use at your own discretion. No guarantees for any accuracy or usefulness. If you decide to use it, I take no responsibility whatsoever for any consequences. Does not constitute financial advice. Past performance is not Indicative of future results.
S&P 500 Quandl Data & RatiosTradingView has a little-known integration that allows you to pull in 3rd party data-sets from Nasdaq Data Link, also known as Quandl. Today, I am open-sourcing for the community an indicator that uses the Quandl integration to pull in historical data and ratios on the S&P500. I originally coded this to study macro P/E ratios during peaks and troughs of boom/bust cycles.
The indicator pulls in each of the following datasets, as defined and provided by Quandl. The user can select which datasets to pull in using the indicator settings:
Dividend Yield : S&P 500 dividend yield (12 month dividend per share)/price. Yields following June 2022 (including the current yield) are estimated based on 12 month dividends through June 2022, as reported by S&P. Sources: Standard & Poor's for current S&P 500 Dividend Yield. Robert Shiller and his book Irrational Exuberance for historic S&P 500 Dividend Yields.
Price Earning Ratio : Price to earnings ratio, based on trailing twelve month as reported earnings. Current PE is estimated from latest reported earnings and current market price. Source: Robert Shiller and his book Irrational Exuberance for historic S&P 500 PE Ratio.
CAPE/Shiller PE Ratio : Shiller PE ratio for the S&P 500. Price earnings ratio is based on average inflation-adjusted earnings from the previous 10 years, known as the Cyclically Adjusted PE Ratio (CAPE Ratio), Shiller PE Ratio, or PE 10 FAQ. Data courtesy of Robert Shiller from his book, Irrational Exuberance.
Earnings Yield : S&P 500 Earnings Yield. Earnings Yield = trailing 12 month earnings divided by index price (or inverse PE) Yields following March, 2022 (including current yield) are estimated based on 12 month earnings through March, 2022 the latest reported by S&P. Source: Standard & Poor's
Price Book Ratio : S&P 500 price to book value ratio. Current price to book ratio is estimated based on current market price and S&P 500 book value as of March, 2022 the latest reported by S&P. Source: Standard & Poor's
Price Sales Ratio : S&P 500 Price to Sales Ratio (P/S or Price to Revenue). Current price to sales ratio is estimated based on current market price and 12 month sales ending March, 2022 the latest reported by S&P. Source: Standard & Poor's
Inflation Adjusted SP500 : Inflation adjusted SP500. Other than the current price, all prices are monthly average closing prices. Sources: Standard & Poor's Robert Shiller and his book Irrational Exuberance for historic S&P 500 prices, and historic CPIs.
Revenue Per Share : Trailing twelve month S&P 500 Sales Per Share (S&P 500 Revenue Per Share) non-inflation adjusted current dollars. Source: Standard & Poor's
Earnings Per Share : S&P 500 Earnings Per Share. 12-month real earnings per share inflation adjusted, constant August, 2022 dollars. Sources: Standard & Poor's for current S&P 500 Earnings. Robert Shiller and his book Irrational Exuberance for historic S&P 500 Earnings.
Disclaimer: This is not financial advice. Open-source scripts I publish in the community are largely meant to spark ideas that can be used as building blocks for part of a more robust trade management strategy. If you would like to implement a version of any script, I would recommend making significant additions/modifications to the strategy & risk management functions. If you don’t know how to program in Pine, then hire a Pine-coder. We can help!
BTC TOTALVOLUME MOMENTUM: OnchainThis is an indicator for Bitcoin based on on-chain volume. It is important in several ways.
The upward trend of the red line indicates the increase in trading volume and the possibility of an upward trend in the future
The downward trend of the red line indicates a decrease in trading volume and the possibility of a price decrease in the future
The bullish crossover of the red line with the blue line is a confirmation of the bullish trend
A bearish crossover is confirmation of a bearish trend
Bitcoin Miner Extreme SellingThis script is for identifying extreme selling. Judging by the chart, Bitcoin miners often (not always) sell hard for two reasons: to take profit into parabolic price rises, or to stay solvent when the price is very low.
Extreme selling thus often coincides with long-term tops and bottoms in Bitcoin price. This can be a useful EXTRA data point when trying to time long-term Bitcoin spot or crypto equity investment (NOT advice, you remain responsible, etc). The difference between selling measured in BTC and in USD gives a reasonable idea of whether miners are selling to make a profit or to stay solvent.
CREDITS
The idea for using the ratio of miner outflows to reserves comes from the "Bitcoin Miner Sell Pressure" script by the pioneering capriole_charles.
The two request.security calls are identical. Another similarity is that you have to sum the outflows to make it make sense. But it doesn't make much difference, it turns out from testing, to use an average of the reserves, so I didn't. All other code is different.
The script from capriole_charles uses Bollinger bands to highlight periods when sell pressure is high, uses a rolling 30-day sum, and only uses the BTC metrics.
My script uses a configurable 2-6 week rolling sum (there's nothing magical about one month), uses different calculations, and uses BTC, USD, and composite metrics.
INPUTS
Rolling Time Basis : Determines how much data is rolled up. At the lowest level, daily data is too volatile. If you choose, e.g., 1 week, then the indicator displays the relative selling on a weekly basis. Longer time periods, obviously, are smoother but delayed, while shorter time periods are more reactive. There is no "real" time period, only an explicit interpretation.
Show Data > Outflows : Displays the relative selling data, along with a long-term moving average. You might use this option if you want to compare the "real" heights of peaks across history.
Show Data > Delta (the default): Only the difference between the relative selling and the long-term moving average is displayed, along with an average of *that*. This is more signal and less noise.
Base Currency : Configure whether the calculations use BTC or USD as the metric. This setting doesn't use the BTC price at all; it switches the data requested from INTOTHEBLOCK.
If you choose Composite (the default), the script combines BTC and USD together in a relative way (you can't simply add them, as USD is a much bigger absolute value).
In Composite mode, the peaks are coloured red if BTC selling is higher than USD, which usually indicates forced selling, and green if USD is higher, which usually indicates profit-taking. This categorisation is not perfectly accurate but it is interesting insomuch as it is derived from block data and not Bitcoin price.
In BTC or USD mode, a gradient is used to give a rough visual idea of how far from the average the current value is, and to make it look pretty.
USAGE NOTES
Because of the long-term moving averages, the length of the chart does make a difference. I recommend running the script on the longest Bitcoin chart, ticker BLX.
To use it to compare selling with pivots in crypto equities, use a split chart: one BLX with the indicator applied, and one with the equity of your choice. Sync Interval, Crosshair, Time, and Date Range, but not Symbol.
[Antipanicos] Year-over-Year YoY ChangeYear-over-year growth compares a company's recent financial performance with its numbers for the same month one year earlier. This is considered more informative than a month-to-month comparison, which often reflects seasonal trends.
Coin & market cap tableThis table was built specifically for the Crypto market.
It gives you a quick overview of the markets without having to scroll through numerous charts. The information is the overall markets daily change and the charts coins movement on a daily, weekly and monthly basis.
The weeks start on a Monday morning, the months start on the 1st of the month so this is last weeks data and last calendar months data.
It also gives you Bitcoins dominance. (Total2) you can change it to Bitcoin & Ethereum dominance (Total3)
Rule Of 20 - Fair Value Estimation by Inflation & Earnings (TG)The Rule Of 20 is a heuristic calculation to find the fair value of an asset or market given its earnings and current inflation.
Its calculation is straightforward: the fair multiple of the price or price-to-earnings ratio of a stock should be 20 minus the rate of inflation.
In math terms: fair_price-to-earnings_ratio = (20 - inflation) ; fair_value = current_price * fair_price-to-earnings_ratio / real_price-to-earnings_ratio
For example, if a stock or index was trading on 11 times earnings and inflation was 2%, then the theory would be that the fair price-to-earnings ratio would be 20-2 = 18, which is much higher than the real price-to-earnings ratio of 11, and hence the asset would be undervalued.
Conversely, a market or company that was trading on 18 times price-to-earnings ration when inflation was 8% was seen as overvalued, because of the fair price-to-earnings ratio being 20-8=12, hence much lower than the real price-to-earnings ratio of 18.
We can then project the delta between the fair PE and real PE onto the asset's value to obtain the projected fair value, which may be a target of future value the asset may reach or hover around.
For example, as of 1st November 2022, SPX stood at 3871.97, with a PE ratio of 20.14 and an inflation in the US of 7.70. Using the Rule Of 20, we find that the fair PE ratio is 20-7.7=12.3, which is much lower than the current PE ratio of 20.14 by 39%! This may indicate a future possibility of a further downside risk by 39% from current valuation levels.
The origins of this rule are unknown, although the legendary US fund manager Peter Lynch is said to have been an active proponent when he was directing the Fidelity’s Magellan fund from 1977 to 1990.
For more infos about the Rule Of 20, reading this article is recommended: www.sharesmagazine.co.uk
This indicator implements the Rule Of 20 on any asset where the Financials are availble to TradingView, and also for the entire SP:SPX index as a way to assess the wider US stock market. Technically, the calculation is a bit different for the latter, as we cannot access earnings of SPX through Financials on TradingView, so we access it using the QUANDL:MULTPL/SP500_PE_RATIO_MONTH ticker instead.
By default are displayed:
current asset value in red
fair asset value according to the Rule Of 20 in white for SPX, or different shades of purple/maroon for other assets. Note that for SPX there is only one calculation, whereas for other assets there are multiple different ways to calculate earnings, so different fair values can be computed.
fair price-to-earnings ratio (PE ratio) in light grey.
real price-to-earnings ratio in darker grey.
This indicator can be used on SP:SPX ticker, and on most NASDAQ:* tickers, since they have Financials integrated in TradingView. Stocks tickers from other exchanges may not provide Financials data, so this indicator won't work then. If this happens, try to find the same ticker on NASDAQ instead.
Note that by default, only the US stock market is considered. If you want to consider stocks or assets in other regions of the world, please change the inflation ticker to a ticker that reflect the target region's inflation.
Also adding a table to ease interpretation was considered, but then the Timeframe MTF parameter would not work, and since the big advantage of this indicator is to allow for historical comparisons, the table was dropped.
Enjoy, and keep in mind that all models are wrong, but some are useful.
Trade safely!
TG
BTC NEW ADDRESS MOMENTUM: OnchainThis is a new oscillator that works based on the momentum of new addresses in the Bitcoin blockchain. Use this oscillator on the daily time frame. This oscillator consists of 2 moving averages on the number of new addresses. 30-day and 365-day moving averages. The upward crossover of the number of new addresses is usually associated with the beginning of an upward trend, and the downward crossover is associated with the beginning of a downward trend on the price chart.
Economic Calendar (Import from Spreadsheet)This script draws vertical lines to mark Economic Calendar Events.
Datetime of events is defined by user in Settings via a standardized line of text.
Motivation for coding this script:
All traders should be aware of economic calendar events. At times, when you really need to pay attention to an upcoming major event, you might even decide to use the vertical-line drawing tool to mark it. However, this takes manual effort.
This script provides a solution to performing mundane tasks such as drawing vertical lines and dragging them ever so slightly, just to have them approximately aligned with exact time.
Parameters:
(1) Source data - String representation of collection of datetime referencing to Economic Calendar Events
(2) Line color, & (3) Width of line - For displaying vertical lines drawn by script.
Standardized format for Source Data :
Example:
If 'GMT;2022,6,1,14,0,0;2022,6,2,12,15,0;' is provided to PineScript, then two vertical lines will be drawn on June 6, 2022 according to the exact time in 'YYYY,MM,DD,hh,mm,ss' format at the specified timezone (GMT in this case).
Template for Source Data :
Included here, link below, is a shared Google Sheet that systematically processes Economic Calendar data provided in the 'Raw Data' tab.
drive.google.com
Users are advised to use their preferred methods* to format the string (for source data param.), and apply their own criteria to sort down the Events. (ie. only include Events of High Impact, etc.)
* Preferred methods (as mentioned above) does not mean being limited to using the template as provided in this post.
Bitcoin Miner Sell PressureBitcoin miners are in pain and now (November 2022) selling more than they have in almost 5 years!
Introducing: Bitcoin Miner Sell Pressure.
A free, open-source indicator which tracks on-chain data to highlight when Bitcoin miners are selling more of their reserves than usual.
The indicator tracks the ratio of on-chain miner Bitcoin outflows to miner Bitcoin reserves.
- Higher = more selling than usual
- Lower = less selling than usual
- Red = extraordinary sell pressure
Today , it's red.
What can we see now ?
Miners are not great at treasury management. They tend to sell most when they are losing money (like today). But there have been times when they sold well into high profit, such as into the 2017 $20K top and in early 2021 when Bitcoin breached $40K.
Bitcoin Miner Sell Pressure identifies industry stress, excess and miner capitulation.
Unsurprisingly, there is a high correlation with Bitcoin Production Cost; giving strong confluence to both.
In some instances, BMSP spots capitulation before Hash Ribbons. Such as today!
Minervini QualifierThe Minervini Qualifier indicator calculates the qualifying conditions from Mark Minervini’s book “Trade like a Stock Market Wizard”.
The condition matching is been shown as fill color inside an SMA 20day envelope curve.
If the envelope color is red, current close price is below the SMA20 and when blue, current close price is above the SMA20. The fill color can be transparent (not matching qualifying conditions), yellow (matching all conditions except close is still below SMA50), green (all conditions match, SMA200 trending for at least one month up) or blue (all conditions match, SMA200 trending up for at least 5 months)
As I wanted also to see which of the qualifying conditions match over time, I’ve added add. lines, each representing one conditions. If it matches, line color is blue, or red if not. Use the data windows (right side), so you know what line represents which condition. Can be turned on/off (default:on)
In addition, a relative strength is been calculated, to compare the stock to a reference index. It is just one possible way to calculate it, might be different to what Mark Minervini is using. If the shown value (top right) is above 100, stock performs better compared to reference index (can be set in settings), when below 100, stock performs worse compared to reference index. Can be turned on/off (default:on)
How to use it:
For more details, read Mark’s book and watch his videos.
Limitations:
It gives only useful information on daily timeframe
(No financial advise, for testing purposes only)
Net LiquidityThis is an indicator that plots Net Liquidity.
The Net Liquidity function is simply: Fed Balance Sheet - Treasury General Account - Reverse Repo Balance
Net Liquidity can be used to ball park how much money is in the system and how it will affect various markets' performance.
Its primary purpose is showing how to use the NetLiquidityLibrary
CROCEUsing free cash flow instead of ebit, to be able to evaluate stocks that are not yet profitable.
the formulas are
fcf ttm / (not financial operating working capital - Cash + Net Property Plant and Equipment)
and
fcf yield on Enterprice Value
Example CRWD negative ebit, but cash creation, in this case the expenses in research and development go to affect the ebit.
