Hi all, Can some one help with this question? Recording the PE of a security at different times of the year is critical to do some techno-fundamental analysis.
Thanks, Sam On Feb 8, 2008 9:06 AM, Super Man <[EMAIL PROTECTED]> wrote: > Hi, > I am trying to import historical fundamental data using ASCII import. My > format file looks something like this > $SKIPLINES 1 > $NOQUOTES 1 > $AUTOADD 1 > # $OVERWRITE 1 > $SEPARATOR , > $DEBUG 1 > $CONT 1 > $FORMAT Ticker, Date_DMY, Open, High, Low, Close, Skip, PRICE_TO_EARNINGS, > PRICE_TO_BV, DIVIDEND, Skip > and the data file is something like this > Ticker,Date,Open,High,Low,Close,Date,P/E,P/B,Div Yield,EPS > NIFTY,30-Jan-08,5283.75,5314.3,5142.25,5167.6,30-Jan-08,22.02,5.41,0.99, > 234.6775658 > NIFTY,31-Jan-08,5172.25,5251.65,5071.15,5137.45,31-Jan-08,21.97,5.38,0.99, > 233.8393264 > NIFTY,1-Feb-08,5140.6,5339.95,5090.75,5317.25,1-Feb-08,22.68,5.57,0.96, > 234.446649 > NIFTY,4-Feb-08,5315.55,5545.2,5315.55,5463.5,4-Feb-08,23.31,5.72,0.94, > 234.3843844 > NIFTY,5-Feb-08,5463.75,5500.6,5412.95,5483.9,5-Feb-08,23.4,5.74,0.93, > 234.3547009 > NIFTY,6-Feb-08,5470.4,5470.4,5257.05,5322.55,6-Feb-08,22.71,5.58,0.96, > 234.3703214 > NIFTY,7-Feb-08,5322.55,5344.6,5113.85,5133.25,7-Feb-08,21.9,5.38,1, > 234.3949772 > But, when I import this data, the P/E is the same for all dates (the last > value in the data file). I want to store the PE for the symbol NIFTY for > every date. Is this possible? > Thanks, > Sam >
