|
PureBytes Links
Trading Reference Links
|
William,
What you've written is absolutly correct. Once done, it will not be
labor (key-stroke) intensive operation.
However, I was keen on avoiding large replication of data 255 * 2
tickers - for each data going back 4+ years. It will be in 'MASTER'
format, and then in ASCII format, and then in AmiBroker format.
Wanted to avoid this if possible. Currently I have 2 'MASTER' files,
it is likely that in future there will be more. Creation of each
export files and subsequent import of each will be time consuming as
well.
So got to decide about what will work better for me. Key-strokes to
import 2 'MASTER' or OLE automation to do 3 loaddatabase, 2 exports
and then 1 import. Hmmm ...
As I wrote before, wanted to know if there are some suggestions to
import without first having to convert to ASCII and then importing.
But if this is one of the reasonable ways, then I'll follow it. I'll
delete the intermediate ASCII files after AmiBroker import is over,
to free-up a part of replicated data.
Regards,
- Salil V Gangal
--- In amibroker@xxxxxxxxxxxxxxx, William Peters <williampeters@xxxx>
wrote:
> Salil,
>
> ALL the steps are carried out VIA SCRIPT using OLE Automation.
> Step 3 is just a line of code, creating an ascii file with quotes
> is coded, everything is coded, nothing labour intensive about
> it once you've written the script.
> Once the code is written the only job you have to do each day is
> execute it, this could be automated.
> Perhaps once you have initially imported all the files only a daily
update
> containing the last quotation/s is necessary, so you use the
quotations
> collection and its methods then save the last quote for each ticker
to ascii.
> From there use the Import method to import into your main database.
>
> As mentioned initially you will need to create a second AmiBroker
> database with a link to the Metastock database using the MS plugin.
>
>
> Best regards,
> William Peters
> www.amitools.com
>
>
> Friday, May 21, 2004, 11:51:49 AM, you wrote:
>
> SVG> William,
>
> SVG> I had thought of these linnes and was not too keen on using
this
> SVG> approach. As wrote before (>>I don't want to first
covert 'MASTER'
> SVG> into individual ASCII files and then import, but rather want
to
> SVG> import the two files straight into AmiBroker using OLE
> SVG> Automation<<) ... So in fact I wanted to avoid the step# 3
you've
> SVG> suggested below.
>
> >>>> 2) Exports quote data from the two tickers to ascii.<<
>
> SVG> Actually it's not only two ticker, but two 'MASTER' data files
each
> SVG> having 255 tickers included in MetaStock format.
>
> SVG> Thanks for the suggestion anyways. I'll explore it.
>
> SVG> Regards,
> SVG> - Salil V Gangal
>
>
>
> SVG> --- In amibroker@xxxxxxxxxxxxxxx, William Peters
<williampeters@xxxx>
> SVG> wrote:
> >> Salil,
> >>
> >> Actually I think you could automate the import from the Metastock
> >> files as follows.
> >>
> >> Create a 'new' database using the MS Plugin.
> >>
> >> Write OLE automation script which performs the following:
> >> 1) Opens the the new AmiBroker Metastock database.
> >> 2) Exports quote data from the two tickers to ascii.
> >> 3) Switch back to your main database.
> >> 4) Import the quote data into your main database.
> >>
> >> Its not that many lines of code and could be run from the Tools
menu
> >> or from a scheduling tool daily.
> >>
> >> Regards,
> >> William Peters
> >> www.amitools.com
> >>
> >>
> >> Friday, May 21, 2004, 10:31:53 AM, you wrote:
> >>
> >> SVG> Tomasz,
> >>
> >> SVG> My impression is that the 'database setting' permits
setting
> SVG> only one
> >> SVG> plugin as 'data source'. What if I have that one already
used
> SVG> up
> >> SVG> (as 'FastTrack' or 'QP2' or 'TC2000') ? Then is there a way
to
> SVG> use
> >> SVG> two *more* data sources as MetaStock format, pointing
> SVG> to 'Master'
> >> SVG> data file in MetaStock format residing in C:\FOLDER1 and
> SVG> C:\FOLDER2 ?
> >>
> >> SVG> Regards,
> >> SVG> - Salil V Gangal
>
>
>
>
> SVG> Send BUG REPORTS to bugs@xxxx
> SVG> Send SUGGESTIONS to suggest@xxxx
> SVG> -----------------------------------------
> SVG> Post AmiQuote-related messages ONLY to:
amiquote@xxxxxxxxxxxxxxx
> SVG> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> SVG> --------------------------------------------
> SVG> Check group FAQ at:
> SVG> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> SVG> Yahoo! Groups Links
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> 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/
|