Not necessary for symbol for every date When you have new values just add to one of the price arrays, eg import as Close value at current date
-- Cheers Graham Kav AFL Writing Service http://www.aflwriting.com On 12/02/2008, vlanschot <[EMAIL PROTECTED]> wrote: > If you're willing to change the format of your csv-file slightly you > could use the free ThCSV plug-in, which was specifically created for > this purpose. It is able to read csv-files formatted along the lines > you desribe for dozens of columns with fundamental data. > > More details: ask support. > > PS > > --- In [email protected], "Super Man" <[EMAIL PROTECTED]> wrote: > > > > I guess that wouldn't solve the problem. I need to create a new > symbol > > ABCD_PE_DATE which has the PE for a particular date. Ideally, the > PE should > > associated with a particular (symbol,date) and not just the symbol - > - Are > > there any plans to change this in the schema? > > > > Thanks, > > Sam > > > > On Feb 12, 2008 2:46 AM, Graham <[EMAIL PROTECTED]> wrote: > > > > > you would be ebst to either create symbols just for the PE > data, eg if > > > sym is ABCD then use ABCD_PE > > > or save the data to text files for each symbol and reference this > in your > > > afl. > > > > > > > > > -- > > > Cheers > > > Graham Kav > > > AFL Writing Service > > > http://www.aflwriting.com > > > > > > > > > > > > On 12/02/2008, Super Man <[EMAIL PROTECTED]> wrote: > > > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Please note that this group is for discussion between users only. > > To get support from AmiBroker please send an e-mail directly to > SUPPORT {at} amibroker.com > > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: > http://www.amibroker.com/devlog/ > > For other support material please check also: > http://www.amibroker.com/support.html > > Yahoo! Groups Links > > > >
