[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [RT] E Signal Problem



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.