MS Access VBA - 28/04/2018 14:55 EDT

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.

Skills: Data Processing, Excel, Microsoft Access, Visual Basic, Visual Basic for Apps

See more: ms access vba, ms access vba and finance linkedin profile india, ms access vba space folder, ms access vba search type feature, ms access vba script find table inside db, ms access vba print file, ms access vba paste table, ms access vba ftp download, ms access vba file list spaces, ms access vba developer jobs, ms access vba codes pdf, ms access vba code ftp download, ms access vba code copy paste subform form, ms access vba ado samples mssql, manage serial port ms access vba

About the Employer:
( 17 reviews ) City of Sydney, Australia

Project ID: #16815268

Awarded to:


Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on I am ready to carry out your project in the reasonable price and in the shortest possibl More

$30 AUD in 1 day
(88 Reviews)

6 freelancers are bidding on average $26 for this job

$25 AUD in 1 day
(64 Reviews)

Hello sir! How are you?? Respected sir, i can done your task e.g “MS Access VBA" as per your requirements, please talk to me for about work, regards

$25 AUD in 1 day
(50 Reviews)
$25 AUD in 1 day
(2 Reviews)
$25 AUD in 1 day
(0 Reviews)

I have done Bachelor in Software Engineering and [login to view URL] with the specialization in Database. I have vast experience in computer science industry, during my studies i am working in a renowned software house and involve More

$25 AUD in 1 day
(0 Reviews)