Daily return vba code

[malek]

hello everyone,

I want to compute daily returns of a stock with VBA code in column C.

daily return formula is (Price day 2/Price day 1)-1. It's easy to do it manually with excel by doing (B2/B1)-1 and then stretch it down but I want to do it on VBA.

thank you for your help.

you can find the excel file with daily prices below.

 

[Marc L]

Hello, with this codeline : Range("C3:C" & [A1].CurrentRegion.Rows.Count).Formula = "=(B3/B2)-1" …​

Do you like it ? So thanks to click on bottom right Like !
​

 

[malek]

thank you it's working ! =)