jeffreyrdcs/stock-vcp-dash

report generated by https://jeffreyrdcs.pythonanywhere.com/ and myself for the same date is wrong

asraghu123 opened this issue · 3 comments

asraghu123 commented

I noticed that the report you generate on https://jeffreyrdcs.pythonanywhere.com/ for say March 25th and The report I generated for March 35th using yahoo data feed is different.

I have attached my pdf report. you will see the stocks and order are mostly wrong.
2024-03-25.pdf

The screen below is a snap shot from your hosting site. as you can see the date is same , but stocks and RS ratings are difrferent .

image

asraghu123 commented

Here I am attaching the report I generated on March 26th at 5pm CST using yahoo.
[Uploading 2024-03-26.pdf…
You can also run for today on your side and compare if the reports match. if there is a mismatch something is wrong.

jeffreyrdcs commented

@asraghu123 I took a look, I believe the discrepancies are because of two reasons:

  1. the number of stocks that was used for the calculation are different. Mine has 4213 stocks while your pdf has 4284. It could be due to data fetching issues from yfinance on my side, or that I have ticked out some stocks from Ticker.csv at some point. Since RS rank is a ranking, so its absolute value depends on the number the stocks that goes in the rank calculation.
  2. Something I have noticed for a while is that yfinance sometimes give values that are slightly different depends on when you fetch it. The difference is tiny, but it does affect the calculation of RS rating a little bit, hence you might see some slight order change among the top 10 selected stocks. My stock csvs are fetched a while ago and the stock price are only updated per day, so the values might be slightly different from yours which are fetched recently. We can verify if this is the case, for example If you can provide your INO__.csv inside db_yfinance here, then I can tell you if there are any differences between yours and mine.