[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Re: Import historical fundamental data



PureBytes Links

Trading Reference Links

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@xxxxxxxxx> 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@xxxxxxxxx> 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




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___