OpenBB
OpenBB copied to clipboard
OpenBB-finance
[Bug] Stock splits are not correctly accounted for within `stocks/fa/pt`
To replicate: /stocks/load TSLA/fa/pt/pt--raw
We are plotting a stock price that is adjusted for splits. So if you are looking at the graph and the raw numbers you'd think that the analysts are insane expecting price targets of well over 1000. However, TSLA had two stock splits over the past years which aren't reflected in the price targets.
To fix this, obtain the stock splits (as found with stocks/fa/splits) and divide the price target by the split. So if 1 Stock becomes 3 Stocks, divide the Price Target before the split by 3.
(🦋) /stocks/fa/ $ pt --raw -l 50
Analyst Price Targets
┏━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━┳━━━━━━━━━━━━━━┓
┃ ┃ Company ┃ Rating ┃ Price Target ┃
┡━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━╇━━━━━━━━━━━━━━┩
│ 2023-02-06 │ Wedbush Morgan Securities Inc. │ BUY │ 225.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-30 │ Berenberg │ BUY │ 200.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-26 │ Bank of America Merrill Lynch │ HOLD │ 155.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-26 │ Wolfe Research │ BUY │ 185.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-26 │ Wells Fargo & Co │ HOLD │ 150.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-26 │ Cowen and Company, LLC │ HOLD │ 140.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-26 │ Wedbush Morgan Securities Inc. │ BUY │ 200.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-26 │ Citigroup Corp. │ HOLD │ 146.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-25 │ Morgan Stanley │ BUY │ 220.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-25 │ J.P. Morgan │ SELL │ 120.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-19 │ Piper Sandler │ BUY │ 300.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-17 │ Bank of America Merrill Lynch │ HOLD │ 130.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-13 │ Citigroup Corp. │ HOLD │ 140.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-13 │ Wells Fargo & Co │ HOLD │ 130.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-05 │ Mizuho │ BUY │ 250.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2023-01-03 │ Goldman Sachs │ BUY │ 205.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-12-29 │ Morgan Stanley │ BUY │ 250.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-12-28 │ Baird Patrick & Co │ BUY │ 252.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-12-23 │ Wedbush Morgan Securities Inc. │ BUY │ 175.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-12-22 │ Capital Depesche │ BUY │ 275.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-12-21 │ Deutsche Bank │ BUY │ 270.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-12-20 │ Evercore │ HOLD │ 200.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-12-20 │ Daiwa Securities │ BUY │ 177.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-12-20 │ Mizuho │ BUY │ 285.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-12-14 │ Goldman Sachs │ BUY │ 235.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-11-23 │ Citigroup Corp. │ HOLD │ 176.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-10-25 │ Morgan Stanley │ BUY │ 330.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-10-20 │ Mizuho │ BUY │ 330.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-10-20 │ RBC Capital Markets │ BUY │ 325.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-10-20 │ Wedbush Morgan Securities Inc. │ BUY │ 300.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-10-20 │ Deutsche Bank │ BUY │ 355.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-10-14 │ Wells Fargo & Co │ HOLD │ 230.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-10-10 │ Morgan Stanley │ BUY │ 350.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-10-06 │ Mizuho │ BUY │ 370.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-10-04 │ Goldman Sachs │ BUY │ 333.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-09-29 │ Piper Sandler │ BUY │ 340.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-09-16 │ Deutsche Bank │ BUY │ 400.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-09-06 │ Wolfe Research │ BUY │ 360.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-08-29 │ Deutsche Bank │ BUY │ 375.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-08-25 │ Berenberg │ HOLD │ 290.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-08-25 │ Morgan Stanley │ BUY │ 383.33 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-08-25 │ Wedbush Morgan Securities Inc. │ BUY │ 360.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-08-02 │ Citigroup Corp. │ SELL │ 424.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-07-21 │ Berenberg │ HOLD │ 850.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-07-21 │ Wells Fargo & Co │ HOLD │ 830.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-07-21 │ Mizuho │ BUY │ 1175.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-07-21 │ Bank of America Merrill Lynch │ HOLD │ 950.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-07-21 │ Capital Depesche │ BUY │ 815.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-07-21 │ Cowen and Company, LLC │ HOLD │ 733.00 │
├────────────┼────────────────────────────────┼────────┼──────────────┤
│ 2022-07-19 │ Credit Suisse │ BUY │ 1000.00 │
└────────────┴────────────────────────────────┴────────┴─────```
We are plotting a stock price that is adjusted for splits.
We actually plot the uinadjusted price on that chart (source code shows data["close"].
If you do load tsla --source AlphaVantage/pt , you see this. The others dont seem to return adjusted and non adjusted,
Seems that Yahoo Finance automatically adjust for splits over the whole timeseries. That seems to be the issue, even if you picked Adjusted Close here. So it would require a change when you use the default source.
The data for this function supposedly comes from Business Insider, but price data comes from somewhere else completely? Please provide more clarity. Does source == source, or not?
I agree, this does not make sense.
because yf doesnt actually differentiate close and adj close. load with alphavantage and you will see it makes more sense.
@jmaslek do you want me to fix this by dividing by splits from yfinance?
Go for it. Make sure to do it the correct way and multiply backwards in time.