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

[amibroker] Re: AB and Excel



PureBytes Links

Trading Reference Links

So are you telling me, I can get data from Excel into AB via the ODBC plug-in but AB wont keep it in its own database.


I am trying to get streaming data supplied from WebIress into AB

They have a Web Market Data Add-In for Excel (Streaming)(which works great) code in Excel
 =RTDWebiress("QUOTE","BHP", ".C.UD.O.H.Lw.L.Vo.OI.bP.aP.UT")
and I thought I could use it to update AB, I guess not.

Anyone got any idea if we could get the Web Market Data Add-In for Excel to input data directly to AB.


--- In amibroker@xxxxxxxxxxxxxxx, "jtoth100" <jtoth100@xxx> wrote:
>
> Hi,
> 
> I use ODBC data plug-in. I have an SQL database with all historical data. It work fine. I you want to update the last bar only, then you should look for other solutions. There is an other ODBC plug-in, which can be accessed from AFL script and can access any kind of data. Try that, or just write some VBScript to import data to AB.
> If you use Excel, you can save data to csv file. That can be loaded to AB directly. It can be automated by script using AB and Excel automation interfaces.
> 
> Regards,
> 
> Y
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "lamplowman" <lamplowman@> wrote:
> >
> > OK, I appear to have AB importing live data directly from Excel using the ODBC data plug-in
> > 
> > I am using it (AmiBroker 5.00.1 Standard Edition) in EOD mode and hoping to get the chart updated live during the day.
> > 
> > Years ago when using QuoteTracker it worked exactly as I wanted.
> > 
> > Using a new database it does not seem to save any historical data
> > 
> > Using an existing database it deletes all historical information and only has current data as viewable in Quote Editor
> > 
> > I don't actually have a chart yet because there is only 1 bar, I thought it would have saved yesterdays bar but it did not.
> > 
> > Is anyone using the ODBC data plug-in and successfully keeping historical data.
> > 



------------------------------------

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Yahoo! Groups Links

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

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> 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/