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

[amibroker] Re: Anyone interested in RT bid/ask charts?



PureBytes Links

Trading Reference Links


Scott, I use the IB feed but it should work with any feed you can DDE-
link to.

- DDE-link an excel worksheet to the datasource.
- Name the cell containing the MSFT bid "MSFT_bid" (using the NAME 
box next to the formula bar)
- Same for MSFT_ask and MSFT_last and MSFT_asksize etc. whichever you 
want and is available.
- Create AB database with Universal DDE plugin configured with 
server "excel" and use only the Last field with "Sheetname!{ticker}"
- In AB create tickers MSFT_bid, MSFT_ask, MSFT_last etc. These are 
now separate tickers with their own charts, even candlesticks if you 
prefer (MSFT_last is in fact your regular price data).

It's a hassle to manually name many cells so you'd probably want some 
macro to automate this. Also this setup uses two DDE links so it may 
not be the fastest, I just don't know but it works for me.

Any suggestions for improvement will be gratefully received.

If anything isn't clear just ask.

-treliff

--- In amibroker@xxxxxxxxxxxxxxx, Scott <scong@xxxx> wrote:
> treliff,
> 
> I am interested. Thanks in advance.
> 
> Cheers,
> Scott
> 
> treliff wrote:
> 
> >Thanks to Tomasz's prompt service in increasing the Universal DDE 
> >plugin # symbols to 500 I found a way to plot RT bid/ask charts.
> >
> >Just in case you're interested and haven't figured this out yet 
I'd 
> >be happy to share. (And of course, have you developed this already 
> >I'd be happy to hear, perhaps it's more efficient than my way :-)
> >
> >-treliff
> >
> >  
> >





------------------------ Yahoo! Groups Sponsor --------------------~--> 
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/