Basic fundas of all cos in 1 excel sheet

[tanewbie]

download report from:

tinyurl dot com/6y7foy

 

[asterix24]

Thanks ...

 

[jayzarna]

Hi Ken

u r right . data for companies of Finan ce and investment companies and some other companies are not available easiily.

The data for this group of companies I gather from the net once in 2 months.
Here is the latest bahv copy for those companies.
The Format is slightly diffferent use the following format:

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Fullname, RETURN_ON_ASSETS, SHARES_SHORT, SHARES_OUT, ALIAS, BOOK_VALUE_PER_SHARE, DIVIDEND, FREE_CASH_FLOW, EPS, EPS_EST_CUR_YEAR,QTRLY_EARNINGS_GROWTH
$SKIPLINES 5
$SEPARATOR ,
$CONT 1
$GROUP 255
$DEBUG 1
$NOQUOTES 1
$ALLOWNEG 1

HI Tanewbie,

I guess I must use the latest file that you are uploading instead of loading the old files too as these are dynamic details which change.

So the latest nsefundabhav140808 should suffice? Am I right to assume this?

Thanks for the details as always.

regards Jay

 

[jayzarna]

Hi TANewbie,

One more question. How does one use your afl for the charts. I am a little hazy about it and taking a short cut by asking you. Thanks

Jay

 

[ragsid]

Hi Tanewbie,

Hats off. Thanks a lot. It worked smoothly.

Cheers

 

[tanewbie]

margins and lots can be imported
use the following format

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, RoundLotSize, MarginDeposit, Skip, Skip

$SKIPLINES 3
$SEPARATOR ,
$CONT 1
$GROUP 255
$DEBUG 1
$NOQUOTES 1
$ALLOWNEG 1
$OVERWRITE 1

 

[chintan786]

Hi tanewbie.. is i need to create new funda format for this... or the old one can serve the purpose... when i used it is showing almost 275 errors.... the error is of same kind for all the symbols...

here it is...

Error in line $CNXIT-NSE,50,23135.025,,,,,CNXIT,50,23135.025
'$CNXIT-NSE' - this ticker symbol does not exist in the database
Error in line $NIFTYJR-NSE,25,26710.5625,,,,,JUNIOR,25,26710.5625
'$NIFTYJR-NSE' - this ticker symbol does not exist in the database
Error in line MINIFTY Q8-NSF,20,10693.31,,,,,MINIFTY,20,10693.31
'MINIFTY Q8-NSF' - this ticker symbol does not exist in the database
Error in line $NIFTY-NSE,50,26783.775,,,,,NIFTY,50,26783.775
'$NIFTY-NSE' - this ticker symbol does not exist in the database
Error in line 3IINFOTECH.EQ-NSE,2700,55197.045,,,,,3IINFOTECH,2700,55197.045
'3IINFOTECH.EQ-NSE' - this ticker symbol does not exist in the database
Error in line ABAN.EQ-NSE,50,23933.5375,,,,,ABAN,50,23933.5375
'ABAN.EQ-NSE' - this ticker symbol does not exist in the database
Error in line ABB.EQ-NSE,250,46234.375,,,,,ABB,250,46234.375
'ABB.EQ-NSE' - this ticker symbol does not exist in the database
Error in line ABGSHIP.EQ-NSE,550,77123.10375,,,,,ABGSHIP,550,77123.10375
'ABGSHIP.EQ-NSE' - this ticker symbol does not exist in the database
Error in line ABIRLANUVO.EQ-NSE,200,52586.5,,,,,ABIRLANUVO,200,52586.5
'ABIRLANUVO.EQ-NSE' - this ticker symbol does not exist in the database
Error in line ACC.EQ-NSE,188,21475.71,,,,,ACC,188,21475.71
'ACC.EQ-NSE' - this ticker symbol does not exist in the database
Error in line ADLABSFILM.EQ-NSE,225,33989.97375,,,,,ADLABSFILM,225,33989.97375
'ADLABSFILM.EQ-NSE' - this ticker symbol does not exist in the database
Error in line AIAENG.EQ-NSE,200,84257.5,,,,,AIAENG,200,84257.5
'AIAENG.EQ-NSE' - this ticker symbol does not exist in the database
Error in line AIRDECCAN.EQ-NSE,850,23786.8335,,,,,AIRDECCAN,850,23786.8335
'AIRDECCAN.EQ-NSE' - this ticker symbol does not exist in the database
Error in line AKRUTI.EQ-NSE,300,74355.1335,,,,,AKRUTI,300,74355.1335
'AKRUTI.EQ-NSE' - this ticker symbol does not exist in the database
Error in line ALBK.EQ-NSE,2450,29099.875,,,,,ALBK,2450,29099.875
'ALBK.EQ-NSE' - this ticker symbol does not exist in the database
Error in line ALOKTEXT.EQ-NSE,3350,32356.176,,,,,ALOKTEXT,3350,32356.176
'ALOKTEXT.EQ-NSE' - this ticker symbol does not exist in the database

warm regards,

chintan786

 

[tanewbie]

oh sorry I used esignal symbols
here is the revised csv for import


use the following format

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, RoundLotSize, MarginDeposit, Skip, Skip

$SKIPLINES 3
$SEPARATOR ,
$CONT 1
$GROUP 255
$DEBUG 1
$NOQUOTES 1
$ALLOWNEG 1
$OVERWRITE 1

 

[chintan786]

thanks Tanewbie... now it is fine...thanks a ton

 

[kenneth]

Thanks Tanewbie.

Any shortcuts
1. to import F&O watchlist or create one.
2.Create a list
VarSet("ABAN",50);
VarSet("ABB",250);
VarSet("ABIRLANUVO",200);
VarSet("ACC",188);
VarSet("ADLABSFILM",225

VarSet("ABANI",16);
VarSet("ABBI",16);
VarSet("ABIRLANUVOI",16);
VarSet("ACCI",15);
VarSet("ADLABSFILMI",17);

Regads
Ken