MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by jim on January 22, 2002 12:59 PM

Hello people,

I have created a userfom with 9 textboxes. I'm trying
to link the textboxes to certain cells on the page.
i.e. when you type the info in textbox 1 the info is
copied and pasted in cell B1, textbox 2 copied and pasted
in B2, etc.
Any help and or advice would be appreciated

Posted by Juan Pablo G. on January 22, 2002 1:19 PM

Use the LinkedCell property (NT)

Posted by jim on January 22, 2002 1:27 PM

Posted by Juan Pablo G. on January 22, 2002 1:30 PM

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.



Posted by Juan Pablo G. on January 22, 2002 1:32 PM

Yes, it does. The property is called LinkedCell, it's a string, in the form of "Sheet1!B1".

Juan Pablo G.