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 기타
