Support Board
Date/Time: Thu, 06 Feb 2025 20:43:46 +0000
Post From: Spradshet Formula Study
| [2020-05-07 03:25:53] |
| CMG - Posts: 179 |
|
Tom, As always thanks for your help. I think that I didn't post my question correctly. I was not trying to get the Last Price at 9:45:00 (when the time was 9:45:00), but what I meant is that I wanted to "retrieve the value" of "the last" printed at 9:45:00 at any time after 9:45:00. I need the value of the last at 9:45:00, as a constant, to use it in a calculation to see the price difference at any time after 9:45:00, with the then current last price. E.g. AT 11:00:00, I will like to know the difference between the current last (last at 11:00:00) and the last price at the 9:45:00 bar. And the same for another study in the chart, which I suppose is the formula for the above but for ID1.SG1 Couldn't find an explanation or example for this within the documentation. Do you think this is possible with spreadsheet formulas? Thanks again |