eezy$peezy
Junior member
- Messages
- 12
- Likes
- 0
Hi,
Ok..first off ..i'm a newbie on this board so hope i've posted this in the correct Forum Topic.
Also i am not a whizz on the PC either !
I want to automate my stock data in MS Excel by having it compile the #day moving average (say..for example 20day MA).
In other words after entering the end of day's data for my stocks; in the column alongside the latest entry of day's data, i will also have the MA auto calculated for whatever length of days i've chosen (take the example above - a 20 day MA).
I don't have a clue how to write the macro. Can anybody help me out?
Cheers
eezy.
Ok..first off ..i'm a newbie on this board so hope i've posted this in the correct Forum Topic.
Also i am not a whizz on the PC either !
I want to automate my stock data in MS Excel by having it compile the #day moving average (say..for example 20day MA).
In other words after entering the end of day's data for my stocks; in the column alongside the latest entry of day's data, i will also have the MA auto calculated for whatever length of days i've chosen (take the example above - a 20 day MA).
I don't have a clue how to write the macro. Can anybody help me out?
Cheers
eezy.