Import industry rank

[sandeep]

HII ALL
I am importing industry rank from .csv file
I have industry name specified in database
now I want to import weekly ranking of particular industry,
File format as below ( i am using peg ratio as industry rating )

Format definition file generated automatically

by AmiBroker's ASCII Import Wizard

$FORMAT INDUSTRYNAME,PEG_RATIO
$NOQUOTES 1
$AUTOADD 0
$OVERWRITE 1
$SEPARATOR ,
$DEBUG 1

I think it should work ,but not working , my .csv file contains only industry name and rank :

Agricultural Operations IN,160
Comml Svcs-Outsourcing IN,57
Office Supplies Mfg IN,153
Computer-Integrated Syst IN,148

debug show an error that ticker not found , I am missing something , Please help

[fxshrat]

INDUSTRYNAME and PEG_RATIO are supposed to be imported to existing symbol(s)/ticker(s).
INDUSTRYNAME is not a symbol. It is category (name) where one or more symbols are part of.
So needless to say that you can not import fundamental data to a category (except for it additionally exists as symbol (composite) with price data.)

So format file

$FORMAT TICKER,INDUSTRYNAME,PEG_RATIO
$NOQUOTES 1
$AUTOADD 0
$OVERWRITE 1
$SEPARATOR ,
$DEBUG 1

And CSV file (NOTE: multiple symbols may be part of same industry)

SymbolA,Agricultural Operations IN,160
SymbolB,Comml Svcs-Outsourcing IN,57
SymbolC,Office Supplies Mfg IN,153
SymbolD,Computer-Integrated Syst IN,148

[sandeep]

ohh... Thanx

I will try to get appropriate csv file ,assigned to symbol not industryname.