I need a spread sheet created that contains predefined information on all Australian listed entities. I have seen spread sheets that do this for US stocks but cannot find any that do Australian.
The spread sheet should be able to obtain information from either Google finance and Thomson Reuters or Yahoo finance on all Australian Listed entities.
The spread sheet needs to be able to be updated automatically.
An example of the spread sheet based on the ASX 300 is attached as spread sheet 1. One Item missing is the sector companies are in this needs to be included.
The spread sheet need also to have data on the following indices - (Ticker AS30, AS51, AS52, AS34 SPAEX and AS38. and Identify which stock are in which index. The attached spread sheet shows the ASX listed companies as at 2 June 2014, I have hidden columns for companies not required.
Ideally the spread sheet will have a data sheet and a summary sheet similar to spread sheet 2 attached (This is the best spread sheet I have found but only has 11 Australian stocks.
The sheet also needs to be easily updated in a company comes into the market.
If you have any questions please email me. I can compromise on features to bring in within budget.
15 freelancers are bidding on average $215 for this job
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
Consider it done professionally. I read out your project details and confidently bid over there to solve the matte. Please give me a chance to execute it. Regards
Hello, my name is Cristian, I have a degree in Business and I am Financial Advisor. In addition, working with excel every day, I have much experience with spreadsheets, complex formulas and macros. Greetings.