Automated stock price retrieval from Yahoo finance (108 shares from OMX Stockholm large cap)
$10-30 USD
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.
Project ID: #9891794
About the project
Awarded to:
Hi, Thanks for the invitation. As it was me who made the previous one I think it wont be difficult to create this one.
7 freelancers are bidding on average $110 for this job
Hi! Thank you for invitation. Do you need the excel file to download data as well or you already have that vba code?
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..
I can provide you quality application to do this tasks, you will have real time informations....................
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
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