Support Board
Date/Time: Fri, 31 Jan 2025 18:49:57 +0000
Post From: calculate bars per x time
| [2019-05-16 05:48:03] |
| whats1thingnow - Posts: 407 |
|
tried the start time at 9:30:00 but unfortunately didn't work: 2019-05-15 09:32:44 2817.25 2817.25 2816.50 2816.50 264 150 43600.399
2019-05-15 09:32:25 2817.50 2817.75 2816.25 2817.00 3245 1559 43600.396 2019-05-15 09:32:07 2818.50 2818.50 2817.75 2817.75 1520 780 43600.396 2019-05-15 09:32:01 2818.00 2818.25 2817.50 2818.25 1052 532 43600.396 2019-05-15 09:31:47 2819.00 2819.00 2818.25 2818.25 1249 611 43600.396 2019-05-15 09:31:31 2819.25 2819.50 2818.00 2818.75 1717 1001 43600.396 2019-05-15 09:31:00 2818.00 2820.25 2817.25 2819.50 6014 2893 43600.396 2019-05-15 09:30:31 2818.75 2819.25 2817.00 2817.75 5242 2494 43600.396 2019-05-15 09:30:12 2818.75 2819.75 2818.50 2819.00 3096 1659 43600.396 2019-05-15 09:30:06 2817.75 2818.50 2817.75 2818.50 1588 774 43600.396 2019-05-15 09:30:00 2818.25 2818.75 2817.75 2818.00 3456 1479 43600.396 as seen above, 09:32:44 it became 43600.399 the reason i want 9:30:00 to 9:34:59 to be 1 set then 9:35:00 to 9:39:59 to be the 2nd set is because i'm doing vlookups i have entry and exit timestamps and i'm doing vlookups with these timestamps to find out the # of 'point and figure' bars that occurred when i took that trade so what i was thinking was to round the entries and exits timestamp to nearest 5 min as well, and with a common rounded to nearest 5 min timestamp, i can do vlookups Date Time Of Last Edit: 2019-05-16 05:49:46
|