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

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

Skills: Data Entry, Data Processing, Excel

See more: excel data report vba, market vba excel, entry manually, simple data work sheet work macros, yahoo-finance, www market online com, work values, work close, s.i. com, order processing work, open excel online, online help with excel, inaccurate data entry, hit data entry, help write daily, heads down data entry, excel work online, data entry macro, vlookup table, vba and macros

About the Employer:
( 1 review ) Toronto, Canada

Project ID: #4869041

Awarded to:


An interesting project with which I'd be delighted to help. (In fact I have a similar process I run for myself everyday!) I believe your objectives are to make this simpler, more efficient and more easily maintainab More

$50 CAD in 3 days
(2 Reviews)

29 freelancers are bidding on average $79 for this job


Consider it done. Check your PM for my bid details. Have done many macros before, am sure will complete this project in couple of hours.

$84 CAD in 0 days
(154 Reviews)

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [login to view URL] Looking for further discussions in this regard. I strongly bel More

$64 CAD in 2 days
(70 Reviews)

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.

$88 CAD in 3 days
(70 Reviews)

Hi, I have worked on creating specific Excel applications for 20 years and have completed several freelancer projects, PLEASE CHECK FEEDBACK. Example will follow. I am UK based, on GMT time, available on skype and a n More

$150 CAD in 3 days
(25 Reviews)

As one of the best expert of excel & VBA,I can modify the codes or rewrite new codes for you. You can search me in google:"northwolves" [login to view URL] Look More

$100 CAD in 3 days
(44 Reviews)

Hi! Please DO CHECK my reviews and portfolio and let me help! I can do this accurately and optimize your macros to one macro! Excel PRO here! Thanks!

$62 CAD in 3 days
(19 Reviews)

Hello, I see you have recorded macroses. I can fix them if they are fine. Make update and make them active when open workobook. Nikita

$55 CAD in 2 days
(25 Reviews)

Dear friend, I can do this job because I have a great deal of experience in this area. Over 3 years of experience in Excel VBA will definitely come in handy. Could you check my portfolio for samples? I know the insight More

$54 CAD in 2 days
(4 Reviews)

I can write a program do this, make it automate, and can send u the program. I am VBA senior programmer, and have 5 years VBA programming experience now, I am very proficient in dealing with all kinds of MS format file More

$61 CAD in 3 days
(2 Reviews)

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.

$150 CAD in 3 days
(1 Review)

Hello Mr. Ganes, I have very sound experience in excel macros and ms office automation including automatic chart, tables, excel sheet and powerpoint creations. I 100% sure that I can complete this project to your sa More

$66 CAD in 4 days
(3 Reviews)

Hi, Have done tons of jobs related to stock market data analysis ranging from stock quotes data extraction from web to stock data analysis for derivatives trading. While, i am able to understand roughly what your More

$122 CAD in 10 days
(5 Reviews)

Interested job! Will do this very well since have plenty experience in this field vb6 / vba 12 years ....

$100 CAD in 3 days
(2 Reviews)

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

$35 CAD in 3 days
(3 Reviews)

Hi, I have last 6 years experience in Data entry firms. I am doing this job very well with timely manner. Good accurate in Excel and web research. I am offering to good price and always communicate with you. Than More

$105 CAD in 3 days
(3 Reviews)

Hello. I am a Excel VBA programmer with many years experience. I have looked into the code you have made and I agree there is plenty of room for improvement. Among other I would suggest: 1) ensure that the macro(s) on More

$80 CAD in 7 days
(1 Review)

dear sir, we have more than 3 yrs experience software development and Expert in MS [login to view URL] developed a excel pie chart updater with data entry and it's calculation for a C.A..we have a dedicated team for data More

$100 CAD in 3 days
(1 Review)

I am a computer engineer. I would be glad to help you with your project. Thanks, Billy

$43 CAD in 0 days
(2 Reviews)

Hi. I have been working on VBA professionally in Cognizant Technology Solutions. However, this is my first project on Freelancer and therefore, you can give me the minimum amount of money that anyone bids for your proj More

$35 CAD in 4 days
(0 Reviews)

Hi! I can do this job. I'm ready to receive all your proposals. I'm living in Richmond Hill, and we can contact on the phone.

$35 CAD in 7 days
(0 Reviews)