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.
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.