EPS & Sales

28 thg 7, 2022

Hi everyone,

I just adapted a little utility script to visualise EPS % increase (quarters vs Year -1) and sales.

I used the code from ARUN_SAXENA and modified it to fix what I saw as issues.
(Using base 3M instead of 1M +
request.earnings(syminfo.tickerid, earnings.actual, ignore_invalid_symbol=true)
instead of
request.financial(syminfo.tickerid, "EARNINGS_PER_SHARE", "FQ")

Data will differ from MarketSmith because they use sometimes actual EPS sometimes standard, but think we can at least trust what we see in term of %

The tool is far from being perfect !

28 thg 7, 2022

Phát hành các Ghi chú

Just modified a condition that was making the script bug on given charts

28 thg 7, 2022

Phát hành các Ghi chú

MarketSmith tag added

3 thg 8, 2022

Phát hành các Ghi chú

Modified:
- Displays NaN when both EPS used for calculation are negative
- Displays + when increase is positive :)
- Modified calculation system, use the closer EPS to 0 when both reported and standard EPS are negative
We are now very close to the calculation method of MarketSmith.
Sometimes number differs but results are often close when differents.
To be honest I always confirm with shared graph on Twitter.

4 thg 8, 2022

Phát hành các Ghi chú

Now displays '#' in front of EPS growth % to indicate if an EPS for calculation is negative

6 thg 8, 2022

Phát hành các Ghi chú

Modified some comments to help to understand what I did.
if you have any constructive suggestions, please let me know in the comments

6 thg 8, 2022

Phát hành các Ghi chú

- You can now change colors to suit your theme

6 thg 8, 2022

Phát hành các Ghi chú

- Removed indicators that were polluting the visual overview

6 thg 8, 2022

Phát hành các Ghi chú

- Adjusted Original Colors

13 thg 8, 2022

Phát hành các Ghi chú

- The Script is now directly added to the chart when added
- Removed the grid transparency
- Added the possibility to choose the position of the table

14 thg 8, 2022

Phát hành các Ghi chú

- Added the possibility to show the gross margin
- Tried to display Yearly EPS but highly inaccurate results convinced me to only keep the code under comments in case someone one day is able to calculate manually ?
- I'm still not satisfied with the code.
Ex:
- CELH one result is missing
-AEHR, this shoudn't happen but in Da, We, Mo, results differs. The problem is that we need to search previous earning with time and sometimes it defers from one stock to another.
I would love to find a way to get previous earning without using the time.

14 thg 8, 2022

Phát hành các Ghi chú

- I have removed the colour from the table frame as it pollutes the price graph

15 thg 8, 2022

Phát hành các Ghi chú

- Modified the code because the case where actual EPS was negative and reported EPS was positive was not taken into account.
(Now the '#' is diplayed correctly)
- Added the possibility to display ROE
- Added the possibility to show EPS used for calculation

16 thg 8, 2022

Phát hành các Ghi chú

- Now return NaN when last EPS is negative and EPS of the previous year is positive

22 thg 8, 2022

Phát hành các Ghi chú

- Now possible to plot EPS curve on the graph with another scale on the left.
Please tell me if you don't like this update, because it adds a left scale whether this new option is checked or not

23 thg 8, 2022

Phát hành các Ghi chú

- I finally corrected the time base period and replace the "3M" by the function barssince. This corrected the bug on AEHR.
I complained about if few updates ago :)

23 thg 8, 2022

Phát hành các Ghi chú

