- Project Overview- Get your Finance API keys.
- Importing financial data using API.
- Creating dashboard- Summary page.
- Creating dashboard- Historical Perormance page.
- Dashboard Automation- Visualizing other stocks.
- The data is composed of historical data for the last 5 years.
We must register to access the API
When we register, the free option is activated, which allows us to make 250 API requests per day.
Once registered we go back to the documentation and we will be given the access Key.
We will use Company Quote from AZMN(Amazon)
We just need to change the APPL URL to AZMN.
That will not give access to a Json file.
We would copy the URL.
In the Power BI Get Data menu, look for the Web option.
In the menu we copy the URL, we can change the Ticker for the financial instrument we want, in this case we will use AMZN (Amazon), but it can be any, where it says YOUR APY we must delete that and place the Key that was assigned to us.
In the next screen click on Connect and the Power Query window will open with the loaded data, click on Close and Apply to load the data.
When loading we check in Data if loading was successful.
We will then use the historical data to obtain all the price variations suffered by the Stock.
We will use the daily price history, but we can choose minutes and hours, we copy the URL as we did before.
We repeat the previous steps to obtain the data from WEB We change to the Ticker we are using and enter the KEY, we will obtain the data we requested and Power Query will open.
We verify that the relationship between the two tables has been created, since the same Ticker (AMZN) or the one you have decided to use should have been generated automatically.
- We add a card with the Ticker of the stock.
- We add a card with the opening price.
- We add a card with the highest price.
- We add a card with the lowest price.
- We add a card with the closing price.
Added two filters, by year and month.
Scatter chart to determine whether or not share price movements are positively correlated.
Line graph with historical transaction volume.
Candlestick chart depicting daily stock price movements.
