Spreadsheet: 168191d1342288362-vlookup-or-hlookup-help-roiperdatesample
Sheet: ROI Per Trade

Ticket | Date | Transaction | Pair | Units | Interest | P/L | Amount | Balance (USD) | ROI Per Trade | DATE
 | March 30 16:00:00 2009 EDT |  |  |  |  |  | 0.0028 | 678.54
 | March 30 22:27:32 2009 EDT |  |  |  |  | 0 | 5389 | 6,067.54
 | March 30 23:59:50 2009 EDT |  |  |  |  |  | 0 | 6,067.54
 | March 30 23:59:50 2009 EDT |  |  |  |  |  | 0 | 6,067.54
 | March 30 23:59:51 2009 EDT |  |  |  |  |  | 0 | 6,067.54
 | March 30 23:59:53 2009 EDT |  |  |  |  |  | 0 | 6,067.54
 | March 30 23:59:57 2009 EDT |  |  |  |  |  | 0 | 6,067.54
 | March 31 04:03:04 2009 EDT |  |  |  |  | 8.88 | 8.8801 | 6,076.42
 | March 31 06:31:34 2009 EDT |  |  |  |  | 18.06 | 18.1143 | 6,094.54
 | March 31 10:39:15 2009 EDT |  |  |  |  | 16.395 | 16.3833 | 6,110.92
 | March 31 11:03:55 2009 EDT |  |  |  |  | 4.53 | 4.5042 | 6,115.42
 | March 31 11:59:32 2009 EDT |  |  |  |  | 14.3231 | 14.2616 | 6,129.69
 | March 31 16:00:00 2009 EDT |  |  |  |  |  | 0.0247 | [NAME]
 | March 31 23:59:54 2009 EDT |  |  |  |  |  | 0 | [NAME]
 | April 1 00:00:03 2009 EDT |  |  |  |  |  | 0 | [NAME]
 | April 1 00:00:07 2009 EDT |  |  |  |  |  | 0 | [NAME]
 | April 1 00:00:08 2009 EDT |  |  |  |  |  | 0 | [NAME]
 | April 1 00:00:10 2009 EDT |  |  |  |  |  | 0 | [NAME]
 | April 1 00:30:56 2009 EDT |  |  |  |  | 14.296 | 14.2934 | 6,144.00
 | April 1 01:54:12 2009 EDT |  |  |  |  | 9.06 | 9.0463 | 6,153.05
 | April 1 07:04:56 2009 EDT |  |  |  |  | 15.045 | 15.0058 | 6,168.06
 | April 1 16:00:00 2009 EDT |  |  |  |  |  | 0.0253 | 6,168.08
 | April 1 16:00:00 2009 EDT |  |  |  |  |  | -0.2473 | 6,167.83
 | April 1 16:00:00 2009 EDT |  |  |  |  |  | -0.0455 | 6,167.79
 | April 2 00:03:25 2009 EDT |  |  |  |  |  | 0 | 6,167.79
 | April 2 00:03:34 2009 EDT |  |  |  |  |  | 0 | 6,167.79
 | April 2 00:03:43 2009 EDT |  |  |  |  |  | 0 | 6,167.79
 | April 2 00:03:47 2009 EDT |  |  |  |  | -29.88 | -29.9031 | 6,137.89
 | April 2 00:04:27 2009 EDT |  |  |  |  |  | 0 | 6,137.89
 | April 2 00:04:33 2009 EDT |  |  |  |  | -86.1 | -86.2255 | 6,051.66
 | April 2 00:05:02 2009 EDT |  |  |  |  |  | 0 | 6,051.66
 | April 2 00:06:00 2009 EDT |  |  |  |  | 0 | 0 | 6,051.66
 | April 2 02:09:19 2009 EDT |  |  |  |  | 34.2 | 34.1853 | 6,085.85
 | April 2 02:21:38 2009 EDT |  |  |  |  | 9.09 | 9.09 | 6,094.94
 | April 2 05:27:22 2009 EDT |  |  |  |  | 88.38 | 88.5174 | 6,183.45
 | April 2 16:00:00 2009 EDT |  |  |  |  |  | 0.0253 | 6,183.48
 | April 2 16:00:00 2009 EDT |  |  |  |  |  | -0.0831 | 6,183.39
 | April 2 16:00:00 2009 EDT |  |  |  |  |  | -0.088 | 6,183.31
 | April 2 23:59:43 2009 EDT |  |  |  |  | -72.7903 | -72.832 | 6,110.47
 | April 2 23:59:43 2009 EDT |  |  |  |  |  | 0 | 6,110.47
 | April 2 23:59:44 2009 EDT |  |  |  |  | -68.175 | -68.2191 | 6,042.26
 | April 2 23:59:44 2009 EDT |  |  |  |  |  | 0 | 6,042.26
 | April 2 23:59:45 2009 EDT |  |  |  |  |  | 0 | 6,042.26
 | April 2 23:59:46 2009 EDT |  |  |  |  |  | 0 | 6,042.26
 | April 2 23:59:47 2009 EDT |  |  |  |  |  | 0 | 6,042.26
 | April 3 04:18:17 2009 EDT |  |  |  |  | 4.53 | 4.5197 | 6,046.78
 | April 3 04:37:26 2009 EDT |  |  |  |  | 18.18 | 18.22 | 6,065.00
 | April 3 04:57:21 2009 EDT |  |  |  |  | 9.12 | 9.1143 | 6,074.11
 | April 3 07:35:43 2009 EDT |  |  |  |  | 0 | 0 | 6,074.11
 | April 3 08:02:09 2009 EDT |  |  |  |  | 0 | 0 | 6,074.11
 | April 3 08:25:42 2009 EDT |  |  |  |  | 0 | 0 | 6,074.11
 | April 3 08:38:34 2009 EDT |  |  |  |  | 0 | 0 | 6,074.11
 | April 3 08:54:16 2009 EDT |  |  |  |  |  | 0 | 6,074.11
 | April 3 08:55:13 2009 EDT |  |  |  |  | 0 | 0 | 6,074.11
 | April 3 09:03:44 2009 EDT |  |  |  |  | 6.24 | 6.238 | 6,080.35
 | April 3 09:43:51 2009 EDT |  |  |  |  |  | 0 | 6,080.35
 | April 3 09:49:50 2009 EDT |  |  |  |  | 0 | 0 | 6,080.35
 | April 3 10:08:40 2009 EDT |  |  |  |  | 0 | 0 | 6,080.35
 | April 3 10:11:40 2009 EDT |  |  |  |  | 0 | 0 | 6,080.35
 | April 3 10:25:19 2009 EDT |  |  |  |  | 0 | 0 | 6,080.35
 | April 3 10:27:31 2009 EDT |  |  |  |  | 13.68 | 13.6783 | 6,094.03
 | April 3 11:00:26 2009 EDT |  |  |  |  | 75.0364 | 74.7763 | 6,168.80
 | April 3 13:13:20 2009 EDT |  |  |  |  | 73.17 | 73.1275 | 6,241.93
 | April 3 16:00:00 2009 EDT |  |  |  |  |  | 0.0252 | 6,241.96
 | April 4 16:00:00 2009 EDT |  |  |  |  |  | 0.0257 | 6,241.98
 | April 5 16:00:00 2009 EDT |  |  |  |  |  | 0.0257 | 6,242.01
 | April 6 16:00:00 2009 EDT |  |  |  |  |  | 0.0257 | 6,242.03
 | April 7 00:00:49 2009 EDT |  |  |  |  |  | 0 | 6,242.03
 | April 7 00:00:55 2009 EDT |  |  |  |  |  | 0 | 6,242.03
 | April 7 00:01:02 2009 EDT |  |  |  |  |  | 0 | 6,242.03
 | April 7 00:01:09 2009 EDT |  |  |  |  |  | 0 | 6,242.03
 | April 7 00:01:22 2009 EDT |  |  |  |  |  | 0 | 6,242.03
 | April 7 00:30:06 2009 EDT |  |  |  |  | 21.06 | 21.0524 | 6,263.08
 | April 7 04:40:28 2009 EDT |  |  |  |  | 9.03 | 9.0013 | 6,272.09
 | April 7 05:03:33 2009 EDT |  |  |  |  | 4.59 | 4.5755 | 6,276.66
 | April 7 06:06:28 2009 EDT |  |  |  |  | 14.8161 | 14.7849 | 6,291.45
 | April 7 09:47:03 2009 EDT |  |  |  |  | 14.955 | 14.9036 | 6,306.35
 | April 7 16:00:00 2009 EDT |  |  |  |  |  | 0.0258 | 6,306.38
 | April 8 00:00:12 2009 EDT |  |  |  |  |  | 0 | 6,306.38
 | April 8 00:00:17 2009 EDT |  |  |  |  |  | 0 | 6,306.38
 | April 8 00:00:23 2009 EDT |  |  |  |  |  | 0 | 6,306.38
 | April 8 00:00:39 2009 EDT |  |  |  |  |  | 0 | 6,306.38
 | April 8 00:00:48 2009 EDT |  |  |  |  |  | 0 | 6,306.38
 | April 8 01:12:00 2009 EDT |  |  |  |  | 9.21 | 9.2027 | 6,315.58
 | April 8 02:18:26 2009 EDT |  |  |  |  | 14.6894 | 14.6776 | 6,330.26
 | April 8 02:18:44 2009 EDT |  |  |  |  | 19.14 | 19.1058 | 6,349.36
 | April 8 07:12:06 2009 EDT |  |  |  |  | 4.575 | 4.5578 | 6,353.92
 | April 8 12:59:48 2009 EDT |  |  |  |  | 15.855 | 15.786 | 6,369.71
 | April 8 16:00:00 2009 EDT |  |  |  |  |  | 0.026 | 6,369.73
 | April 9 16:00:00 2009 EDT |  |  |  |  |  | 0.0262 | 6,369.76
 | April 10 16:00:00 2009 EDT |  |  |  |  |  | 0.0262 | 6,369.78
 | April 11 16:00:00 2009 EDT |  |  |  |  |  | 0.0262 | 6,369.81
 | April 12 16:00:00 2009 EDT |  |  |  |  |  | 0.0262 | 6,369.84
 | April 13 16:00:00 2009 EDT |  |  |  |  |  | 0.0262 | 6,369.86
 | April 14 00:01:30 2009 EDT |  |  |  |  |  | 0 | 6,369.86
 | April 14 00:01:38 2009 EDT |  |  |  |  |  | 0 | 6,369.86
 | April 14 00:01:42 2009 EDT |  |  |  |  |  | 0 | 6,369.86