Create SAS/excel VBA web pull

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

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]

Data Processing Excel SAS Visual Basic

Project ID: #16051358

About the project

15 proposals Remote project Active 6 years ago

15 freelancers are bidding on average $249 for this job

jaylancer43

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 More

$200 AUD in 2 days
(539 Reviews)
8.1
bouslimi1979

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 More

$200 AUD in 5 days
(192 Reviews)
7.2
schoudhary1553

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 More

$160 AUD in 3 days
(225 Reviews)
7.3
elqueabandona

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 More

$250 AUD in 7 days
(182 Reviews)
6.7
ongskjason

I will produce Excel with macro and VBA.

$120 AUD in 2 days
(2 Reviews)
2.8
rayyankabir

A proposal has not yet been provided

$1600 AUD in 3 days
(1 Review)
0.6
excelfhc

We are a team of experts in Excel, macros in VBA and visual basic, + C, we have developed administrative systems and exceldashboard for 10 years. Relevant Skills and Experience We are a team of experts in Excel, macro More

$155 AUD in 15 days
(0 Reviews)
0.0
saikirannsas

A proposal has not yet been provided

$40 AUD in 3 days
(0 Reviews)
0.0
$222 AUD in 10 days
(0 Reviews)
0.0
dholeashwini

A proposal has not yet been provided

$155 AUD in 3 days
(0 Reviews)
0.0
kattasaikrishna

A proposal has not yet been provided

$155 AUD in 3 days
(0 Reviews)
0.0