Thank you for your advice. I tried it from Refference guide->ASCII Importer reference.But cant satisfied all those fundamental data. Is there others way to import those fundamental data? Here i attatched data file I you figureout the problem I will greatful to u..
--- On Mon, 6/22/09, gmorlosky <[email protected]> wrote: From: gmorlosky <[email protected]> Subject: [amibroker] Re: aqe.format files $FORMAT command help. To: [email protected] Date: Monday, June 22, 2009, 4:53 PM Seems what you have is a combination of tick data and fundamental data. The tick data is somewhat easy. Tick example: Name, Fullname, Open, High, Low, Close...etc. Fundamental example ( see User Guide > fundamental ): DIV_PAY_DATE EX_DIV_DATE LAST_SPLIT_DATE LAST_SPLIT_RATIO EPS EPS_EST_CUR_ YEAR EPS_EST_NEXT_ YEAR EPS_EST_NEXT_ QTR FORWARD_EPS PEG_RATIO BOOK_VALUE (requires SHARES_OUT to be specified as well) BOOK_VALUE_PER_ SHARE EBITDA PRICE_TO_SALES (requires CLOSE to be specified as well) PRICE_TO_EARNINGS (requires CLOSE to be specified as well) PRICE_TO_BV (requires CLOSE to be specified as well) FORWARD_PE (requires CLOSE to be specified as well) REVENUE SHARES_SHORT DIVIDEND ONE_YEAR_TARGET MARKET_CAP (requires CLOSE to be specified as well - it is used to calculate shares outstanding) SHARES_FLOAT SHARES_OUT PROFIT_MARGIN OPERATING_MARGIN RETURN_ON_ASSETS RETURN_ON_EQUITY QTRLY_REVENUE_ GROWTH GROSS_PROFIT QTRLY_EARNINGS_ GROWTH INSIDER_HOLD_ PERCENT INSTIT_HOLD_ PERCENT SHARES_SHORT_ PREV FORWARD_DIV OPERATING_CASH_ FLOW FREE_CASH_FLOW BETA --- In amibro...@yahoogrou ps.com, "engrfa...@. .." <engrfa...@. ..> wrote: > > Hi/Assalamualiekum every1, > > I am in problem to import ASCII files of Amiquote Histirical esignal aqe > formated file. First 2lines of the file shown below: > 1. Trading Code,Company, Last Trade,Open Price,52 Weeks Range,Face > Value,Market Lot,Last AGM,Bonus Issues,Right Issue,Market Category,Market > Cap,Authorized Cap,Outstanding Cap,Business Segment,Nos Securities,Year > End,Reserve Surplus,HY End,HY Net Turnover,HY Net Profit,HY EPS,DSE PE,EPS > 2007,NAV 2007,Profit 2007,Dividend 2007,Dividend Yield 2007,EPS 2008,NAV > 2008,Profit 2008,Dividend 2008,Dividend Yield 2008,Electronic Share,Share % > Director,Share % Govt.,Share % Institute,Share % Foreign,Share % Public > 2. ABBANK,AB Bank Limited,699. 75,690.0, 390.0 - 4420.0,100.0, 5,16/07/2008, > "200% 2007, 30% 2006, 10% 2005, 5% 2003 & 2004, 15% 2002, 1B:","n/a",A, > 15218.285, 3000.0,2230. 0,Bank,22297854, 200712,2281. 8,200806, 3141.3,1302. > 72,58.42, 8.2,85.37, n/a,1903. 49,"200%B" ,-,n/a,n/ a,n/a,"n/ a",n/a,Y, > 50,0.57,0, 0,49.43 > > First1 are header and other1 is data. > > Pls any1 help me to write aqe.format file that fullfill all hearer without > skip.[$FORMAT ..,..,..,] > > Thanks in advance. >
