Spreadsheet: 168196d1342290334-vlookup-or-hlookup-help-roiperdatesample-jrtaylor-oeldere-
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 | 0 | 2009-03-30 00:00:00
 | March 30 22:27:32 2009 EDT |  |  |  |  | 0 | 5389 | 6,067.54 | 0 | 2009-03-30 00:00:00
 | March 30 23:59:50 2009 EDT |  |  |  |  |  | 0 | 6,067.54 | 0 | 2009-03-30 00:00:00
 | March 30 23:59:50 2009 EDT |  |  |  |  |  | 0 | 6,067.54 | 0 | 2009-03-30 00:00:00
 | March 30 23:59:51 2009 EDT |  |  |  |  |  | 0 | 6,067.54 | 0 | 2009-03-30 00:00:00
 | March 30 23:59:53 2009 EDT |  |  |  |  |  | 0 | 6,067.54 | 0 | 2009-03-30 00:00:00
 | March 30 23:59:57 2009 EDT |  |  |  |  |  | 0 | 6,067.54 | 0 | 2009-03-30 00:00:00
 | March 31 04:03:04 2009 EDT |  |  |  |  | 8.88 | 8.8801 | 6,076.42 | 0.001461386803413852 | 2009-03-31 00:00:00
 | March 31 06:31:34 2009 EDT |  |  |  |  | 18.06 | 18.1143 | 6,094.54 | 0.002963308141385568 | 2009-03-31 00:00:00
 | March 31 10:39:15 2009 EDT |  |  |  |  | 16.395 | 16.3833 | 6,110.92 | 0.002682902083483338 | 2009-03-31 00:00:00
 | March 31 11:03:55 2009 EDT |  |  |  |  | 4.53 | 4.5042 | 6,115.42 | 0.00074075043087801 | 2009-03-31 00:00:00
 | March 31 11:59:32 2009 EDT |  |  |  |  | 14.3231 | 14.2616 | 6,129.69 | 0.002336676079867008 | 2009-03-31 00:00:00
 | March 31 16:00:00 2009 EDT |  |  |  |  |  | 0.0247 | [NAME] | 0 | 2009-03-31 00:00:00
 | March 31 23:59:54 2009 EDT |  |  |  |  |  | 0 | [NAME] | 0 | 2009-03-31 00:00:00
 | April 1 00:00:03 2009 EDT |  |  |  |  |  | 0 | [NAME] | 0 | 2009-04-01 00:00:00
 | April 1 00:00:07 2009 EDT |  |  |  |  |  | 0 | [NAME] | 0 | 2009-04-01 00:00:00
 | April 1 00:00:08 2009 EDT |  |  |  |  |  | 0 | [NAME] | 0 | 2009-04-01 00:00:00
 | April 1 00:00:10 2009 EDT |  |  |  |  |  | 0 | [NAME] | 0 | 2009-04-01 00:00:00
 | April 1 00:30:56 2009 EDT |  |  |  |  | 14.296 | 14.2934 | 6,144.00 | 0.002326822916666667 | 2009-04-01 00:00:00
 | April 1 01:54:12 2009 EDT |  |  |  |  | 9.06 | 9.0463 | 6,153.05 | 0.001472440496989298 | 2009-04-01 00:00:00
 | April 1 07:04:56 2009 EDT |  |  |  |  | 15.045 | 15.0058 | 6,168.06 | 0.002439178607211992 | 2009-04-01 00:00:00
 | April 1 16:00:00 2009 EDT |  |  |  |  |  | 0.0253 | 6,168.08 | 0 | 2009-04-01 00:00:00
 | April 1 16:00:00 2009 EDT |  |  |  |  |  | -0.2473 | 6,167.83 | 0 | 2009-04-01 00:00:00
 | April 1 16:00:00 2009 EDT |  |  |  |  |  | -0.0455 | 6,167.79 | 0 | 2009-04-01 00:00:00
 | April 2 00:03:25 2009 EDT |  |  |  |  |  | 0 | 6,167.79 | 0 | 2009-04-02 00:00:00
 | April 2 00:03:34 2009 EDT |  |  |  |  |  | 0 | 6,167.79 | 0 | 2009-04-02 00:00:00
 | April 2 00:03:43 2009 EDT |  |  |  |  |  | 0 | 6,167.79 | 0 | 2009-04-02 00:00:00
 | April 2 00:03:47 2009 EDT |  |  |  |  | -29.88 | -29.9031 | 6,137.89 | -0.004868122432953343 | 2009-04-02 00:00:00
 | April 2 00:04:27 2009 EDT |  |  |  |  |  | 0 | 6,137.89 | 0 | 2009-04-02 00:00:00
 | April 2 00:04:33 2009 EDT |  |  |  |  | -86.1 | -86.2255 | 6,051.66 | -0.01422750121454279 | 2009-04-02 00:00:00
 | April 2 00:05:02 2009 EDT |  |  |  |  |  | 0 | 6,051.66 | 0 | 2009-04-02 00:00:00
 | April 2 00:06:00 2009 EDT |  |  |  |  | 0 | 0 | 6,051.66 | 0 | 2009-04-02 00:00:00
 | April 2 02:09:19 2009 EDT |  |  |  |  | 34.2 | 34.1853 | 6,085.85 | 0.005619592990297165 | 2009-04-02 00:00:00
 | April 2 02:21:38 2009 EDT |  |  |  |  | 9.09 | 9.09 | 6,094.94 | 0.001491401063833278 | 2009-04-02 00:00:00
 | April 2 05:27:22 2009 EDT |  |  |  |  | 88.38 | 88.5174 | 6,183.45 | 0.01429299177643549 | 2009-04-02 00:00:00
 | April 2 16:00:00 2009 EDT |  |  |  |  |  | 0.0253 | 6,183.48 | 0 | 2009-04-02 00:00:00
 | April 2 16:00:00 2009 EDT |  |  |  |  |  | -0.0831 | 6,183.39 | 0 | 2009-04-02 00:00:00
 | April 2 16:00:00 2009 EDT |  |  |  |  |  | -0.088 | 6,183.31 | 0 | 2009-04-02 00:00:00
 | April 2 23:59:43 2009 EDT |  |  |  |  | -72.7903 | -72.832 | 6,110.47 | -0.01191238971797587 | 2009-04-02 00:00:00
 | April 2 23:59:43 2009 EDT |  |  |  |  |  | 0 | 6,110.47 | 0 | 2009-04-02 00:00:00
 | April 2 23:59:44 2009 EDT |  |  |  |  | -68.175 | -68.2191 | 6,042.26 | -0.01128302985968826 | 2009-04-02 00:00:00
 | April 2 23:59:44 2009 EDT |  |  |  |  |  | 0 | 6,042.26 | 0 | 2009-04-02 00:00:00
 | April 2 23:59:45 2009 EDT |  |  |  |  |  | 0 | 6,042.26 | 0 | 2009-04-02 00:00:00
 | April 2 23:59:46 2009 EDT |  |  |  |  |  | 0 | 6,042.26 | 0 | 2009-04-02 00:00:00
 | April 2 23:59:47 2009 EDT |  |  |  |  |  | 0 | 6,042.26 | 0 | 2009-04-02 00:00:00
 | April 3 04:18:17 2009 EDT |  |  |  |  | 4.53 | 4.5197 | 6,046.78 | 0.0007491590565557206 | 2009-04-03 00:00:00
 | April 3 04:37:26 2009 EDT |  |  |  |  | 18.18 | 18.22 | 6,065.00 | 0.002997526793075021 | 2009-04-03 00:00:00
 | April 3 04:57:21 2009 EDT |  |  |  |  | 9.12 | 9.1143 | 6,074.11 | 0.00150145453407989 | 2009-04-03 00:00:00
 | April 3 07:35:43 2009 EDT |  |  |  |  | 0 | 0 | 6,074.11 | 0 | 2009-04-03 00:00:00
 | April 3 08:02:09 2009 EDT |  |  |  |  | 0 | 0 | 6,074.11 | 0 | 2009-04-03 00:00:00
 | April 3 08:25:42 2009 EDT |  |  |  |  | 0 | 0 | 6,074.11 | 0 | 2009-04-03 00:00:00
 | April 3 08:38:34 2009 EDT |  |  |  |  | 0 | 0 | 6,074.11 | 0 | 2009-04-03 00:00:00
 | April 3 08:54:16 2009 EDT |  |  |  |  |  | 0 | 6,074.11 | 0 | 2009-04-03 00:00:00
 | April 3 08:55:13 2009 EDT |  |  |  |  | 0 | 0 | 6,074.11 | 0 | 2009-04-03 00:00:00
 | April 3 09:03:44 2009 EDT |  |  |  |  | 6.24 | 6.238 | 6,080.35 | 0.001026256712195844 | 2009-04-03 00:00:00
 | April 3 09:43:51 2009 EDT |  |  |  |  |  | 0 | 6,080.35 | 0 | 2009-04-03 00:00:00
 | April 3 09:49:50 2009 EDT |  |  |  |  | 0 | 0 | 6,080.35 | 0 | 2009-04-03 00:00:00
 | April 3 10:08:40 2009 EDT |  |  |  |  | 0 | 0 | 6,080.35 | 0 | 2009-04-03 00:00:00
 | April 3 10:11:40 2009 EDT |  |  |  |  | 0 | 0 | 6,080.35 | 0 | 2009-04-03 00:00:00
 | April 3 10:25:19 2009 EDT |  |  |  |  | 0 | 0 | 6,080.35 | 0 | 2009-04-03 00:00:00
 | April 3 10:27:31 2009 EDT |  |  |  |  | 13.68 | 13.6783 | 6,094.03 | 0.002244819930325253 | 2009-04-03 00:00:00
 | April 3 11:00:26 2009 EDT |  |  |  |  | 75.0364 | 74.7763 | 6,168.80 | 0.01216385682790818 | 2009-04-03 00:00:00
 | April 3 13:13:20 2009 EDT |  |  |  |  | 73.17 | 73.1275 | 6,241.93 | 0.01172233588008837 | 2009-04-03 00:00:00
 | April 3 16:00:00 2009 EDT |  |  |  |  |  | 0.0252 | 6,241.96 | 0 | 2009-04-03 00:00:00
 | April 4 16:00:00 2009 EDT |  |  |  |  |  | 0.0257 | 6,241.98 | 0 | 2009-04-04 00:00:00
 | April 5 16:00:00 2009 EDT |  |  |  |  |  | 0.0257 | 6,242.01 | 0 | 2009-04-05 00:00:00
 | April 6 16:00:00 2009 EDT |  |  |  |  |  | 0.0257 | 6,242.03 | 0 | 2009-04-06 00:00:00
 | April 7 00:00:49 2009 EDT |  |  |  |  |  | 0 | 6,242.03 | 0 | 2009-04-07 00:00:00
 | April 7 00:00:55 2009 EDT |  |  |  |  |  | 0 | 6,242.03 | 0 | 2009-04-07 00:00:00
 | April 7 00:01:02 2009 EDT |  |  |  |  |  | 0 | 6,242.03 | 0 | 2009-04-07 00:00:00
 | April 7 00:01:09 2009 EDT |  |  |  |  |  | 0 | 6,242.03 | 0 | 2009-04-07 00:00:00
 | April 7 00:01:22 2009 EDT |  |  |  |  |  | 0 | 6,242.03 | 0 | 2009-04-07 00:00:00
 | April 7 00:30:06 2009 EDT |  |  |  |  | 21.06 | 21.0524 | 6,263.08 | 0.003362562828512489 | 2009-04-07 00:00:00
 | April 7 04:40:28 2009 EDT |  |  |  |  | 9.03 | 9.0013 | 6,272.09 | 0.001439711483731898 | 2009-04-07 00:00:00
 | April 7 05:03:33 2009 EDT |  |  |  |  | 4.59 | 4.5755 | 6,276.66 | 0.0007312806492625058 | 2009-04-07 00:00:00
 | April 7 06:06:28 2009 EDT |  |  |  |  | 14.8161 | 14.7849 | 6,291.45 | 0.002354957919080657 | 2009-04-07 00:00:00
 | April 7 09:47:03 2009 EDT |  |  |  |  | 14.955 | 14.9036 | 6,306.35 | 0.00237141928373782 | 2009-04-07 00:00:00
 | April 7 16:00:00 2009 EDT |  |  |  |  |  | 0.0258 | 6,306.38 | 0 | 2009-04-07 00:00:00
 | April 8 00:00:12 2009 EDT |  |  |  |  |  | 0 | 6,306.38 | 0 | 2009-04-08 00:00:00
 | April 8 00:00:17 2009 EDT |  |  |  |  |  | 0 | 6,306.38 | 0 | 2009-04-08 00:00:00
 | April 8 00:00:23 2009 EDT |  |  |  |  |  | 0 | 6,306.38 | 0 | 2009-04-08 00:00:00
 | April 8 00:00:39 2009 EDT |  |  |  |  |  | 0 | 6,306.38 | 0 | 2009-04-08 00:00:00
 | April 8 00:00:48 2009 EDT |  |  |  |  |  | 0 | 6,306.38 | 0 | 2009-04-08 00:00:00
 | April 8 01:12:00 2009 EDT |  |  |  |  | 9.21 | 9.2027 | 6,315.58 | 0.001458298366895836 | 2009-04-08 00:00:00
 | April 8 02:18:26 2009 EDT |  |  |  |  | 14.6894 | 14.6776 | 6,330.26 | 0.002320505002954065 | 2009-04-08 00:00:00
 | April 8 02:18:44 2009 EDT |  |  |  |  | 19.14 | 19.1058 | 6,349.36 | 0.003014477049655398 | 2009-04-08 00:00:00
 | April 8 07:12:06 2009 EDT |  |  |  |  | 4.575 | 4.5578 | 6,353.92 | 0.0007200279512489928 | 2009-04-08 00:00:00
 | April 8 12:59:48 2009 EDT |  |  |  |  | 15.855 | 15.786 | 6,369.71 | 0.002489124308641995 | 2009-04-08 00:00:00
 | April 8 16:00:00 2009 EDT |  |  |  |  |  | 0.026 | 6,369.73 | 0 | 2009-04-08 00:00:00
 | April 9 16:00:00 2009 EDT |  |  |  |  |  | 0.0262 | 6,369.76 | 0 | 2009-04-09 00:00:00
 | April 10 16:00:00 2009 EDT |  |  |  |  |  | 0.0262 | 6,369.78 | 0 | 2009-04-10 00:00:00
 | April 11 16:00:00 2009 EDT |  |  |  |  |  | 0.0262 | 6,369.81 | 0 | 2009-04-11 00:00:00
 | April 12 16:00:00 2009 EDT |  |  |  |  |  | 0.0262 | 6,369.84 | 0 | 2009-04-12 00:00:00
 | April 13 16:00:00 2009 EDT |  |  |  |  |  | 0.0262 | 6,369.86 | 0 | 2009-04-13 00:00:00
 | April 14 00:01:30 2009 EDT |  |  |  |  |  | 0 | 6,369.86 | 0 | 2009-04-14 00:00:00
 | April 14 00:01:38 2009 EDT |  |  |  |  |  | 0 | 6,369.86 | 0 | 2009-04-14 00:00:00
 | April 14 00:01:42 2009 EDT |  |  |  |  |  | 0 | 6,369.86 | 0 | 2009-04-14 00:00:00