|
PureBytes Links
Trading Reference Links
|
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 <vlanschot@xxxxxxxxx> 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 amibroker@xxxxxxxxxxxxxxx, "Super Man" <z35007@xxx> 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 <kavemanperth@xxx> 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 <z35007@xxx> 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 <z35007@xxx> 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
>
>
>
>
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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/amibroker/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:amibroker-digest@xxxxxxxxxxxxxxx
mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|