Woofy_McWoof_Woof
Board Regular
- Joined
- Oct 7, 2016
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
Hi
I currently have a dataset which displays an hourly price each day over multiple years, I then have an index match formula that splits the hourly price into two half hourly prices (same value). Although this works it is taking too long to recalculate each time I update it and has greatly increased the memory size of the file. Is there anyway that rather than have the formula I just run a macro that converts the data for me?
I've copied min an example below, any help would be most appreciated.
[TABLE="width: 498"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date
[/TD]
[TD]Period (24 hour)
[/TD]
[TD]Price 1
[/TD]
[TD]Date
[/TD]
[TD]Period (48 periods)
[/TD]
[TD]Price 2
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]1
[/TD]
[TD] 32.22
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]1
[/TD]
[TD] 32.22
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]2
[/TD]
[TD] 32.22
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]2
[/TD]
[TD] 32.22
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]4
[/TD]
[TD] 30.72
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]3
[/TD]
[TD] 30.72
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]6
[/TD]
[TD] 30.91
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]4
[/TD]
[TD] 30.72
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]8
[/TD]
[TD] 25.92
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]5
[/TD]
[TD] 30.91
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]10
[/TD]
[TD] 25.92
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]6
[/TD]
[TD] 30.91
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]12
[/TD]
[TD] 30.99
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]7
[/TD]
[TD] 25.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]14
[/TD]
[TD] 31.82
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]8
[/TD]
[TD] 25.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]16
[/TD]
[TD] 38.06
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]9
[/TD]
[TD] 25.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]18
[/TD]
[TD] 40.55
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]10
[/TD]
[TD] 25.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]20
[/TD]
[TD] 45.14
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]11
[/TD]
[TD] 30.99
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]22
[/TD]
[TD] 52.05
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]12
[/TD]
[TD] 30.99
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]24
[/TD]
[TD] 49.92
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]13
[/TD]
[TD] 31.82
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]26
[/TD]
[TD] 46.97
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]14
[/TD]
[TD] 31.82
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]28
[/TD]
[TD] 43.80
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]15
[/TD]
[TD] 38.06
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]30
[/TD]
[TD] 42.54
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]16
[/TD]
[TD] 38.06
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]32
[/TD]
[TD] 45.25
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]17
[/TD]
[TD] 40.55
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]34
[/TD]
[TD] 53.56
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]18
[/TD]
[TD] 40.55
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]36
[/TD]
[TD] 67.57
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]19
[/TD]
[TD] 45.14
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]38
[/TD]
[TD] 61.27
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]20
[/TD]
[TD] 45.14
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]40
[/TD]
[TD] 44.94
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]21
[/TD]
[TD] 52.05
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]42
[/TD]
[TD] 41.86
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]22
[/TD]
[TD] 52.05
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]44
[/TD]
[TD] 35.99
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]23
[/TD]
[TD] 49.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]46
[/TD]
[TD] 31.97
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]24
[/TD]
[TD] 49.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]48
[/TD]
[TD] 30.92
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]25
[/TD]
[TD] 46.97
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]26
[/TD]
[TD] 46.97
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]27
[/TD]
[TD] 43.80
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]28
[/TD]
[TD] 43.80
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]29
[/TD]
[TD] 42.54
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]30
[/TD]
[TD] 42.54
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]31
[/TD]
[TD] 45.25
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]32
[/TD]
[TD] 45.25
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]33
[/TD]
[TD] 53.56
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]34
[/TD]
[TD] 53.56
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]35
[/TD]
[TD] 67.57
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]36
[/TD]
[TD] 67.57
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]37
[/TD]
[TD] 61.27
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]38
[/TD]
[TD] 61.27
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]39
[/TD]
[TD] 44.94
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]40
[/TD]
[TD] 44.94
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]41
[/TD]
[TD] 41.86
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]42
[/TD]
[TD] 41.86
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]43
[/TD]
[TD] 35.99
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]44
[/TD]
[TD] 35.99
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]45
[/TD]
[TD] 31.97
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]46
[/TD]
[TD] 31.97
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]47
[/TD]
[TD] 30.92
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]48
[/TD]
[TD] 30.92
[/TD]
[/TR]
</tbody>[/TABLE]
I currently have a dataset which displays an hourly price each day over multiple years, I then have an index match formula that splits the hourly price into two half hourly prices (same value). Although this works it is taking too long to recalculate each time I update it and has greatly increased the memory size of the file. Is there anyway that rather than have the formula I just run a macro that converts the data for me?
I've copied min an example below, any help would be most appreciated.
[TABLE="width: 498"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date
[/TD]
[TD]Period (24 hour)
[/TD]
[TD]Price 1
[/TD]
[TD]Date
[/TD]
[TD]Period (48 periods)
[/TD]
[TD]Price 2
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]1
[/TD]
[TD] 32.22
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]1
[/TD]
[TD] 32.22
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]2
[/TD]
[TD] 32.22
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]2
[/TD]
[TD] 32.22
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]4
[/TD]
[TD] 30.72
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]3
[/TD]
[TD] 30.72
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]6
[/TD]
[TD] 30.91
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]4
[/TD]
[TD] 30.72
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]8
[/TD]
[TD] 25.92
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]5
[/TD]
[TD] 30.91
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]10
[/TD]
[TD] 25.92
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]6
[/TD]
[TD] 30.91
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]12
[/TD]
[TD] 30.99
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]7
[/TD]
[TD] 25.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]14
[/TD]
[TD] 31.82
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]8
[/TD]
[TD] 25.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]16
[/TD]
[TD] 38.06
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]9
[/TD]
[TD] 25.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]18
[/TD]
[TD] 40.55
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]10
[/TD]
[TD] 25.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]20
[/TD]
[TD] 45.14
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]11
[/TD]
[TD] 30.99
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]22
[/TD]
[TD] 52.05
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]12
[/TD]
[TD] 30.99
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]24
[/TD]
[TD] 49.92
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]13
[/TD]
[TD] 31.82
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]26
[/TD]
[TD] 46.97
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]14
[/TD]
[TD] 31.82
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]28
[/TD]
[TD] 43.80
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]15
[/TD]
[TD] 38.06
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]30
[/TD]
[TD] 42.54
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]16
[/TD]
[TD] 38.06
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]32
[/TD]
[TD] 45.25
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]17
[/TD]
[TD] 40.55
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]34
[/TD]
[TD] 53.56
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]18
[/TD]
[TD] 40.55
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]36
[/TD]
[TD] 67.57
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]19
[/TD]
[TD] 45.14
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]38
[/TD]
[TD] 61.27
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]20
[/TD]
[TD] 45.14
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]40
[/TD]
[TD] 44.94
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]21
[/TD]
[TD] 52.05
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]42
[/TD]
[TD] 41.86
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]22
[/TD]
[TD] 52.05
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]44
[/TD]
[TD] 35.99
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]23
[/TD]
[TD] 49.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]46
[/TD]
[TD] 31.97
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]24
[/TD]
[TD] 49.92
[/TD]
[/TR]
[TR]
[TD="align: right"]01-Jan-17
[/TD]
[TD]48
[/TD]
[TD] 30.92
[/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]25
[/TD]
[TD] 46.97
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]26
[/TD]
[TD] 46.97
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]27
[/TD]
[TD] 43.80
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]28
[/TD]
[TD] 43.80
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]29
[/TD]
[TD] 42.54
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]30
[/TD]
[TD] 42.54
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]31
[/TD]
[TD] 45.25
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]32
[/TD]
[TD] 45.25
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]33
[/TD]
[TD] 53.56
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]34
[/TD]
[TD] 53.56
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]35
[/TD]
[TD] 67.57
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]36
[/TD]
[TD] 67.57
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]37
[/TD]
[TD] 61.27
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]38
[/TD]
[TD] 61.27
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]39
[/TD]
[TD] 44.94
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]40
[/TD]
[TD] 44.94
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]41
[/TD]
[TD] 41.86
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]42
[/TD]
[TD] 41.86
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]43
[/TD]
[TD] 35.99
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]44
[/TD]
[TD] 35.99
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]45
[/TD]
[TD] 31.97
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]46
[/TD]
[TD] 31.97
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]47
[/TD]
[TD] 30.92
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01-Jan-17
[/TD]
[TD="align: right"]48
[/TD]
[TD] 30.92
[/TD]
[/TR]
</tbody>[/TABLE]