You have chosen to sponsor your bid up to a maximum amount of .
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