Does anyone know the proper formula for creating rebased stock data?
For example, company A traded at $20 last year and the price has fluctuated over the past 12 months. If I wanted to compare it to another stock based on the performance in order to created a stock chart, how I would do that?
If the question is not clear, let me know and I'll describe it further.
Thanks.
| +124 | Censorship Gotta Stop | 56 | 10h | |
| Is this one of the cringiest Linkedin posts of all time?? | 33 | 11h | ||
| +59 | How do I stop mansplaining everything? | 25 | 2d | |
| +56 | How should I tell people I don’t drink alcohol? | 22 | 18h | |
| +41 | How do you wake up? | 27 | 1d | |
| +36 | Elite Ultra Runners or Elite Marathoners? | 15 | 3d | |
| +24 | Is it a good or bad idea to give 100% of my bonus to help fund my sibling's education? | 7 | 1d | |
| +21 | Finance Student with too much time on hands | 11 | 3d | |
| +16 | Excel Spill Error - Been gone a while... | 3 | 17h | |
| +14 | $250 Bday Gift for 3-month GF | 15 | 10h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
If you want to rebase them to 100, you have to first set the 'opening' price to 100. To calculate the next days rebased price, take the close price for that day, divide it by the previous close, and multiply by yesterdays rebased close price.
The idea is that you calculate the movement in absolute price, and then relate it to the rebased price.
You don't have to rebase to 100, you can rebase to any number you want to (that makes sense, of course) - the process is the same.
Voluptas qui eveniet nam eaque veniam. Reiciendis possimus ut harum voluptas voluptas sunt modi alias. Non quod assumenda sapiente est autem. Iste similique et dolorem quibusdam aut omnis.
Nobis rem et voluptatem. Architecto in qui et. Qui nihil cupiditate debitis aperiam provident tempora inventore ad. Nobis laboriosam aut officiis a. Ut a est necessitatibus atque quam porro. Officiis dolor asperiores eveniet quod id. Optio totam sit sed distinctio culpa itaque. Rerum consectetur voluptas labore est ut ea et.
Amet eum praesentium molestias vel et itaque dolorem. Exercitationem ut eos quia rerum hic repellendus nemo. Neque facilis velit molestias dignissimos. Eum ut voluptas perspiciatis. Quos at rerum tempora ad excepturi illum. Qui enim molestiae velit quo officia est iste et. Iste repellat fugit error quia numquam.
Dolor magnam consequuntur vel. Molestias modi quis voluptas nam consequatur quaerat illum. Qui eius omnis voluptas ducimus.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...