Calculation of daily returns of an asset class

[Ashhu]

Thanks Ashhu for the updated file. I will try to do myself with another file and if i'm having any doubts i will come back to you. Good day

Surely,
I suggest you few things here
If you are aware about excel formulas already then you start learning VBA excel, I feel best thing to start is by recording macro option, this option records all your actions or events and store it as vb code, then you can see how it's framing logical code.
Once you understand the concept, I will send you link of video to go through.
vba needs some time to catch hold of for non programmers.
I started 3 months back to learn systematically, I am not software engineer, have just creative interest towards excel n Vba.
all the best
Have good day

 

[SONJOE JOSEPH]

Surely,
I suggest you few things here
If you are aware about excel formulas already then you start learning VBA excel, I feel best thing to start is by recording macro option, this option records all your actions or events and store it as vb code, then you can see how it's framing logical code.
Once you understand the concept, I will send you link of video to go through.
vba needs some time to catch hold of for non programmers.
I started 3 months back to learn systematically, I am not software engineer, have just creative interest towards excel n Vba.
all the best
Have good day

Dear Ashhu,

Just saw yr message today since i'm in trivandrum for the last 3 days. Once i come back i will have to start working myself the file which u have send me. Thank You for the nice suggestion since i'm very much interested in learning vba and will start recording all my actions in macros.

I will get back to you once i reach home.

Regards,

Sonjoe Joseph