Calculate Formula based on values for two dates

Closed
srsubs Posts 1 Registration date Wednesday May 27, 2015 Status Member Last seen May 27, 2015 - May 27, 2015 at 05:54 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 3, 2015 at 10:49 AM
Hello,

I'd like some help with calculating a formula that uses values corresponding to specific dates. I have a list of daily dates and a value eg. a stock price, for each date,. I'd like to calculate the difference in price (or investment return) between 2 dates that I specify.

Even better would be a way to calculate the difference for specified periods, eg. For a given date, the difference in value between that date and 1 month ago, 3 months ago, 1 year ago, 3 years ago etc.

Thanks very much.

2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 27, 2015 at 09:33 AM
srsubs, good morning.

If you have a table like you described, use of a VLOOKUP function is perfect.

You can use too a combination of INDEX + MATCH functions to do this job.

Is this waht you want?
I hope it helps.
0
Thanks Mazzaropi -- yes those are the functions I would combine -- the trick is in knowing how to use them correctly. I had hoped someone had already done this, but no worries, am making progress. Appreciate your taking the time to write.

Regards...Sam
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 3, 2015 at 10:49 AM
Sam, good morning.

If you explain your real question a little better, it will be much easier to help you in a concrete and conclusive way.

Is your doubt about the use of VLOOKUP or INDEX + MATCH or how to obtain a past dates?

Here is a place where all particpantes wish to help others.
I am waiting for your answer.
0