|
PureBytes Links
Trading Reference Links
|
Works OK for me.
- created new blank database to save me time (no categories assigned)
- saved a list in your format (as blakerandy.txt file)
line1
test,0,abc learning,abc,0
test,1,bcd group,bcd,1
test,2,cde company, cde,2
- saved your format in format folder (as blakerandy.format)
$FORMAT Skip,Industry,Fullname,Ticker,Market
$SEPARATOR ,
$SKIPLINES 1
$AUTOADD 1
$DEBUG 1
$Noquotes 1
- added to import.types in format folder
Default ASCII (*.*)|*.*|default.format
Yahoo's CSV (*.csv)|*.csv|yahoo.format
AmiQuote Historical (*.aqh)|*.aqh|aqh.format
AmiQuote Historical (Funds) (*.aqh)|*.aqh|aqhfunds.format
AmiQuote Daily (*.aqd)|*.aqd|aqd.format
AmiQuote Historical (Google) (*.aqg)|*.aqg|aqg.format
AmiQuote Intraday (*.aqi)|*.aqi|aqi.format
AmiQuote Historical (MSN) (*.aqm)|*.aqm|aqm.format
AmiQuote Historical (eSignal) (*.aqe)|*.aqe|aqe.format
Metastock ASCII (*.txt)|*.txt|metastock.format
Omega SC ASCII (*.txt)|*.txt|omega.format
S-Files (s*.*)|s*.*|sfile.format
C-Files (c*.*)|c*.*|cfile.format
Sharenet DN (*.dn)|*.dn|sharenet.format
PRN Format with Ticker (*.prn)|*.prn|prnn.format
PRN Format without Ticker (*.prn)|*.prn|prnn2.format
Space separated Ticker,Date,OHLC (*.txt)|*.txt|ssv.format
Space separated Date,HLCV (*.txt)|*.txt|ssv2.format
Short Daily CSV (*.csv)|*.csv|daily.format
MST Format w/Ticker (*.mst)|*.mst|mst.format
StockWatch.com format (*.csv)|*.csv|stockwatch.format
TenBagger format (*.stk)|*.stk|stk.format
SP100 (*.*)|*.*|SP100.format
blakereandy format (*.*)|*.txt|blakerandy.format
- ASCII import >> (select blakerandy.txt with filetype ==
blakerandy.format >> open
stock abc goes into market 0, bcd goes into market 1 etc
brian_z
--- In amibroker@xxxxxxxxxxxxxxx, "blakerandy" <BlakeRandy@xxx> wrote:
>
> I have created a database structure to follow the Yahoo Sector and
> Industry structure.
>
> When I create a new database the structure is set up properly.
>
> I also have a text file of stocks that includes the sector,
industry,
> company name, symbol and market for each stock I want to include in
my
> database. This file is in a comma delimited format.
>
> I created a new format file to import the data. When the import is
> done, all of the symbols are there but they are all under the first
> industry.
>
> Does anyone have an idea of what I might be doing wrong?
>
> Sector File:
> Basic Materials
> Conglomerates
> Consumer Goods
> Financial
> Healthcare
> Industrial Goods
> Services
> Technology
> Utilities
>
> Partial Industry File:
> 0 Agricultural Chemicals
> 0 Aluminum
> 0 Chemicals-Major Diversified
> 0 Copper
> 0 Gold
> 0 Independent Oil & Gas
>
>
> Format File:
> $FORMAT Skip,Industry,Fullname,Ticker,Market
> $SEPARATOR ,
> $SKIPLINES 1
> $AUTOADD 1
> $DEBUG 1
> $Noquotes 1
>
------------------------------------
**** IMPORTANT ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
*********************
TO GET TECHNICAL SUPPORT from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
*********************
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
For other support material please check also:
http://www.amibroker.com/support.html
*********************************
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/
|