|
|
| Discuss Basic fundas of all cos in 1 excel sheet at the Fundamental Analysis within the Traderji.com - Discussion forum for Stocks Commodities & Forex; i ma concerned if this can be done in meta,,, wonder ..NO but superb,,, guys ... |
|
|||||||
| 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 |
|
#91
8th August 2008, 08:49 AM
|
|||
|
|||
Re: Basic fundas of all cos in 1 excel sheet
i ma concerned if this can be done in meta,,, wonder ..NO
but superb,,, guys u ahve done very good no need to open ET renu 
|
| Sponsored Links |
|
#92
8th August 2008, 05:09 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
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 Last edited by kenneth; 9th August 2008 at 02:50 PM.
|
|
#93
9th August 2008, 11:28 AM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
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 Last edited by kenneth; 9th August 2008 at 02:49 PM.
|
|
#94
9th August 2008, 02:12 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
Quote:
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,
|
|
#95
9th August 2008, 06:53 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
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 Last edited by tanewbie; 23rd September 2008 at 09:20 PM.
|
| The Following 2 Users Say Thank You to tanewbie For This Useful Post: | ||
karthikmarar (9th August 2008), rmike (10th August 2008) | ||
|
#96
9th August 2008, 07:27 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
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 Last edited by tanewbie; 9th August 2008 at 07:30 PM. Reason: addition
|
|
#97
9th August 2008, 08:09 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
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
|
|
#98
10th August 2008, 12:21 AM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
Thanks tanewbie for the new file and format.Updated my database.
Regards ken Last edited by kenneth; 8th November 2008 at 10:35 PM.
|
| The Following User Says Thank You to kenneth For This Useful Post: | ||
columbus (10th August 2008) | ||
|
#99
10th August 2008, 06:46 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
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
|
|
#100
10th August 2008, 07:06 PM
|
|||
|
|||
|
Re: Basic fundas of all cos in 1 excel sheet
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 Last edited by kenneth; 10th August 2008 at 07:23 PM.
|
| 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.
