Basic fundas of all cos in 1 excel sheet

[chintan786]

and File type was funda format..

 

[kenneth]

Say yes to view errors and what is the errror. I think I got only 4 for the companies which were not on my database

regards
ken

 

[tanewbie]

download excel file for all companies
from:

xrl dot us/om98u

 

[chintan786]

Say yes to view errors and what is the errror. I think I got only 4 for the companies which were not on my database

regards
ken

Here is the log file..

Logging started for 'C:\Documents and Settings\vikas\Desktop\nsefundabhav080808\nsefundabhav080808.csv' file, using format definition file 'Formats\FUNDA.format'
Error in line ,Company Name,Latest Quarter,Bse Ticker Code,Full Year,Full Year,Full Year,Full Year,Full Year,Trailing Twelve Months,Trailing Twelve Months,Latest Quarter,Face Value,,,,
Invalid (close) price. Prices must be positive. If you want to import no quotation data please specify $NOQUOTES 1 ('no quotation data' box in Wizard)
Invalid date format/value
Ticker symbol is empty (unknown)
Error in line ,,,,,,,,,,,,,,,,
Invalid (close) price. Prices must be positive. If you want to import no quotation data please specify $NOQUOTES 1 ('no quotation data' box in Wizard)
Invalid date format/value
Ticker symbol is empty (unknown)
Error in line ,,Year,,Equity Rs.Cr.,B.V. Rs.,Div%,CPS,EPS Rs.,OPM,EPS,NP,,,,,
Invalid (close) price. Prices must be positive. If you want to import no quotation data please specify $NOQUOTES 1 ('no quotation data' box in Wizard)
Invalid date format/value
Ticker symbol is empty (unknown)
Error in line ,,End,,,,,Rs.,,,,Var %,,,,,
Invalid (close) price. Prices must be positive. If you want to import no quotation data please specify $NOQUOTES 1 ('no quotation data' box in Wizard)
Invalid date format/value
Ticker symbol is empty (unknown)
Error in line ABB,A B B,200806,500002,42.38,76.1,110,24.4,22.8,12.65,25.68,20,2,,ABB,500002,0
Invalid date format/value

 

[chintan786]

download excel file for all companies
from:

xrl dot us/om98u

thanks.. i have downloaded this file.. now it is neither showing errors nor showing values.... i have ur AFL for funda..... nothing appear in tht.

except few stars..

chintan786

 

[chintan786]

Although it strt showing 52 week high and 52 low.. but thts it only..

 

[tanewbie]

hi Chintan

post the contents of yiour funda format file.

 

[chintan786]

Here it is Sir....

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard

$FORMAT Ticker, FULLNAME, SHARES_SHORT, ALIAS, SHARES_OUT, BOOK_VALUE_PER_SHARE, DIVIDEND, FREE_CASH_FLOW, EPS, OPERATING_MARGIN, EPS_EST_CUR_YEAR,QTRLY_EARNINGS_GROWTH,RETURN_ON_ASSETS

$SKIPLINES 5
$SEPARATOR ,
$CONT 1
$GROUP 255
$DEBUG 1
$NOQUOTES 1
$ALLOWNEG 1

 

[tanewbie]

your format file is right


now go to file.import ascii

select the nse fundabhav0808

the window of import ascii shd look like below:



file= nsefundabhav0808.csv
files of type= funda


dont chk out open as read only box

now click open

it shd work

 

[kenneth]

Thanks tanewbie for the new file. File is 1669 kb compared to previous 104Kb. Could you please tell how best we can use this data.

Mike has also uploaded clean data files for 5 years data. I don't know if he has the Industry sectors etc.

Regards
Ken