Previous Topic Next Topic

Calculate Formula based on values for two dates

Closed
srsubs Posts 1 Registration date Wednesday 27 May 2015 Status Member Last seen 27 May 2015 - 27 May 2015 à 05:54
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 3 Jun 2015 à 10:49
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

Réponse 1 / 2
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
27 May 2015 à 09:33
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.
Sam
3 Jun 2015 à 07:58
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
Réponse 2 / 2
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
3 Jun 2015 à 10:49
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.

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses