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@xxxxxxxxxps.com, "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.
>
>
> --- In amibroker@xxxxxxxxxps.com, "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@xxxxxxxxxps.com, "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@xxxxxxxxxps.com, "lamplowman"
wrote:
> > > >>
> > > >> A hopefully simple
question.
> > > >>
> > > >> Can AmiBroker
import data from Excel
> > > >>
> > > >>
Peter
> >
>