Excel Work - Simple VBA Macro's on a Market Report Sheet

IN PROGRESS
Bids
30
Avg Bid (CAD)
$78
Project Budget (CAD)
$30 - $250

Project Description:
I have a simple spreadsheet which has already been completed and runs on several poorly recorded Macro's, I need someone who is familiar with VBA to help write a simple macro to update the sheet each day. The sheet consists of a daily entry mechanism which records market data which are pulled from online sources and placed into the spreadsheet, creating an entry each day. Currently the macros used are (cntl + Shift + Q) & (Cntl + shift + a) & (cntl + shift + w) & (Cntl + shift + s) & (cntrl + shift + e) in that order... these update a daily date and s&p 500 close and open column and shift the table down by one space and pull the s&p number from yahoo finance. Next, the macro (A) tidies this task by deleting an inaccurate entry and paste specializing the modified values. the W macro then pulls an economic calendar from www.finviz.com, and during this phase I manually enter in several values based on whether the marker hit or missed its expectation. the (s) macro helps with this task by labeling my column heads with X ? XXX.... this first X designates the row where the +/- impact is allocated, the ? is where i enter either +1 or -1 based on the indicator performance and the XXX is simple 111 to designate where the fourth row (a vlookup from a list which numbers is indicator) is sent to.

It sounds complicated but really isint,

The price is highly negotiable,

Please let me know of any questions and check out the file attached

Skills required:
Data Entry, Data Processing, Excel
Additional Files: News Tracker 5.51.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 84
in 0 days
$ 64
in 2 days
$ 88
in 3 days
$ 150
in 3 days
Hire northwolves
$ 100
in 3 days
$ 62
in 3 days
$ 55
in 2 days
$ 61
in 3 days
$ 54
in 2 days
$ 66
in 4 days