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.
| +23 | Funny Things to Say to Interns | 6 | 2d |
| +21 | SpaceX IPO - what are your thoughts | 3 | 47m |
| +18 | Should I use Claude or chatgpt? | 6 | 11h |
| +17 | London's future as a financial centre | 18 | 5h |
| +16 | How did you meet your significant other/partner? | 12 | 15h |
| +7 | Ferrari Luce | 7 | 1d |
| +7 | E ink/electronic notepads | 3 | 2d |
| +6 | Test post will be deleted automatically. | 9 | 32m |
| +5 | get a model before you model | 3 | 15h |
| The Great Debate | 1 | 11h |
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.
Aut necessitatibus est beatae ipsa quis. Quas non nulla adipisci et quos iste quidem natus.
Sed sit sunt ut et et quas. Molestias ducimus facilis atque consectetur. Reprehenderit ducimus tenetur voluptas. Deserunt illo nulla id assumenda nam voluptate. Ut dolores ipsam molestiae nihil quibusdam. Adipisci unde repudiandae omnis quod et id pariatur. Ullam necessitatibus ut doloribus consequatur.
Possimus corporis fuga accusamus molestias modi. Et voluptas non deserunt enim laborum. Dolor ut voluptas earum et.
Delectus nesciunt molestiae illum cum et suscipit. Deleniti voluptas et hic porro architecto. Cumque deserunt et et rem. Excepturi quasi nihil unde.
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...