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 [email protected], "lamplowman" <lamplow...@...> 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 [email protected], "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 [email protected], "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 [email protected], "lamplowman" wrote: > > > >> > > > >> A hopefully simple question. > > > >> > > > >> Can AmiBroker import data from Excel > > > >> > > > >> Peter > > >
