|
PureBytes Links
Trading Reference Links
|
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@xxx> 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.
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "lamplowman" <lamplowman@> wrote:
> >
> > Thankyou Yofa, that is BRILLIANT, you're a GENIUS.
> >
> > Found the plug-in and it's exactly what I am after, a bit confusing about tables in Excel, but I think I have it sorted.
> >
> > Peter
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "Yofa" <jtoth100@> wrote:
> > >
> > > You can also use ODBC data plug-in to access Excel sheets.
> > >
> >
> >
> > Thanks Mike, that is interesting.
> >
> > > > http://www.amibroker.com/guide/d_ascii.html
> > > >
> > > > Mike
> >
> >
> > > >
> > > > --- In amibroker@xxxxxxxxxxxxxxx, "lamplowman" wrote:
> > > >>
> > > >> A hopefully simple question.
> > > >>
> > > >> Can AmiBroker import data from Excel
> > > >>
> > > >> Peter
> >
>
------------------------------------
**** 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/
|