How To Create A Useful Spreadsheet For Forex Trader?
1. Click on Power Query (1), and then from web (2)
2. Go to the website where you are trading. This is the place that the tutorial cannot really tell, because it is completely dependent on where the user is trading from. Just copy the link in that website.
3. Press CTRL + V to paste the link (1) and press ok (2).
4. Choose a table that suits your need.
5. Click Load.
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 looks something like this:
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References
