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.
Income
Financial GrowthThis indicator will acquire the financial data provided by Tradview.
the data is compare between Quarter, Annual and TTM in term of percent of growth.
YoY, QoQ and CAGR is also available by this script (The minimum is 4).
in addition, ploting of data, label and table also available (you can check the mark to toggle on / off).
Data : Revenue, Net Income, EBITDA, EPS, DVPS, Free Cash Flow and Forward PE .
How to use it.
just select the financial data, period and size of data to compare.
you can check the box to toggle the plotting line, label and table.
Enjoy.
Income Ratio■ Income Statement Ratio
This script will provide how distribution of income statement of a comany is.
it also allows us to see a clear picture how the business of a company develop.
For example TESLA.
in term of value, its revenue is 13,757K in the last quarter and it seam to be stable.
while the cost of goods sold (COGS) also increase.
In term of percent, it shows that the gross profit margin is growing up as well as net profit margin.
moreover, depreciation and amortization has declined as well as COGS.
This information like this will help us make a better trading plan.
■ Idea.
1. Each items such as Cost of Goods Sold, Gross Profit will be divided by total revenue.
2. 2 types of data after calculation, Value in Million and Percent by comparing with "Total Revenue".
■ How to use it.
In the menu, you can select the type of data to show
1. Select data type, it is available in Value in Million and Percent.
2. Select the financial period : FY for Financial Year and FQ for Financial Quarter.
Enjoy.
Silen's Financials Debt & EquityThis Script shows Debt (red) & Equity (green), as well as Total Equity and Net Income in a preformatted way for a symbol. Total revenue's and Net income's visibility is turned off by default and can be activated in the indicator settings. 🍳
Disclaimer: Any content in this script can be completely replicated by using Tradingview's Build-In Financial Indicators: Total debt, Total equity, Net income and Total revenue. It requires a lot of formatting work to get them to this state though. 👌
However, you are going to need 4 Financial Indicators clogging 🚽 your screen. With this indicator you have them preformatted as an overlay on your chart so you know exactly what's going on with your ticker's financials. 💰
I recommend only using Debt & Equity OR Total Equity & Net Income together. Although displaying all 4 indicators together is possible, it will make your chart quite messy.
This is how the indicator looks like for Total equity and Net Income:
This Script (2) is part of a Series that will contain 3 scripts to help you easily evaluate if a stock is trading in harmony with its fundamentals or not. ☯
Script 1 already exists:
Script 3 will be a Fair Value Indicator. 📣
Script 1 and 2 combined will look like this: 🌄
If you have any questions, let me know! 🙂
