|
PureBytes Links
Trading Reference Links
|
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 amibroker@xxxxxxxxxxxxxxx, "bhanu upadhyay" <upadhyay.bhanu@xxx> wrote:
>
> Please refer to previous thread in Digest no. 8524
> 3a. Re: AB and Excel
> Posted by: "jtoth100" jtoth100@xxx 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 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.
> >
> >
> > --- 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
> > >
> >
>
>
> 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.bhanu@xxx 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" lamplowman@xxx 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 amibroker@xxxxxxxxxxxxxxx, "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 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.
> > >
>
>
> Back to top Reply to sender | Reply to group | Reply via web post
> Messages in this topic (8)
>
------------------------------------
**** 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/
|