Research financial Data and Add it to Excel Sheet.
Budget: $10 – $30 AUD
This job requires someone to investigate the performance of several companies listed on the ASX.
I want to compare the return on investment for 20 different companies.
In the attached spreadsheet, you can see that I have entered a few figures in several Rows.
What you need to do is find out the closing price on 26 Oct 2018 of the securities listed in Cell 1 of columns C to V.
Enter those prices in Row 9.
Then, in Rows 15-64, I need the amount in cents per share of the dividends paid by those companies at various times over the last 4 years.
You can find Info for Vanguard Products ( Columns P to V) on this page:
https://www.vanguard.com.au/adviser/products/en/list/overview/etf
To demonstrate your ability to understand the requirements of the job, locate the data for tickers ASX and AWC in 2018, and enter it in Columns C and D.
Include your edited version of the XLSX in your application.
NO placemarker bids.
Quote your price for the job – NOT your hourly rate.
NO phone calls or emails; Freelancer applications only
I want to compare the return on investment for 20 different companies.
In the attached spreadsheet, you can see that I have entered a few figures in several Rows.
What you need to do is find out the closing price on 26 Oct 2018 of the securities listed in Cell 1 of columns C to V.
Enter those prices in Row 9.
Then, in Rows 15-64, I need the amount in cents per share of the dividends paid by those companies at various times over the last 4 years.
You can find Info for Vanguard Products ( Columns P to V) on this page:
https://www.vanguard.com.au/adviser/products/en/list/overview/etf
To demonstrate your ability to understand the requirements of the job, locate the data for tickers ASX and AWC in 2018, and enter it in Columns C and D.
Include your edited version of the XLSX in your application.
NO placemarker bids.
Quote your price for the job – NOT your hourly rate.
NO phone calls or emails; Freelancer applications only