|
PureBytes Links
Trading Reference Links
|
Hi Don,
1) You can use the following exploration followed by an export of the
results, just add whatever other fields/details you require to the column list.
Filter = 1;
SetOption("NoDefaultColumns", True );
AddTextColumn( Name(), "<Ticker>" );
AddTextColumn( FullName(), "<Name>" );
AddTextColumn( NoteGet(""), "<Note>" );
Also checkout help file under "Import ASCII" and "Import Wizard" for
details of field names.
2) Open new database and use the import wizard to perform a
"No Quotes" import from the csv file exported in step 1.
**(You will NOT be able to import the notes in this step)
Add the following settings to the import wizard:
Column 1 = Ticker
Column 2 = Fullname
Column 3 = Skip
Column 4 = Skip
etc
etc
Skip first: 4 lines
No quotation data: Tick
Then leave all remaining options at default settings and select next. At this
stage you should have all the data imported except the notes.
3) Notes - you will need to write some AFL or script to import the
notes data field. Check out the following AFL function fgets() fopen()
If this part of the procedure is totally foreign to you and you feel
completely lost then let me know and I'll write/send you a small script.
Maybe someone else has already written a script to import notes, but try it
first.
Regards,
William Peters (AmiBroker Group Moderator)
www.amitools.com
Friday, February 4, 2005, 11:45:12 PM, you wrote:
d> I apologize if this has been addressed, but I can't find any info on
d> merging separate EOD (Yahoo) databases. Today I combined 3 different
d> symbol lists into 1 by copying (.tls) files into Wordpad -- but all
d> the symbol info (text names, etc.) and notes are lost; you start from
d> scratch again.
d> Is there a way to merge similar databases? If not, it would rank as
d> one of my top "Feature requests."
d> Thanks, Don
------------------------ Yahoo! Groups Sponsor --------------------~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~->
Check AmiBroker web page at:
http://www.amibroker.com/
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/
|