Use the LinkedCell property (NT)
I don't really trade many stocks. Just futures.
I'm still not getting the cells to retain highs and lows in the time period.
I trade a spread between the mini ES (s&p) futures contract and the mini NQ (nasdaq). Depending on contract volatility I adjust the ratio for which I buy and sell. That spread value is generated by a dollar value, which I derive from the number of contracts traded times the dollar amount of each contract. Because this is not your normal "spread", standard charting packages will only display this value as a "line on close". What I need is the Open (easily attainable) High, Low (those are the two that present me with a problem) and the Close (again easy).
What I would like to do is this:
1.Take the last trade data of each of the contracts and apply my ratio formula, currently that formula is (value of the ES contract *150)-(value of the NQ contract*40) that formula gives me the "spread value".
I would like to generate candlestick bars, in several time frames, that would show me the open, high, low and close of that value. Ideally this would happen on a separate worksheet.
So the High and Low values need to change as the "last value" increases or decreases above or below the high or low value already there. Then I would like the next bar to start at the prescribed time interval, e.g. 15 min, 30 min, or 60 min.
If you can help me, I would gladly pay you some sort of fee. I am just starting out, so go easy on me.
I left you my phone # on the email I sent you, feel free to call if you require further information.
Thanks
Max
Yes, it does. The property is called LinkedCell, it's a string, in the form of "Sheet1!B1".
Juan Pablo G.