|
Title: Fwd: Re: [amibroker] Re: ODBC database interface works great!
Sorry, I misread the thread ;-(
herman
This is a forwarded message
From: Herman <psytek@xxxxxxxx>
To: "murthysuresh" <money@xxxxxxxxxxxxxx>
Date: Sunday, February 22, 2009, 3:25:57 PM
Subject: [amibroker] Re: ODBC database interface works great!
===8<==============Original message text===============
I think that Murthy may have just posted the code you need on the UKB:
http://www.amibroker.org/userkb/2009/02/21/plotting-trades-on-chart/
good luck,
herman
Sunday, February 22, 2009, 1:47:33 PM, you wrote:
> that is one area i have always felt challenged.
> for eg. i store all my trades in a mysql
> database. i have always
> wanted to plot the realtime trades. how would you do the following.
> here is the sql that will return my trade info. but running it thro
> ab is something of a challenge for me
> select symbol, tradedatetime, action,price from rawdatas where
> symbol='FLWS'
> this geneates a list of rows. but how do i get it thro amibroker. any
> assistance is highly apprecited.
> if, i can get it to work properly. i will post it in UKB
> --- In amibroker@xxxxxxxxxxxxxxx, "dloyer123" <dloyer123@xxx> wrote:
>> I just had a good experience using the odbc database driver with
>> amibroker.
>> I built a tick database, about 75GB worth. From that, I can
> calculate
>> volume at price, vwap and other data. I use postgress, a free open
>> source database.
>> I thought that I would have to write my own trade match and
> backtest
>> code in sql, but then I found the odbc sql interface to pull the
> data
>> into amibroker.
>> I was plesantly surprised how fast the odbc/amibroker interface
> was.
>> Working with tick data is never fast, but each sql query from ami
> was
>> only a handful of ms.
>> -Doug
> ------------------------------------
> **** 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/
===8<===========End of original message text===========
__._,_.___
**** 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/
![]()
__,_._,___
--- Begin Message ---
- To: "murthysuresh" <money@xxxxxxxxxxxxxx>
- Subject: Re: [amibroker] Re: ODBC database interface works great!
- From: Herman <psytek@xxxxxxxx>
- Date: Sun, 22 Feb 2009 15:25:57 -0500
- Delivery-date: Sun, 22 Feb 2009 15:26:02 -0500
- Envelope-to: psytek@xxxxxxxx
Title: Re: [amibroker] Re: ODBC database interface works great!
I think that Murthy may have just posted the code you need on the UKB:
http://www.amibroker.org/userkb/2009/02/21/plotting-trades-on-chart/
good luck,
herman
Sunday, February 22, 2009, 1:47:33 PM, you wrote:
> that is one area i have always felt challenged.
> for eg. i store all my trades in a mysql
> database. i have always
> wanted to plot the realtime trades. how would you do the following.
> here is the sql that will return my trade info. but running it thro
> ab is something of a challenge for me
> select symbol, tradedatetime, action,price from rawdatas where
> symbol='FLWS'
> this geneates a list of rows. but how do i get it thro amibroker. any
> assistance is highly apprecited.
> if, i can get it to work properly. i will post it in UKB
> --- In amibroker@xxxxxxxxxxxxxxx, "dloyer123" <dloyer123@xxx> wrote:
>> I just had a good experience using the odbc database driver with
>> amibroker.
>> I built a tick database, about 75GB worth. From that, I can
> calculate
>> volume at price, vwap and other data. I use postgress, a free open
>> source database.
>> I thought that I would have to write my own trade match and
> backtest
>> code in sql, but then I found the odbc sql interface to pull the
> data
>> into amibroker.
>> I was plesantly surprised how fast the odbc/amibroker interface
> was.
>> Working with tick data is never fast, but each sql query from ami
> was
>> only a handful of ms.
>> -Doug
> ------------------------------------
> **** 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/
--- End Message ---
|