Choose two companies [i] from TWO different industries listed on the Australian Securities Exchange (ASX). To view ASX listed companies, go to http://www.asx.com.au/asx/research/listedCompanies.do b. To download the data, go to http://finance.yahoo.com c. Find a search box titled “Get Quotes” & type the name of your first company [i1]. Then click “Get Quotes”. d. See the menu on the left-hand side. Click “Historical Prices” under “Quotes”. e. See “Set Date Range”. Set Start date as 26th August 2011 and End date as 26th August 2016 (sample period). Click on “Monthly” button. Then Click “Get Prices”. f. 61 month-end price data should now be visible on the screen. Scroll down until you see “Download to Spreadsheet”. Save the data to a file (You will see that date on the spreadsheet is shown as month-start except for 26/08/2011). Don’t worry about them. They are actually month-end data. g. You will see seven columns in the saved spreadsheet. All we need is Date and Adj. close price [P]. Delete other columns. Currently, the data is in descending order. Go to “Data” tab and click “Sort”. Select “Date” for Sort by and “Oldest to Newest” for order. Click “OK”. The data should now be in ascending order. Save the file again. h. Replicate steps b to g to download data for your second company [i2]. i. Replicate steps b to g to download market index data [m]. For this assignment, the market index “S&P/ASX200” is to be used. Symbol to be entered to “Get Quotes” box is ^AXJO. j. Display the following on the same spreadsheet, i) date, ii) Adj. close price for your first stock [Pi1] , iii) Adj, close price for your second stock [Pi2] and iv) Adj. close price for the market index [Pm]. Then save the file in Excel format. At this point, you should have four columns and 62 rows (The company names do not need to be presented here. Introduce your company names in your report in Part II.)
The post TWO different industries listed on the Australian Securities Exchange (ASX) appeared first on Homework Aider.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
