Traderji.com - Discussion forum for Stocks Commodities & Forex

Basic fundas of all cos in 1 excel sheet

Discuss Basic fundas of all cos in 1 excel sheet at the Fundamental Analysis within the Traderji.com - Discussion forum for Stocks Commodities & Forex; thanks... It is good to have this. kiran...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > METHODS & STRATEGIES > Fundamental Analysis

Notices

Fundamental Analysis Discuss all about fundamental analysis and valuation. The world of PEs, free cash flow, ratio analysis, multiples and accounting numbers.


Advertise Here

Reply
 
Thread Tools
Sponsored Links
  #151  
Old 16th August 2008, 11:48 AM
Member
 
Join Date: Jul 2008
Posts: 15
Thanks: 0
Thanked 9 Times in 5 Posts
josekiran is on a distinguished road
Reputation: 19
Default Re: Basic fundas of all cos in 1 excel sheet

thanks... It is good to have this.

kiran
Reply With Quote
Sponsored Links
  #152  
Old 18th August 2008, 04:58 PM
Member
 
Join Date: Jul 2004
Posts: 454
Thanks: 34
Thanked 288 Times in 86 Posts
tanewbie is a jewel in the roughtanewbie is a jewel in the roughtanewbie is a jewel in the roughtanewbie is a jewel in the rough
Reputation: 312
Default Re: Basic fundas of all cos in 1 excel sheet

download report from:

tinyurl dot com/6y7foy
Reply With Quote
The Following User Says Thank You to tanewbie For This Useful Post:
asterix24 (19th August 2008)
  #153  
Old 19th August 2008, 08:45 PM
Member
 
Join Date: Aug 2008
Posts: 2
Thanks: 3
Thanked 0 Times in 0 Posts
asterix24 is on a distinguished road
Reputation: 10
Default Re: Basic fundas of all cos in 1 excel sheet

Thanks ...
Reply With Quote
  #154  
Old 19th August 2008, 10:29 PM
Member
 
Join Date: Jun 2006
Location: Pune
Posts: 49
Thanks: 5
Thanked 3 Times in 2 Posts
jayzarna is on a distinguished road
Reputation: 23
Default Re: Basic fundas of all cos in 1 excel sheet

Quote:
Originally Posted by tanewbie View Post
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
Reply With Quote
  #155  
Old 20th August 2008, 12:22 AM
Member
 
Join Date: Jun 2006
Location: Pune
Posts: 49
Thanks: 5
Thanked 3 Times in 2 Posts
jayzarna is on a distinguished road
Reputation: 23
Default Re: Basic fundas of all cos in 1 excel sheet

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
Reply With Quote
  #156  
Old 21st August 2008, 01:49 AM
Member
 
Join Date: Apr 2006
Posts: 56
Thanks: 3
Thanked 0 Times in 0 Posts
ragsid is on a distinguished road
Reputation: 20
Default Re: Basic fundas of all cos in 1 excel sheet

Hi Tanewbie,

Hats off. Thanks a lot. It worked smoothly.

Cheers
Reply With Quote
  #157  
Old 21st August 2008, 10:57 PM
Member
 
Join Date: Jul 2004
Posts: 454
Thanks: 34
Thanked 288 Times in 86 Posts
tanewbie is a jewel in the roughtanewbie is a jewel in the roughtanewbie is a jewel in the roughtanewbie is a jewel in the rough
Reputation: 312
Default Re: Basic fundas of all cos in 1 excel sheet

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
Attached Files
File Type: zip margins210808.zip (5.0 KB, 17 views)
Reply With Quote
The Following User Says Thank You to tanewbie For This Useful Post:
chintan786 (21st August 2008)
  #158  
Old 21st August 2008, 11:39 PM
Member
 
Join Date: Apr 2007
Posts: 709
Thanks: 87
Thanked 98 Times in 44 Posts
chintan786 will become famous soon enoughchintan786 will become famous soon enough
Reputation: 127
Default Re: Basic fundas of all cos in 1 excel sheet

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
Reply With Quote
  #159  
Old 21st August 2008, 11:47 PM
Member
 
Join Date: Jul 2004
Posts: 454
Thanks: 34
Thanked 288 Times in 86 Posts
tanewbie is a jewel in the roughtanewbie is a jewel in the roughtanewbie is a jewel in the roughtanewbie is a jewel in the rough
Reputation: 312
Default Re: Basic fundas of all cos in 1 excel sheet

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
Attached Files
File Type: zip margins210808.zip (5.1 KB, 19 views)
Reply With Quote
The Following 2 Users Say Thank You to tanewbie For This Useful Post:
adesara (22nd August 2008), chintan786 (21st August 2008)
  #160  
Old 21st August 2008, 11:51 PM
Member
 
Join Date: Apr 2007
Posts: 709
Thanks: 87
Thanked 98 Times in 44 Posts
chintan786 will become famous soon enoughchintan786 will become famous soon enough
Reputation: 127
Default Re: Basic fundas of all cos in 1 excel sheet

thanks Tanewbie... now it is fine...thanks a ton
Reply With Quote
Sponsored Links

Reply

Bookmarks


Advertise Here


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

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


All times are GMT +5.5. The time now is 11:06 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.
 


Copyright © 2001 - 2008, Traderji.com All Rights Reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.MasterOfTrading.com