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

Closed

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, me vba, excel vba help, excel 2013 vba, www online market com, write report online

Project ID: #4869041

Awarded to:

Yutenji

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)
2.2

29 freelancers are bidding on average $79 for this job

Teloquence

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)
6.5
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at http://bit.ly/Lta2EN Looking for further discussions in this regard. I strongly bel More

$64 CAD in 2 days
(70 Reviews)
5.9
dpune

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)
5.4
MDavidCrompton

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)
5.1
northwolves

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: https://www.google.com/#q="northwolves" http://www.mrexcel.com/forum/member.php?u=64088 Look More

$100 CAD in 3 days
(44 Reviews)
4.9
Gooroo

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)
4.3
nikitasvw

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)
3.7
drevak

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)
3.1
hbxfnzwpf

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)
2.9
MSExcelPro

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)
2.6
benefitworks

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)
2.5
Rajmohan007

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)
2.7
logoDS761

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)
2.1
ziafar

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)
2.9
crediblesoluti0n

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)
1.8
excelmacro

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)
0.9
iakshay

dear sir, we have more than 3 yrs experience software development and Expert in MS office.recently 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)
0.0
Billymar

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

$43 CAD in 0 days
(2 Reviews)
0.0
pousali

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.

$35 CAD in 1 day
(0 Reviews)
0.0
scorps11

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.

$35 CAD in 3 days
(0 Reviews)
0.0