Hi - I need someone to write a VBA code for MS Access to calculate the Simple Moving Average and add to a table. There is one price table (Pricedata) which needs to be read which has the following columns:
Symbol, Date, Open, High, Low, Close, Volume
1. Within VBA there needs to be the following
a. Narrow selection to specific dates (I will in the future be needing to change the dates in the code)
b. Within the VBA specify the number of days the moving average covers. This would have multiple values (i.e. 200, 50, 21, 9) by default. i.e. for each date and symbol 4 different moving average is calculated
c. Each of the Moving Averages above would have different Indicator Name (i.e. 200SMA, 50SMA, 21SMA, 9SMA)
d. The value is based upon the Close amount from the PriceData table
e. Append to 'Indicator Table'
Indicator Table has following fields
Symbol, Date, Indicator, Valued
See the attached excel file for the details on the calculation and providing more clarity on the words above.
For someone with the right skills this should be relatively straight forward, Will have future requests if this works out.
Please mention 'carrot' when replying along with your experience.