Dear Bhanu and other friends I tried by downloading ODBC.dll and ODBCA.dl. Put these in the Plugin Folder. Created a new database. Opened the "database Configuration". Got the screen as described in the UKB. I have been able to make a connection between the Excel file and the driver etc but when I load the database in the configuration box, I do no get the table and the fields. Am I missing something?
Regards Vinay --- In [email protected], "bhanu upadhyay" <upadhyay.bh...@...> wrote: > > Please refer to previous thread in Digest no. 8524 > 3a. Re: AB and Excel > Posted by: "jtoth100" jtoth...@... jtoth100 > Wed Mar 4, 2009 11:10 pm (PST) > 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" <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 [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 > > > > > > > > Back to top Reply to sender | Reply to group | Reply via web post > Messages in this topic (8) > 3b. Re: AB and Excel > Posted by: "bhanu upadhyay" upadhyay.bh...@... bhanupu > Thu Mar 5, 2009 1:33 am (PST) > Yes it can import data from excel which should be saved as .csv and > thereafter import through File<Import wizard. > > bhanu > Back to top Reply to sender | Reply to group | Reply via web post > Messages in this topic (8) > 3c. Re: AB and Excel > Posted by: "lamplowman" lamplow...@... lamplowman > Thu Mar 5, 2009 2:35 am (PST) > 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 [email protected], "jtoth100" <jtoth100@> 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 [email protected], "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. > > > > > > Back to top Reply to sender | Reply to group | Reply via web post > Messages in this topic (8) >
