Basic fundas of all cos in 1 excel sheet

[kenneth]

Thank you tanewbie. But did not succeed to import fv
Columns on fv are Company Name Face Value
Could you please let me know the column format for import wizard

Thnaks& Regards
ken

 

[kenneth]

Thank you very much tanewbie. At last succeeded to import FV. Learnt a lot of small but important things in the process. The fv column still needs to be corrected from facevalue to RETURN_ON_ASSETS.

Regards
ken

 

[rmike]

Dear Vish

Thanks for your file.

Unfortunately the Fundamental data that can be specified in Amibroker are as follows

DIV_PAY_DATE
EX_DIV_DATE
LAST_SPLIT_DATE
LAST_SPLIT_RATIO
EPS
EPS_EST_CUR_YEAR
EPS_EST_NEXT_YEAR
EPS_EST_NEXT_QTR
FORWARD_EPS
PEG_RATIO
BOOK_VALUE (requires SHARES_OUT to be specified as well)
BOOK_VALUE_PER_SHARE
EBITDA
PRICE_TO_SALES (requires CLOSE to be specified as well)
PRICE_TO_EARNINGS (requires CLOSE to be specified as well)
PRICE_TO_BV (requires CLOSE to be specified as well)
FORWARD_PE (requires CLOSE to be specified as well)
REVENUE
SHARES_SHORT
DIVIDEND
ONE_YEAR_TARGET
MARKET_CAP
SHARES_FLOAT
SHARES_OUT
PROFIT_MARGIN
OPERATING_MARGIN
RETURN_ON_ASSETS
RETURN_ON_EQUITY
QTRLY_REVENUE_GROWTH
GROSS_PROFIT
QTRLY_EARNINGS_GROWTH
INSIDER_HOLD_PERCENT
INSTIT_HOLD_PERCENT
SHARES_SHORT_PREV
FORWARD_DIV
OPERATING_CASH_FLOW
FREE_CASH_FLOW
BETA


Will it be possible to provide similar data, some if not all.

Also please elaborate on CPS and NP(presume Netprofit) in your file

Thanks

Regards

Dear tanewbie,

Will it be possible to reorganize your data (probably will also depend upon your source) to include the standardized information/format as very nicely posted by Karthik. Due to limitation of only 12 field values of ami, there would be requirement of two format files - funda 1 and funda 2 and also the requirement of two csv data sheets to match the formats. This is not to detract from your superb effort but to lay down a universal standard uoload of funda data in consonance with ami structure. Do give it a shot, if and when you can. Would be greatly appreciated.

Regards,

 

[tanewbie]

HI ALL

here is fundas updated as of 1st Aug 2008.

Btw, i feel there is no limitation of 12 fields.

As I dont get data for other fields, I hv just included what Iget from the net.

NOw please amend the funda format file:


# 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

The field marked in red is the change in funda format

 

[tanewbie]

The abv file includes fundas of 1098 companies fr the qtr ended 30June 08 as compared to 808 companies in the previous file.

Finance and Inv companies are not included as I dont get data of those companies.

Now next update onlly on 16 Aug

 

[xtalk]

Hi tanewbie,

What's the source of this funda-data? Can you send me URLs? I have develop a free NSE EOD downloader (also available here [TOOLS & RESOURCES > Data Feeds > End of Day> MetaStock NSE Data downloader with VIX]) and now I want to integrate Funda-data along with daily EOD. I guess funda data comes on a qtrly basis.

So, all members will get funda & EOD data in one XL sheet with all favorite stocks and there will be some value buying signals. Please let me know if you can provide the data source otherwise I'll have to find out from other sources.

Thanks.
-xtalk

 

[kenneth]

Thanks tanewbie for the new file and format.Updated my database.

Regards
ken

 

[chintan786]

I have tried everything but still not get suceeded ... if some one tell how to get this in Ami...in step by step manner than i am very thank ful to him.

Right now i am creating file name Funda in Notepad and save it in Format folder then going to file>> Import ASCII and select NSEFUNDA upload by tanewbie....but nothing happened so far..... and yes i copy pasted all required things in FUNDA file ....... i don't know exactly how to create format file in Ami... is there any option there......

warm regards,

Chintan

 

[kenneth]

Tanewbie has explained detail from post 86. Please follow the steps. You will succeed.

After you create the Fanda format file goto File>import ASCII>Select fanda format file and then click on NSEFANDA file

Regards
ken

 

[chintan786]

Tanewbie has explained detail from post 86. Please follow the steps. You will succeed.

After you create the Fanda format file goto File>import ASCII>Select fanda format file and then click on NSEFANDA file

Regards
ken

Thanks for taking pain... but thts the thing i am not getting...... i have saved the Funda file in format folder .. now going to File>> IMPORT ASCII>> Funda... then how can i click on NSEFUNDA...... i mean if i need to import NSE FUNDA CSV file through import wizard then it shows error..because .. then i don't know which columns i need to select.......

chintan