Building a macro

[Matt]

I'm trying to build a macro that will enable me to calculate returns,
i.e. ((price month t/price month t-1)-1)/*100.

Each month I want to add new data, and the macro to automatically
recognise this and calculate 1, 3 and 6 month return.

Is this something that is possible, and can anyone give me a hand?
Any help would be greatly appriciated.

 

[Bernard Rey]

I'm trying to build a macro that will enable me to

calculate returns,
i.e. ((price month t/price month t-1)-1)/*100.

Each month I want to add new data, and the macro to
automatically recognise this and calculate 1, 3 and 6
month return.

Could you give some details about how your data is
organised? Just from what you wrote, I'm not too sure
you'd need a macro. A formula like "=(A2/A1)-1" (w/o the
quotes, Format set to "percentage") could be enough.

I must be missing something...