Automated stock price retrieval from Yahoo finance (108 shares from OMX Stockholm large cap)

Completed Posted Mar 9, 2016 Paid on delivery
Completed Paid on delivery

I need an excel document that automatically retrieves stock prices of 108 shares on the OMX Stockholm's Large Cap list from Yahoo Finance.

Share prices should be reported in graphs where you can choose to display the prices of all shares in one-year intervals between 1-10 years. Simple Moving Average (SMA) for 50 days, 100 days and 200 days must also be drawn up for each stock graph.

I attach a dummy document showing how I want the document to be structured and what stock prices to be inserted in the document.

Each company must have its own tab with stockprice and graphs and all companies graphs should also be collected in a collection tab for an easy overview. See attached file.

Requirement:

The excel document must be able to run in Microsoft Excel for Mac 2016 and Microsoft Excel for Windows 2010.

In Sweden we use comma (,) as dividers instead of dots (.). This issue must be addressed in the Excel file for the graphs to work.

The graphs should be read from left to right with the oldest data to the left.

Excel Visual Basic

Project ID: #9891794

About the project

7 proposals Remote project Active Mar 9, 2016

Awarded to:

kolosibalint

Hi, Thanks for the invitation. As it was me who made the previous one I think it wont be difficult to create this one.

$80 USD in 7 days
(118 Reviews)
6.9

7 freelancers are bidding on average $110 for this job

Khurramz

Hi! Thank you for invitation. Do you need the excel file to download data as well or you already have that vba code?

$100 USD in 3 days
(353 Reviews)
7.4
mananraja

Hi there, I have read the description.,. I have good web scraping experience & reviews..I can develop excel VBA scripts as well scripts using Python & C#.. Looking forward to your response..

$75 USD in 1 day
(68 Reviews)
5.7
markelof

I can provide you quality application to do this tasks, you will have real time informations....................

$388 USD in 3 days
(25 Reviews)
4.6
rajafaizan

Hi, I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely More

$74 USD in 3 days
(30 Reviews)
4.5
JuliaKonovalchuk

Excellent skills of excel (pivot tabels, summery tables, VBA macro); The ability to work as part of a team; Excellent analytical and numerical abilities; English is intermadiate level; Сurrently going through train More

$25 USD in 10 days
(0 Reviews)
0.0