The purpose of this tutorial is to analyze and compare the market value of companies over time. To do this, we will see step by step how to download data from the Yahoo Finance site and then how to import this data into Power BI and process it in order to create a report.
Step I: Downloading data from the Yahoo Finance website
Type the company of your choice (in our case Facebook, which has FB symbol) in the Yahoo search bar
In the bottom menu, click on “historical data”
4. Indicate the maximum duration (you should select "Max" in order to have all historical data)
5. Select "Daily" for frequency
6. Click on “Apply”
7. Finally, click on “download“.
NB: Repeat the same steps for all the desired companies.
In this tutorial we will take a second company, Google (GOOG symbol).
Step II: Data processing on Power BI Desktop
In the previous step we downloaded the Facebook and Google data from the Yahoo Finance site. Now we will import and process this data. It should be noted that for this tutorial, we used the version: 2.75.5649.961 64-bit (November 2019) of Microsoft Power BI Desktop.
In Power BI Desktop, Click on the "File" tab then "New"
In the window that appears click on "Get data"
Click on "Folder"
Fill in the filepath of your folder (the folder in which your files are previously downloaded). Then click "ok"
In the window that opens click on "combine" then on "combine and transform"
The combined files window is displayed, click on "OK".
Apply the changes
On the Home tab, in the External data group, click on "Edit queries".
Right under “APPLIED STEPS” in the pane “Query Parameters” click on “Source”.
Click the two arrows to the right of the "Content" column to expand the columns of the tables.
Rename the first column “source.name” to “Company”
We will then select the csv files relating to Facebook and Google
In the table obtained click the launcher to the right of the “Company” column, check only the boxes relating to Facebook and Google, click ok.
Taking into account the number of shares.
Here, we have to go to the Yahoo Finance site to get a hold of a statistical value called "Shares Outstanding". To do this, we must: