Calculating the Daily Returns of an asset class using VBA code

[sonjoejh]

Dear All,

I'm not a vba expert so just looking for your help to find the daily returns of a particular asset class using vba code. The formula for calculating the daily returns is as follows:-

DR = (Today Closing Price - Yesterdays Closing Price ) / Yesterdays Closing Price

The idea is everyday i will be adding the date and closing price manually and automatically DR (Daily Return) calculation has to come automatically.

Can anybody help me out.

Thanking You,

With Regards,

Sonjoe Joseph
Mob.No.94972-82865

[pjwhitfield]

DO you need VBA?

Assuming today in column A, yesterday in B and the answer you want in C

in C1

Please Login or Register  to view this content.

Or am I missing something fundamental?

[sonjoejh]

Yes i need a VBA to do that since i will be adding some more mathematical calculations later.

[pjwhitfield]

Please Login or Register  to view this content.