Get started

Cashflow

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.
Pine Script™ indicator
by MUQWISHI
Funamental and financialsEarnings and Quarterly reporting and fundamental data at a glance. A study of the financial data available by the "financial" functions in pinescript/tradingview As far as I know, this script is unique. I found very few public examples of scripts using the fundamental data. and none that attempt to make the data available in a useful form as an indicator / chart data. The only fitting category when publishing would be "trend analysis" We are going to look at the trend of the quarterly reports. The intent is to create an indicator that instantly show the financial health of a company, and the trends in debt, cash and earnings Normal settings displays all information on a per share basis, and should be viewed on a Daily chart Percentage of market valuation can be used to compare fundamentals to current share price. And actual to show the full numbers for verification with quarterly reporting and debuggging (actual is divided by 1.000.000 to keep numbers readable) Credits to research study by Alex Orekhov (everget) for the Symbol Info Helper script without it this would still be an unpublished mess, the use of textboxes allow me to remove many squiggly plot lines of fundamental data Known problems and annoyances 1. Takes a long time to load. probably the amount of financial calls is the culprit. AFAIK not something i can to anything about in the script. 2. Textboxes crowd each other. dirty fix with hardcoded offsets. perhaps a few label offset options in the settings would do? 3. Only a faint idea of how to put text boxes on every quarter. Need time... (pun intended) Have fun, and if you make significant improvements on this, please publish, or atleast leave a comment or message so I can consider adding it to this script. © sjakk 2020-june-08
Editors' picks
Pine Script™ indicator
by sjakk
20