A useful spreadsheet for a forex trader can be created in different ways. This tutorial article teaches you one of the useful methods for creating a useful spreadsheet.
Forex data download
1. Click on Power Query (1), and then from web (2)
2. Go to the website where you are trading. This is the one place that the tutorial cannot really tell, because it is completely dependent on where the user is trading from. Just copy the link on that website.
3. Press CTRL + V to paste the link (1) and press ok (2).
4. Choose a table that suits your needs.
5. Click Load.
Creating a forex datasheet
In conclusion, this is useful for a forex trader because it allows the spreadsheet to be utilized with real-time data directly from the source.
This would look something like this: