I have a table (let's say X) with various colums. The first column is based on date.
I thought I could just do this;
DataVTAQ.Ret = (DataVTAQ(1,6)./(DataVTAQ(2,6)))
So I create a new column (RET), which is nothing else but the % change between 2,6 and 1,6 (a lag of t-1) basically.
How would one go about that?