Eduardo Andrade Data analyst and Economist A blog about economics, data and anything else

Analyzing a trend following pattern in Forex

Trend following traders usually go to higher timeframes; here we will check out if there is a persistent trend within an intraday scenario on the Forex market.

Databases and spreadsheets with SQL

Google Sheets can also be used for data analysis with the amazing and very simple function Query, even to create some interactive charts.

Creating a basic backtesting algorithm for trading

Building a backtesting system for financial markets can be a challenge, but the whole process for sure is very rewarding. I created a simple algorithm with an optimization function to test the performance of a given set of trades.

Analyzing the ATR as a volatility prediction tool

Is the Average True Range a reliable indicator to predict future volatility in financial markets? I ran some scenarios to get an understanding on its behavior with Forex daily charts.

An essay on basic ETL

Finding out the roots of your data and understanding how it came to be there can make a big difference in the quality of the analysis.