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 [url removed, login to view], 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
29 freelancers are bidding on average $79 for this job
Hi, I am expert in this kind of work and already completed more than 200 projects. Please look at my feedback to know more about my work and me. Please send me details. thanks.
ExcelPro and VBA Developer. I can really do that easily for you. The macro is very easy and you should be using an automated dashboard so that no manual work is needed.
Hello I have a solid experience in the field and I am ready to help you. I made several VBA code data download deuis google or yahoo then cutting and processing information. cordially
Iam expert in VBA excel and looking forward for this project. My usual experience in work is with VB+database and we deal with complicated data analysis in excel. Will love to get this job.
I have 7 years of work experience in working on MS excel & macro building projects. If given the chance can work upon the task quickly & can also provide my expertise in building new macros.