PureBytes Links
Trading Reference Links
|
Steve: You could use a macro and a button, and have
it so the macro reads the symbol and adds the rest of the stuff you want. The
code in the macro for the WINROS formula would be something like:
"=WINROS|bid!'abc de' " &
Range("A3")
Range("A3") is where you'd have the symbol, for
example.
Without options, you'd have:
= "=WINROS|Open!" & Range("A3")
That would come out looking like this in the cell
formula:
=WINROS|open!IBM
You can work out how to string together what you
want in your own macro, for the options. Just string parts of the WINROS formula
together with quotes and "&"
For several columns, each with different info, you
could have:
Cells(3, 3) = <FONT face=Arial
size=2>"=WINROS|bid!'abc de' " & Range("A3")
Cells(3, 4) = "=WINROS|ask!'abc de' "
& Range("A3")
etc.
I hope this helps.
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Steve Carton
To: <A
href="mailto:realtraders@xxxxxxxxxxxxxxx"
title=realtraders@xxxxxxxxxxxxxxx>realtraders@xxxxxxxxxxxxxxx
Sent: Wednesday, March 07, 2001 4:34
PM
Subject: [RT] E Signal Problem
I am creating a spread sheet to monitor positions
and potential positions which include options and/or underlying stocks.
In order to get the up-to-date numbers, I am using eSignal data. I am
using the eSignal Winros protocol, and it works.
There is an inconvenience I would like to
overcome, however. The Winros protocol for options is:
=WINROS|type!'abc de' where type means bid, ask, or some other
parameter I want, abc is the option root, d is the month and type (e.g.
d=April Call), and e = the strike price. Some places I need the bid,
some places the ask, some places the last, some places the volume and some
places the open interest. I would like to be able to have the option
symbol in one cell, and have the Winros commands reference that cell to give
me the numbers I need without having to retype the whole option ID every time
I want to try a different option.
I have asked eSignal for help with this problem,
but they said that it can't be done. I don't believe that it can't be
done because I saw a similar thing done at an options workshop a while
back.
Can anyone tell me how to accomplish this?
I have tried I all the Excel tricks I know, but without success.
Thanks!
SteveTo
unsubscribe from this group, send an email
to:realtraders-unsubscribe@xxxxxxxxxxxxxxxYour
use of Yahoo! Groups is subject to the <A
href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of Service.
Yahoo! Groups Sponsor
To unsubscribe from this group, send an email to:
realtraders-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|