Create SAS/excel VBA web pull
$30-250 AUD
货到付款
I'm looking for a SAS or excel expert to write up a piece of code that runs web queries and pulls the following into a report that can be run daily. The data and content to be pulled is related to share trading on the Australian Stock Exchange (ASX), leveraging several sources to build a profile of small cap stocks. Initially, the objective will be to produce a report with the following metrics
- Stock name and stock code (list will be shared before project acceptance)
- Market capitalization
- Price to earnings ratio
- Price to book value
- Top 20 shareholders of each company
- % of total shares owned by the top 20 shareholders
- Timeline showing future quarterly activities
- Debt equity ratio (currently being pulled from CommSec)
Sources include:
- [url removed, login to view]
- [url removed, login to view]
项目ID： #16051358
关于项目
有15名威客正在参与此工作的竞标，均价$249/小时
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an En 更多
Dear, I ll code an Excel/VBA macro to extract the data and generate the report. But I need to have a short discussion to clarify some points before. Thanks Relevant Skills and Experience Excel/VBA Expert Proposed Mil 更多
Greeting, I have understood your Create SAS/excel VBA web pull task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experienc 更多
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Relevant Skills and Experi 更多
