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.
Hello, dear sir!
I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality!
From the Access & vba, of course, familiar.
Give me a chance to show what I can do!
$30 AUD ndani ya siku 1
4.9 (88 hakiki)
6.0
6.0
6 wafanyakazi huru wana zabuni kwa wastani $26 AUD kwa kazi hii