Financials Index ComboFinancials Index Combo includes 2 languages Vietnamese and English:
Note the abbreviations:
Rev: Total revenue (Diluted EPS)
Gross: Gross profit
OI: Operating Income
C: Deferred Income, Current
N: Deferred Income, Non-Current
INV: Total inventories (Inventory turnover)
TAS: Total assets (Asset turnover)
Ev/Ed: Enterprise value to EBITDA ratio
ROIC: Return on invested capital
ROA: Return on assets
ROE: Return on equity
TA: Return on tangible assets
TE: Return on tangible equity
G: Sustainable growth rate
FCO: Cash From Operating Activities
FCF: Free Cash Flow
D: Debt to equity ratio
L: Long term debt to total assets ratio
E: Debt to EBITDA ratio
M: Current ratio
S: Sloan ratio -10 -> 10 --> safe zone
H: Fulmer H <0 --> struggling with its finances
>0 --> stable condition
F_score: Piotroski F-score 0 - 9
TCA: Total Current Assets
Rev/TCA: Total revenue to Total Current Assets ratio
Graham: Graham's number
NCAVPS: Net current asset value per share
Convert to billions:
Real Time Table:
Quarterly or annual financial statements
Financials Index For Bank:
Fundamental-analysis
Financial Intelligent Eval [Fundamental] (MYTRIC)█ OVERVIEW
Financial Algorithm is a system to quickly understanding company fundamental, and judge the company type based on their financial condition.
All evaluation from the system is the result of combination with Balancing Calculation and Company Historical Financial Data(Financial Report) by using over than 30 financial ratios.
This indicator are classified into 5 level (Very Weak, Weak, Moderate, Good, Excellent)
Advantages of Financial Algorithm
• By combining and calculating company's latest 4 quarterly report, provide rating to help investor quickly know about company's fundamentals and financial performance.
• Able to identify company have what kind of strength, weakness, chance and threat. For instance, according to current economic situation, is it an advantages or a threat for a company, investor can identify it via Financial Algorithm.
• Able to identify which company have better business management by keep following the company rating, observe the improvement level of company's.
Application
*When notice there are not improvement on a company's fundamentals or financial performance which is profitable without further developing, it usually reveals the lack of management capability to generate more value, company unable to fully utilise its profit, reinvest and expanding its business to become more competitive. Sometimes this kind of company may be suspected accounting fraud.
█ BENEFITS
• Avoid investing in companies suspected of financial fraud.
• To quickly understanding company's fundamental and financial structure.
• Able to analyze whether the company build profit after it is used to optimize the company's internal
█ FEATURES
You can configure the following attributes of the display:
• Table position on your chart.
• The size and colour of text.
• Language between English and Chinese.
• Rating bar chart colour.
• On / Off Statement Review Helper Function
• On / Off 3 Years Evaluation Function
• On / Off Basic Information
• Full descriptions of each evaluation and content are included in the settings
█ LIMITATIONS
• When changing the indicator's inputs, allow around 20 seconds calculation for the change to be reflected in the display.
• This system only able to evaluate non-financial industry.
• This system is based on company's historical financial report data to generate the results and rating, it does not includes prediction from any external factor.
(External Factor: Business Model, Business Distribution & Geography, Corporate Structure, Competitor and Peer company's, Prospect, Costing Breakdown, Disaster and etc)
• Any results calculated by this system all is based on data provided by Tradingview, Data may have some tolerance, we recommend that users pay attention to the official quarterly/annual report.
█ FINANCIALS INTELLIGENT ALGORITHM FUNCTION
This lists all combination calculate financials.
01. Total Revenue
02. Earnings before interest and tax
03. Net Income
04. Property, Plant, and Equipment
05. Total Receivables
06. Cash and short-term Investments
07. Cash & Cash equivalents
08. Total Liability
09. Working Capital
10. Total Debt
11. Total Equity
12. Retained Earnings
13. Total Asset
14. Cash From Operating Activities
15. Income before extraordinary items
16. Total depreciation and amortization
17. Free Cash Flow
18. Altman Z-score
19. Cash to Debt Ratio
20. Current Ratio
21. Debt to Assets Ratio
22. Debt to Equity ratio
23. EBITDA Margin
24. Free Cash Flow Margin
25. Grahams Number
26. Net Margin
27. Price Book Ratio
28. Piotroski-F Score
29. Quick Ratio
30. Return on Assets
31. Return on Equity
32. Return on Invested Capital
33. Float Shares Outstanding
34. Total Common Shares Outstanding
35. Cash to Revenue
36. Cash to Market Capital
37. Cash to Debt
38. Receivable Turnover
39. Quality of Earning
40. Market Capital
8 financial evaluation :
3 years financial evaluation tracking :
Statement Review Helper :
█ HOW TO MAKE THE RIGHT INVESMENT OR TREND TRADING DECISION BASED ON OUR EVALUATION
Avoid mid/long term invest in companies with poor financial evaluation, only suite for trend trading. The below following assessments need to be focused.
• Comprehensive rating is poor or below.
• Quality of Earning is very poor or below.
• Receivability is very poor or below (Total Receivable is too high)
• Before : Poor Financial Strength with revenue growth
• After : The price dropped by about -80% within 2 months
███████████████████████████████████████████████████████████████████████████████████████████
• Before : Poor Financial Strength with revenue growth
• After : The price dropped by about -90% within 1 year
███████████████████████████████████████████████████████████████████████████████████████████
• Before : Excellent Financial Strength
• After : Steady growth
Steady growth
• Conclusion :
Do not judge it as a good company just because it has continuous income.
When we analyze the company's financial report, we should not only look at the company's revenue,
we should pay more attention to the company's finances and weaknesses.
Only companies with strong financial strength that can expand their business in a stable manner.
Disclaimer :
*The following conclusion are purely based on my personal opinions and views, it’s only for study and research, without any trading and investment advice.
Key Financials on ChartA simple table with a couple of key financials
The metrics are (top to bottom and left to right):
- Market cap
- P/S-ratio and forward P/S-ratio
- P/E-ratio and P/FCF-ratio
- Debt/Equity and Assets/Equity ratios
- Price/Book-ratio and Operating Margin
- Pietrosky F-Score and current Dividend Yield
should be enough to get a first idea about fundamentals of growth or value-stocks...
TradingGroundhog - Fundamental Analysis - Multiple RSI Ema(Script Available Version of my previous Fundamental Analysis - Multiple RSI Ema )
As the number of crypto currencies is expanding, we need to find the one which will boom in the next months, weeks or even days.
Therefore, I present to you a Fundamental Analysis tool based on RSI built in order to compare the RSI between the diverse cryptocurrencies.
When cryptocurrencies start to trend, become active, minable and especially "buyable", people are investing their money into them.
As a result,the Daily RSI rises and the price of the crypto in question increases steadily.
With "Fundamental Analysis - Multiple RSI EMA" you can :
Follow up to 20 RSI from different exchanges at the same time.
Find easily Increasing/Decreasing RSI as the lines get transparent if their RSI decrease.
You can also select market with high potential of booming as :
Booming Market : 60 < Daily RSI <= 100 (Strong green background)
Potent Market : 55 < Daily RSI <= 60 (Light green background)
Sleepy Market : 50 < Daily RSI <= 55 (Light red background)
Dying Market : 0 < Daily RSI <= 50 (Strong red background)
Futur booming crypto will go from the Potent Market to the Booming Market
Can be used with the following time frames depending on the necessity:
4H
Daily (Preferred)
Weekly
Monthly
Good trades !
Disclaimer (As it should always be one to any script)
***
This script is intended for and only to be used for personal purposes only. No such information provided by it constitutes advice or a recommendation for any investment or trading strategy for any specific person. There is no guarantee presented or implied as to the accuracy of specific forecasts, projections, or predictive statements offered by the script. Users of the script agree that its original developer does not take responsibility for any of your investment decisions. Please seek professional advice before trading.
***
Fundamental Analysis - Multiple RSI EMAAs the number of crypto currencies is expanding, we need to find the one which will boom in the next months, weeks or even days.
Therefore, I present to you a Fundamental Analysis tool based on RSI built in order to compare the RSI between the diverse cryptocurrencies.
When cryptocurrencies start to trend, become active, minable and especially "buyable", people are investing their money into them.
As a result,the Daily RSI rises and the price of the crypto in question increases steadily.
With "Fundamental Analysis - Multiple RSI EMA" you can :
Follow up to 20 RSI from different exchanges at the same time.
Find easily Increasing/Decreasing RSI as the lines get transparent if their RSI decrease.
You can also select market with high potential of booming as :
Booming Market : 60 < Daily RSI <= 100 (Strong green background)
Potent Market : 55 < Daily RSI <= 60 (Light green background)
Sleepy Market : 50 < Daily RSI <= 55 (Light red background)
Dying Market : 0 < Daily RSI <= 50 (Strong red background)
Futur booming crypto will go from the Potent Market to the Booming Market
Can be used with the following time frames depending on the necessity:
4H
Daily (Preferred)
Weekly
Monthly
Good trades !
Disclaimer (As it should always be one to any script)
***
This script is intended for and only to be used for personal purposes only. No such information provided by it constitutes advice or a recommendation for any investment or trading strategy for any specific person. There is no guarantee presented or implied as to the accuracy of specific forecasts, projections, or predictive statements offered by the script. Users of the script agree that its original developer does not take responsibility for any of your investment decisions. Please seek professional advice before trading.
***
Graham NumberGraham Number is named after the “father of value investing,” Benjamin Graham, who was a mentor of Warren Buffett. The figure takes into account earnings per share and book value per share to measure a stock's maximum fair market value. In other words, it is the upper end of the price range that a defensive investor should pay for the stock.
The Graham Number = Square Root of (22.5) x (tmm EPS) x (mrq Book Value per Share).
The 22.5 is included in the formula as a rule of thumb to account for Graham's assumption that the price-to-earnings ratio should not be over 15 and the price to book ratio should not be over 1.5 for an undervalued stock. So, the number is generated as (P/E of 15) x (P/B of 1.5) = 22.5.
So the script generates a Graham number plot.
© AlpHay : SECURITY FUNDAMENTAL TABLE// Equity Fundamental Data Report Table:
// Data Provider: Tradingview
// I am not a financial advisor or expert.
// This is my interpretation of this data. Consider this data doesn't represent the whole picture of what is going on!
// If you find some fundamentally wrong thinking about this approach, please inform me.
// I am open to suggestions. I am also looking for answers.
// Use it with a daily timeframe for data consistency.
// You can change or customize the threshold values whatever you want.
// www.tradingview.com
Percentile - Price vs FundamentalsThis is done in the same lines of below scripts
Drawdown-Price-vs-Fundamentals
Drawdown-Range
Instead of using drawdown, here we are only plotting percentile of drawdown. Also added few more fundamental stats to the indicator. Also using part of the code from Random-Color-Generator/ to automatically generate colors. This in turn uses code from @RicardoSantos for convering color based on HSL to RGB
This is how the study can be used:
Study plots percentile of price and each of the listed fundamentals based on history. History can be chose All time or particular window. If any fundamental or price is near 100 - which means it is nearer to its peak. And if something is near its bottom, it is nearer to its 0th percentile.
Price of the stock is considered undervalued based on historical levels when it is below most of the fundamentals. Price is considered overvalued based on historical levels when it is above all the fundamentals. Please note, being undervalued does not guarantee immediate mean reversion. Stocks can stay undervalued for prolonged time and can go further down. Similarly overvalued stock can stay overvalued for prolonged time before correcting itself or justifying the position. Hence, further discretion needs to be used while using this study.
Few examples:
AMZN seems to be trading in range and so are the fundamentals:
MSFT at peak along with half of the fundamentals. But, debt levels are going up along with margins reducing.
LPX is trading at 15% discount whereas most of the fundamentals are at the peak.
FLGT price seems to have gone down further whereas fundamentals look pretty healthy.
Drawdown RangeHello death eaters, presenting a unique script which can be used for fundamental analysis or mean reversion based trades.
Process of deriving this table is as below:
Find out ATH for given day
Calculate the drawdown from ATH for the day and drawdown percentage
Based on the drawdown percentage, increment the count of basket which is based on input iNumber of ranges . For example, if number of ranges is 5, then there will be 5 baskets. First basket will fit drawdown percentage 0-20% and each subsequent ones will accommodate next 20% range.
Repeat the process from start to last bar. Once done, table will plot how much percentage of days belong to which basket.
For example, from the below chart of NASDAQ:AAPL
We can deduce following,
Historically stock has traded within 1% drawdown from ATH for 6.59% of time. This is the max amount of time stock has stayed in specific range of drawdown from ATH.
Stock has traded at the drawdown range of 82-83% from ATH for 0.17% of time. This is the least amount of time the stock has stayed in specific range of drawdown from ATH.
At present, stock is trading 2-3% below ATH and this has happened for about 2.46% of total days in trade
Maximum drawdown the stock has suffered is 83%
Lets take another example of NASDAQ:TSLA
Stock is trading at 21-22% below ATH. But, historically the max drawdown range where stock has traded is within 0-1%. Now, if we make this range to show 20 divisions instead of 100, it will look something like this:
Table suggests that stock is trading about 20-25% below ATH - which is right. But, table also suggests that stock has spent most number of days within this drawdown range when we divide it by 20 baskets instad of 100. I would probably wait for price to break out of this range before going long or short. At present, it seems a stage ranging stage. I might think about selling PUTs or covered CALLs outside this range.
Similarly, if you look at AMEX:SPY , 36% of the time, price has stayed within 5% from ATH - makes it a compelling bull case!!
NYSE:BABA is trading at 50-55% below ATH - which is the most it has retraced so far. In general, it is used to be within 15-20% from ATH
NOW, Bit of explanation on input options.
Number of Ranges : Says how many baskets the drawdown map needs to be divided into.
Reference : You can take ATH as reference or chose a time window between which the highest need to be considered for drawdown. This can be useful for megacaps which has gone beyond initial phase of uncertainity. There is no point looking at 80% drawdown AAPL had during 1990s. More approriate to look at it post 2000s where it started making higher impact and growth.
Cumulative Percentage : When this is unchecked, percentage division shows 0-nth percentage instad of percentage ranges. For example this is how it looks on SPY:
We can see that SPY has remained within 6% from ATH for more than 50% of the time.
Hope this is helpful. Happy trading :)
PS: this can be used in conjunction with Drawdown-Price-vs-Fundamentals to pick value stocks at discounted price while also keeping an eye on range tendencies of it.
Thanks to @mattX5 for the ideas and discussion today :)
Drawdown - Price vs FundamentalsIn this study, we are trying to compare drawdown from ATH of price and fundamentals to understand if price drawdown is really justifyable or if this is the buying opportunity.
For example, NYSE:BABA in the chart below shows that price has come down by more than 50%. But, the fundamentals has not changed upto this extent.
This may be viewed as buying opportunity from the eyes of fundamental based trader.
Similarly NYSE:LPX is trading at 15% below ATH whereas fundamentals are at peak. This again can be considered as buying opportunity.
NASDAQ:AAPL on the other hand is trading almost near ATH whereas fundamentals are having higher drawdown.
Well, this is just one factor to consider. I am about to release another script which can demonstrate amount of time (in terms of percentage) instrument trades at certain drawdown range. This looks something like this:
These two scripts can be used in conjunction to define your fundamental based trade.
I can add more funcamentals to the list. But, the higher value of fundamental should correlate to better position. Hence we cannot use things such as PE (which inversely correlates to value). Also need to keep the factor which includes total number of shares in it so that it is not affected by share dilution. Hence, have considered Total Revenue per Share instead of Total Revenue in this script.
Thanks to @mattX5 for suggesting fundamental based ideas in this line :)
Fundamnetals + Strength + RiskManagementCreated indicator to help investors by providing fundamental, technical and Risk Management information on screen for better decision making
you can see
Fundamentals
- Solvency,
- Liquidity
- Growth,
- Profitability
- Patrioski Score
- Altman Z-Score
Technicals
- MAs
- Oscillators
Risk Management
- Position Size
- Stop Loss
- Total Investment
Relative Fundamental ComparisonWhen dealing with stocks, I like to review basic fundamentals of the company. This script displays the fundamental ratios of base chart stock with three other stocks (I can’t increase the number due to security function limitations). I found it particularly important when dealing with an unknown company. I quickly compare the company with other industry leaders to get a comparative fundamental review.
I am very new to Pinescript, so waiting for your comments and review.
Relative Growth ScreenBased on the Growth Range indicator published here:
Instead of plotting, they are printed in color coded table. Colors say whether the growth rate of these factors are relatively higher or lower.
Similar to quality screen, table positions can be customized.
If you have big enough screen, you can fit both quality and growth screens this way:
s3.tradingview.com
Value RangeHere is another attempt to chase value based on technical analysis.
This is extended version of PE range script published earlier.
Instead of just PE, this script contains several other factors which defines value. You can chose which factor to look at from input dialog:
Possible value factors included in this script are:
Price to Earnings
Price to Sales
Price to Book
PE - Forwarding
PS - Forwarding
Price to Cashflow
Enterprise Value to EBITDA
Enterprise Value to Cashflow
Some of these can be added to chart directly from financials. But, the script also calculate range based on donchian channel or bollinger bands. Instead of short periods, we are looking for periods in terms of years. Rest of things remain same.
ROE ValuationAn indicator that can be used to study ROE Valuation for stocks.
Red color means the market price is higher than the valuation whereas green color means the market price is below the valuation and it might be a good opportunity for value traders. Gray color indicates non-applicable results, when valuation is below zero for example.
PE ValuationAn indicator that can be used to study PE Valuation for stocks.
When the reported EPS for a company is non-positive the line turns gray. Red color means the market price is higher than the valuation whereas green color means the market price is below the valuation and it might be a good opportunity for value traders.
DCF ValuationAn indicator that can be used to study Discounted Cash Flow Valuation for stocks.
When the reported Free Cash Flow for a company is non-positive the line turns gray. Red color means the market price is higher than the valuation whereas green color means the market price is below the valuation and it might be a good opportunity for value traders.
Financial Highlights [Fundamentals]█ OVERVIEW
This indicator plot basic key financial data to imitate the presentation format of several popular finance site, make it easier for a quick glance of overall company financial health without switching tabs for every single stocks.
█ Financial Data Available:
- Revenue & PAT (Profit after Tax)
- Net Profit Margin (%)
- Gross Profit Margin (%)
- Earnings Per Share (EPS)
- Dividend
█ Features:
- Toggle between Quarter/Annual Financial Data (Notes: For Dividends, it will always be plotted based on Annual data, at Financial Year ending period)
- Options to plot at either at Quarter/Yearly ending period OR Financial Data published date
█ Limitation
- The accuracy of the data subject to Tradingview's source, but from my observation it's accurate 95% of the time
- Recently published data might not be available immediately. e.g. MYX exchange tends to have 1-3 days lag
- More information on Tradingview's financial data can be read here -> www.tradingview.com
█ Disclaimer
Past performance is not an indicator of future results.
My opinions and research are my own and do not constitute financial advice in any way whatsoever.
Nothing published by me constitutes an investment recommendation, nor should any data or Content published by me be relied upon for any investment/trading activities.
I strongly recommends that you perform your own independent research and/or speak with a qualified investment professional before making any financial decisions.
Any ideas to further improve this indicator are welcome :)
P1 FundamentalsP1 is because to me, this is a priority 1 indicator, so I have P1 and P2 indicators ordered on the favorite list.
What can you check on the selection pane?
On “period”, you can show the data related to:
the fiscal quarters
or the fiscal years.
You can select a pack of financial data that I have organized in sections:
Revenue & earnings
EPS & DPS (EPS, EPS estimate, DPS and dividend payout ratio )
Debt (total debt, total equity and cash & equivalents)
Returns (ROE, ROIC, ROA and R&D revenue to ratio)
I recommend to just select one of them, in other case the chart is a mess.
Any feedback on the code is welcome!!
Spitznagel Faustmann RatioThis is a rough version of the Faustmann Ratio metric that Mark Spitznagel presents in The Dao of Capital. The purpose is to conservatively calculate the price of the company (market cap) relative to net worth. Over a medium term horizon, the theory is that companies which have a high ROIC (see my other script) combined with a low Faustmann Ratio (color coded to give you a rough idea) should generally outperform. Please don't take this short summary as an excuse to not read the full book. It's well worth your time. (I am not affiliated with the author in any way.)
Spitznagel ROICThis is a rough version of the Return on Invested Capital metric that Mark Spitznagel presents in The Dao of Capital. The purpose is to calculate the return on real invested capital, conservatively calculated. Over a medium term horizon, the theory is that companies which have a high ROIC (presented here as a decimal value where 0.5 = 50%, 1 = 100%, etc., and color coded as a general guide) combined with a low Faustmann Ratio (see my other script) should generally outperform. Please don't take this short summary as an excuse to not read the full book. It's well worth your time. (I am not affiliated with the author in any way.)
Graham Net Current Asset Value per ShareNet current asset value per share (NCAVPS) is a measure created by Benjamin Graham as one means of gauging the attractiveness of a stock. A key metric for value investors, NCAVPS is calculated by taking a company's current assets and subtracting total liabilities.
NCAVPS = Current Assets - (Total Liabilities + Preferred Stock) ÷ Shares Outstanding.
According to Graham, investors will benefit greatly if they invest in companies where the stock prices are no more than 67% (or 2/3) of their NCAV per share (price <= (2/3)*NCAV).
Coloring pattern:
- price <= (1/3)*ncav -> light green
- (1/3)*ncav < price <= (2/3)*ncav -> green
- (2/3)*ncav < price <= ncav -> dim red
- price > ncav -> red
Long RSIThe RSI is a technical indicator generally used with the general setting being 14 days, and often shorter.
The accepted view is that a level of 70 indicates overbought conditions, and 30 indicates oversold conditions.
A short RSI setting will give signals quite often, and they might sometimes contradict each other.
As a individual investor, perhaps with a background in fundamental analysis, the RSI might be overlooked for other fundamental metrics.
But the idea here is that longer RSI settings can be used for investing.
The problem that arises is how to know when the indicator has reached a level that is either overbought or oversold.
This script solves that by using a specific look back period (selectable, but the standard is 1 year), and plotting the highest/lowest value that the RSI has had for that time period.
The idea is that a buy signal occurs when the indicator is at a 'historic' low, and a sell signal occurs when it at its 'historic' high.
Since you generally want to buy when the indicator is at its low, and has stopped decreasing, the script comes with a function that shows you when yesterdays value reached a historic low, but todays value is higher than yesterday.
This is shown by a color change of the background to green. The same is true, but opposite, for sell signals and then the background turns red.
THIS IS NOT TRADING ADVICE, AND YOU SHOULD ALWAYS DO YOUR OWN RESEARCH
GOOD LUCK AND HAPPY TRADING
Fundamental Metric to MarketThis script is supposed to be a quite basic way to find, from a fundamental standpoint, overvalue or undervalued stocks.
The script shows either Book to Market (inverse of P/B), EV /EBITDA, Earnings Yield (inverse of P/E) or Sales to Market (inverse of P/S).
For example, P/B is calculated as Close price / Book Value per share. As a contrarian investor you generally want to buy low P/B stocks and sell high P/B stocks. The problem is when a company has a negative Book Value. This might be the case when a company has written of a large amount of goodwill, which in turn wiped out their Book Value.
Instead you can use Book to Market, which is simply the inverse of P/B. It is calculated as Book Value per share / Close price. When using Book to Market you, generally, want to buy shares with high Book to Market values and sell those with low values. Because of the calculation, companies with negative Book Value will have negative Book to Market values and is therefore easy to identify.
The Fundamental Metric to Market indicator shows a colored background between the highest / lowest point of earlier values and the current value. When the background is mainly green the stock is probably undervalued, and the opposite is true when the background is red.
THIS IS NOT TRADING ADVICE, AND YOU SHOULD ALWAYS DO YOUR OWN RESEARCH
GOOD LUCK AND HAPPY TRADING
