Time of day is critical for trading, it is even possible building trading strategies solely depending on time of day (I will keep this for another post)

I will be using the concept of quality and define a high quality market, from an intraday timing perspective, as a market when trading range and volume are high and spread is low. I assume this as a good time to trade as trading cost (spread) is low compared to trading opportunity (range and volume)

I start importing libraries,

```
import matplotlib.pyplot as plt
import pandas as pd
import bulk_tester as bt
import numpy as np
%matplotlib inline
```

I then load data for a couple of years for EURUSD, here I am using my own library for loading it from a csv file containing 15 minute bars and sampling at each 60 minutes.

```
pair = "EURUSD"
dftest = bt.get_data(pair, 'BT', resample_period='60T')
```

Then I add three columns; hour for doing the hourly grouping, spread and range

```
dftest['hour'] = dftest.index.hour
dftest['spread'] = (dftest.Ask - dftest.Bid)
dftest['range'] = (dftest.highAsk - dftest.lowBid)
```

I use 3 pivot tables for caclulating and grouping volume, spread and range by hour

```
#find hourly mean volume
table_volume = pd.pivot_table(dftest, values='volume', index=['hour'],
aggfunc=np.mean)
```

```
#find hourly mean spread
table_spread = pd.pivot_table(dftest, values='spread', index=['hour'],
aggfunc=np.mean)
```

```
#find hourly mean range
table_range = pd.pivot_table(dftest, values='range', index=['hour'],
aggfunc=np.mean)
```

I then create a new dataframe with normalized values for range, volume and spread so that they can fit into the same vertical range in a plot. Note that these are not the actual values!

```
summary=pd.DataFrame()
summary["Range"] = table_range/sum(table_range.values)*100
summary["Volume"] = table_volume/sum(table_volume.values)*100
summary["Spread"] = table_spread/sum(table_spread.values)*100
```

```
title = "Normalized Hourly Averages for Trading Range, Volume and Spread"
summary.plot(kind='line', figsize = (10,6), title=title)
```

Looking at trading GMT hours for FX sessions:

Australia = [20,21,22,23,0,1,2,3,4]

Tokyo = [0,1,2,3,4,5,6,7,8]

Europe = [8,9,10,11,12,13,14,15,16]

Americas = [13,14,15,16,17,18,19,20,21]

it can be seen that average volume and range peaks at around US open and spread is close to its minumum at 15:00

In line with my definition of market quality and considering we have normalized figures, I calculate market quality as:

(Volume + Range) / 2 - Spread

and calculate a market quality index (MQI) which peaks at 100 indicating that the opportunity-cost gap is at maximum.

```
summary["Quality"] = (((summary.Volume)+(summary.Range))/2-(summary.Spread))
mqi = summary.Quality*100/summary.Quality.max()
mqi.plot(kind="line", figsize = (10,6), title='Market Quality Index')
```

MQI peaks at 12:00 - 15:00 which is the overlap of Europe and US sessions. MQI bottoms at 20:00 before US session closing. Tokyo and Australia sessions are low range, low volume and high spread sessions

Putting all this together and checking for a set of pairs... an obvious pattern. So what...For intraday traders holding positions for a couple of hours, executing trades when MQI is at its peaks is a good idea as it maximizes the opportunity to cost gap. And it is important to note that despite the similarities, MQI pattern is not the same for all pairs. As an example, looking at USDCAD, MQI peaks in a relatively narrow range and Europe session does not contribute much as it does to other pairs.

```
plt.figure(1, figsize=(16, 30))
#get a list of pair names to loop
df = pd.read_csv('/xxxx/PAIRLIST/PAIRLIST.csv', names=['PAIRNAME'])
a=0#counter for plotting
#loop a list of pairs and plot MQI
for pair in df.PAIRNAME:
s="";
pair = s.join([pair[:3], pair[4:7]])
dftest = bt.get_data(pair, 'BT', resample_period='60T')
dftest['hour'] = dftest.index.hour
dftest['spread'] = (dftest.Ask - dftest.Bid)
dftest['range'] = (dftest.highAsk - dftest.lowBid)
#find hourly mean volume
table_volume = pd.pivot_table(dftest, values='volume', index=['hour'],
aggfunc=np.mean)
#find hourly mean spread
table_spread = pd.pivot_table(dftest, values='spread', index=['hour'],
aggfunc=np.mean)
#find hourly mean range
table_range = pd.pivot_table(dftest, values='range', index=['hour'],
aggfunc=np.mean)
summary=pd.DataFrame()
summary["Range"] = table_range/sum(table_range.values)*100
summary["Volume"] = table_volume/sum(table_volume.values)*100
summary["Spread"] = table_spread/sum(table_spread.values)*100
summary["Quality"] = (((summary.Volume)+(summary.Range))/2-(summary.Spread))
mqi = summary.Quality*100/summary.Quality.max()
a+=1#counter for plotting
plt.subplot(len(df),4,a)
plt.plot(mqi)
plt.yscale('linear')
plt.title(pair)
plt.grid(False)
plt.tight_layout()
```

```
```

Language sorry i am little dummie and beginner

ReplyDeleteI will be happy to answer if you have a question.

Delete