|
|
| Discuss Basic fundas of all cos in 1 excel sheet at the Fundamental Analysis within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Mike For uplaoding Fundamental dats into Amibroker we need to make a format file. This ... |
|
|||||||
| Notices |
| Fundamental Analysis Discuss all about fundamental analysis and valuation. The world of PEs, free cash flow, ratio analysis, multiples and accounting numbers. |
 |
|
|
Thread Tools |
| Sponsored Links |
|
#81
3rd August 2008, 11:14 PM
|
|||
|
|||
Re: Basic fundas of all cos in 1 excel sheet
Mike
For uplaoding Fundamental dats into Amibroker we need to make a format file. This file would specify the data to be uploaded and the file type. Next step is to add this file details in the format types file which resides in the format folder so that amibroker can recognize our custom format file. This is the easy part. The difficult part is to get the data which is accepted by Amibroker. Unfortunately the data are not user definable. I have already created the required format files and tested with TAnewbee's excel file. But his file does not have all the data as per Amibroker. Enclsoing a screenshot of some of the data uploaded as a test. 
Last edited by karthikmarar; 4th August 2008 at 01:04 AM. 
|
| Sponsored Links |
|
#82
3rd August 2008, 11:18 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
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
|
|
#83
4th August 2008, 08:27 AM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
Dear Karthik
Steps to import fundas: Create any format file but save the settings as Funda format. now open funda format file thro notepad and replace all of its contents with # 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 $SKIPLINES 5 $SEPARATOR , $CONT 1 $GROUP 255 $DEBUG 1 $NOQUOTES 1 $ALLOWNEG 1 and save and exit the funda format file. Now go to ami to ile/import ascii and select the nse funda file and the funda format and import. Thats all to do to import. Now I am attaching a afl which will display alll fundas int he chart See attached afl and a sample chart of RIL with fundas Last edited by tanewbie; 6th September 2008 at 10:48 PM.
|
| The Following 5 Users Say Thank You to tanewbie For This Useful Post: | ||
adesara (13th September 2008), chintan786 (7th August 2008), karthikmarar (4th August 2008), kenneth (7th August 2008), rmike (4th August 2008) | ||
|
#85
7th August 2008, 06:39 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
Dear tanewbie,
I have created the Funda format file in the Format folder. When I File>import ASCII>nsecfandabhavo010808> Fanda format is not available in Files of type. Could you please advise what need to do. Thanks & Regards ken
|
|
#86
7th August 2008, 08:28 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
hi Ken
when u create a format file, th import ascii picks the last used format file or last created format fie automatically. You may hv made a mistake while saving the settings. Steps again: File/importwizard and select any bhav copy and select the right columns as per the bhav copy and proceed. when u come to saving th settings tick (or check) add current settings to ASCII importer definitions description: funda format file name: funda.format do these steps and exit by clicking finish then open the just created funda format file thro notepad and replace the contents of it with what I hv mentioned earlier and save it. Now u r ready to import the fundas with this format file. cheers
|
| The Following User Says Thank You to tanewbie For This Useful Post: | ||
prabu_rsr (16th August 2008) | ||
|
#87
7th August 2008, 10:15 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
Dear Tanewbie
Struggled to create Import wizard format.The bhav copy gives the following coloums. SYMBOL SERIES OPEN HIGH LOW CLOSE LAST PREVCLOSE TOTTRDQTY TOTTRDVAL TIMESTAMP 3IINFOTECH EQ 114.5 119.9 111 115.95 116.6 113.85 730784 85594554.15 7-Aug-08 unable to create. Could you please give the coloum names to pick. Thanks & Regards ken Last edited by kenneth; 7th August 2008 at 10:29 PM.
|
|
#88
7th August 2008, 11:00 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
select the columns as it appears in the bhav copy.
actually there is a preview of the copy at the bottom. SYMBOL SERIES OPEN HIGH LOW CLOSE LAST PREVCLOSE TOTTRDQTY TOTTRDVAL TIMESTAMP will be TICKER, SKIP,O,H,L,C,SKIP,SKIP,VOL,SKIP,DATE(D/M/YY)
|
|
#89
8th August 2008, 12:43 AM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
Thank you very much Tanewbie. I have attached chart of Reliance. Face value and marketcap are not seen .What could be the reason.
Thanks & Regards ken Last edited by kenneth; 15th August 2008 at 02:46 PM.
|
|
#90
8th August 2008, 07:51 AM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
u r right Ken
The funda bhav copy though face value but the format file did not hv the field to import it as for some reason it does not import more than 12 fields. Now create another format file and save it as fundaFV and opn it thro notepad and replace all of its contents with # Format definition file generated automatically # by AmiBroker's ASCII Import Wizard $FORMAT Ticker, Fullname, RETURN_ON_ASSETS, Skip, Skip, Skip, Skip $SKIPLINES 5 $SEPARATOR , $CONT 1 $GROUP 255 $DEBUG 1 $NOQUOTES 1 $ALLOWNEG 1 and use the attached fv csv NB:Right now v r using Return on assets field for storing Face value. Added Please reimport the fundas file again as there was error in arranging the columns especially TTM eps column and OPM Last edited by tanewbie; 17th August 2008 at 11:55 AM.
|
| Sponsored Links |
|
|
|
| Bookmarks |
| Thread Tools | |
|
|
Similar Threads for: Basic fundas of all cos in 1 excel sheet
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Sheet | chand | Software | 9 | 2nd May 2007 07:02 PM |
| Getting live datas from webpage to Excel Sheet | navino87 | Software | 5 | 20th February 2007 12:06 AM |
| CGTax calculation spred sheet | akh024 | Taxation Matters | 0 | 30th August 2006 06:24 PM |
| stock fundas, please! | bhangima | Equities | 7 | 12th June 2005 01:17 PM |
| datas in excel sheet | gopu | General Chit Chat | 1 | 28th October 2004 08:46 AM |
Indemnity, Disclaimer & Disclosure
Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum
Rules Disclaimer & Disclosure and indemnify Traderji.com, its
associates and related parties of all claims howsoever resulting from
the usage of the forum.
• Disclaimer: Trading or investing in stocks & commodities
is a high risk activity. Any action you choose to take in the markets
is totally your own responsibility. Traderji.com will not be liable for
any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information.
• Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein.
The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
Re: Basic fundas of all cos in 1 excel sheet
