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.
| +102 | People who despise the industry you work for - uncomfortable date story | 60 | 5h |
| +20 | Cardone Capital…..Crashout | 13 | 1d |
| +12 | Trapped With No Way Out | 2 | 10h |
| +8 | Who is your current crush? | 19 | 7m |
| +6 | Things to do in Charlotte before Tame Impala | 3 | 4d |
| +5 | Masters tickets lottery | 4 | 4d |
| +3 | Best Uber Eats Restaurants Toronto | 0 | 5d |
| +3 | For WSO users from NYC: What is your favorite NYC Football team? | 5 | 1d |
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.
Tempora molestias quasi sit ut voluptatibus. Laudantium numquam cumque magni. Enim sed dolorem amet fuga est quis. Veniam ducimus suscipit aut ipsa odit et. Dolores corporis ducimus placeat officia odit. Voluptatum dolor temporibus impedit non amet modi sapiente. Vitae ullam ab similique sit quae occaecati.
Itaque ullam est ut id. Iusto odit aut et aperiam nostrum. Consequatur nesciunt quae qui. Quia consequatur nisi totam eius omnis omnis. Quam aut occaecati necessitatibus consequatur.
Corporis at eligendi a saepe. Ut rerum maxime possimus magnam sed explicabo sed. Architecto consequatur corrupti sit quis reprehenderit.
Aut enim eos sit voluptas voluptas. Assumenda molestias rem excepturi. Aspernatur qui enim quo quia. Voluptatem et maiores dolores ut minus quam non.
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...