- Found that plotting EPS line on another scale was not very usefull
So I decided to replace them by Arrow on the chart showing EPS date and EPS % variation as you can see on MarketSmith graph
I have no solution to plot them at the bottom of the graph, if you know how, don't hesitate to tell me in comment
(I can't reply to personal messages for now)

23 thg 8, 2022

Phát hành các Ghi chú

- Corrected the case in which EPS display is negative to avoid +-50%

29 thg 8, 2022

Phát hành các Ghi chú

- Now the color of positive or negative variations also affects the color of the text under the arrows
- You can select arrow colors
- You can select the 'EPS' text color

6 thg 9, 2022

Phát hành các Ghi chú

- You can now adjust the size of the table.

13 thg 9, 2022

Phát hành các Ghi chú

- Corrected the case where arrow displayed the wrong balue between EPS reported or standard

24 thg 10, 2022

Phát hành các Ghi chú

- Modified the case in which when both reported and standard EPS are negative, but the closer to 0 is > than -0.01, is not taken into account.
(Corrected the #+999% in APA which was #+712%)

8 thg 11, 2022

Phát hành các Ghi chú

- Added comparison regarding sales too
- Renamed all the variables in the code that were confusing
(+ some comments here and there to facilitate understanding)
- Integrated the calculation of QoQ EPS without changing the general appearance of the script
(This way I hope I won't be HARASSED anymore :p)
- Added the viewing of 3 additional quarters
And finally...
- I really hope that, like me, you'll love the new look ! (If not you can still save it to your taste)

8 thg 11, 2022

Phát hành các Ghi chú

(forgot to remove drawings on the chart...!)

8 thg 11, 2022

Phát hành các Ghi chú

- Corrected the display of QoQ Eps when equals to YoY (could have and unforced # in front of result)

9 thg 11, 2022

Phát hành các Ghi chú

- Finally managed to display the quarters in MMM-yy format:-)

9 thg 11, 2022

Phát hành các Ghi chú

- And corrected size of the text of the date that I forgot !

11 thg 11, 2022

Phát hành các Ghi chú

- Arranged the settings to allow an easier and more intuitive customization of the interface

25 thg 11, 2022

Phát hành các Ghi chú

Added :
- Now possible to see Sales on the graph under EPS information
- Changed the QoQ visual
- Added Sales QoQ
- Reorganised Input
- Now possible to change text Color on the graph independently

27 thg 11, 2022

Phát hành các Ghi chú

- Reduced the number of label to allow more historical data on the graph (regarding arrow part)

19 thg 12, 2022

Phát hành các Ghi chú

- Replaced 'NaN%' by 'N/A' and change color from red to black.

5 thg 1, 2023

Phát hành các Ghi chú

- Added the correct display of N/A vs N/A instead of NaN vs NaN on the table and on the arrows
- Changed color of the case where variation% = 0% in black color. (Both EPS & Sales)
- Corrected the display of +/-∞% by N/A.

26 thg 1, 2023

Phát hành các Ghi chú

- Now the script correctly displays EPS and % when the EPS value is the same twice in a row.
- Corrected the synchronization between the EPS and Sales rows in the table
LYTS and WING were not correct, now they are.

27 thg 1, 2023

Phát hành các Ghi chú

Arrow part:
- Modified NaN% value to N/A
- Modifier N/A color
- Corrected the 0% color

Table part:
- Changed GROSS MARGIN into GM
- Corrected the case where eps1 was negative and eps4 was 0 -∞% -> N/A
- NaN vs NaN -> N/A vs N/A on QQQ
- Recorrected the 0% color
(I think TV displayed me an old previous version of the script so I had to re-write the two last points)

30 thg 1, 2023

Phát hành các Ghi chú

- Now +0% in blue is turned to 0% in black :3

1 thg 2, 2023

Phát hành các Ghi chú

- On the EPS day, TradingView provides the same sales number than the previous one instead of seeking for the new one. This cause a wrong data display on the last line and it can bring confusion.
I decided to identifiy this time and replace the sales and variation number by N/A. I will remove this if TradingView correct this bug.

1 thg 2, 2023

Phát hành các Ghi chú

- Same change than above but for the text under arrows on graph.

2 thg 2, 2023

Phát hành các Ghi chú

- In the case of a sales display changed to N/A on the EPS day, the script now displays the sales value as soon as it is available. Here in the post-market of the earning day.

2 thg 2, 2023

Phát hành các Ghi chú

- Added the case where Sales are the same the day after the earning event

3 thg 2, 2023

Phát hành các Ghi chú

- Correction of a bug with the last update

20 thg 2, 2023

Phát hành các Ghi chú

- Corrected -10000% bug
- Now displays Sales in MIL or BIL

2 thg 3, 2023

Phát hành các Ghi chú

- Corrected the display of x,x Bil$ to xxxx,x Mil like MarketSmith
- Corrected the case where sales are the same number at day+1 after eanring event

22 thg 3, 2023

Phát hành các Ghi chú

- Added a black Frame arround the table

7 thg 4, 2023

Phát hành các Ghi chú

- Changed the size of the column to have the same ratio than MarketSmith's table
- Changed the Graph for better presentation

18 thg 4, 2023

Phát hành các Ghi chú

- Adjusted Colors
- Input have been reorganised and simplified

21 thg 4, 2023

Phát hành các Ghi chú

- Arrow size is now adjustable
- We can now display the %variation anyway even if the actual/reported EPS is negative
- Limitation added to -999%
- We can now display surprises on the table
- Input reorganised

21 thg 4, 2023

Phát hành các Ghi chú

- Little mistake on inputs, my bad! Corrected

27 thg 4, 2023

Phát hành các Ghi chú

- Corrected the display that was broken when "Surprise" and "Less Quarters" were checked.
- Changed to Presentation Graph

30 thg 4, 2023

Phát hành các Ghi chú

-Now possible to display the Daily Table of EPS & Sales.
(I did it because I was asked many times, I am not very satisfied with the result, the table functions of tradingview are not flexible enough to do everything I would like to do.
There are now inputs that manage the appearance of both tables.)
-Data alignment

30 thg 4, 2023

Phát hành các Ghi chú

- Added a delimitation on the table type Daily

5 thg 5, 2023

Phát hành các Ghi chú

- Corrected a display in the Daily table

5 thg 5, 2023

Phát hành các Ghi chú

- Corrected a wrong color in the Daily table

8 thg 5, 2023

Phát hành các Ghi chú

- The space between the title and the result is as close as possible to the one of MarketSmith
- Changed the presentation graphique

9 thg 5, 2023

Phát hành các Ghi chú

- Arranged the | on the Daily Table not to appear when Table Border is set to 1

15 thg 5, 2023

Phát hành các Ghi chú

- Added max_albels_count = 500 to display more historical arrows on the graph
- Organized the alignment of the column (Surprise, ROE, GM)
- Used another method for sales and EPS to have as much historical data as possible, currently 3 variations in % on IOT against only one before

16 thg 5, 2023

Phát hành các Ghi chú

- Modified the Sales Growth YOY method calculation to display more data on IPO.
Impressive results for example on IOT where we can display 4 additional lines compared to the previous method

20 thg 5, 2023

Phát hành các Ghi chú

- Corrected the way to detect a duplicate in the recent sales announcement

23 thg 5, 2023

Phát hành các Ghi chú

- Corrected the case where sales number where the new sales figure was updated and not the % change for recent earning

26 thg 5, 2023

Phát hành các Ghi chú

- Corrected a minor bug that occured when two earnings where close one to another and we had the same % variation. Now the code detects it and recalculate the variation.

28 thg 7, 2023

Phát hành các Ghi chú

- Modified the order of the table Size selection in the input

3 thg 9, 2023

Phát hành các Ghi chú

- Added customisable table border and frame
- Corrected the Gross Margin and Return on Equity offset

8 thg 12, 2023

Phát hành các Ghi chú

- The oppocity of the weekly table is now working. Thank you bognog for pointing the issue.

1 thg 2

Phát hành các Ghi chú

- Corrected shifting color to transparant of the daily table
- Now the script runs if don't find fundamental data

29 thg 3

Phát hành các Ghi chú

- Added Estimates for the very next Earning to come
- YoY and QoQ can be viewed separately
- We can now view the QoQ %Change on arrows
- EPS Due date has been added on HeadBand type table
- Default setting now show the Surprise variation
- Reorganised inputs
- Changed the look of the table toward new 'MarketSurge' type look

6 thg 4

Phát hành các Ghi chú

- Corrected wrong digit on the 'versus' display on sales after B_Kaminski pointed it out

15 thg 4

Phát hành các Ghi chú

- Corrected the display of # and N/A for estimates
- Simplified the # and N/A System detection
- Added # system as an input option
- Added Quick pre-designed looks based on MarketSmith and MarketSurge Tables
- Corrected GM and ROE estimations values from 0% towards -
- Made the display of variation% of EPS & Sales without arrows as an option

16 thg 4

Phát hành các Ghi chú

- Corrected the MarketSurge Type Table Look
- Added the variation when negative EPS by default

8 thg 6

Phát hành các Ghi chú

- Corrected Minor Mistake of # when next EPS quarter was negative calculated against negative EPS. Now display the same value without '#' as MarketSurge does

23 thg 8

Phát hành các Ghi chú

- Like MarketSurge does, when a reported EPS number is missing the code will now search for the standard EPS for replacement.
This will allow tickers like SEZL and CAVA to be closer to the MarketSurge result.
Moreover it should make the script usable for the Indian Market.

29 thg 8

Phát hành các Ghi chú

- Modified the style of the table toward MarketSurge look
- Used lighter grey for the MarketSmith table