Thanks Dave. I put it in my bookmarks.
A very useful tip. BrianB. --- In [email protected], "MarketMonk777" <[EMAIL PROTECTED]> wrote: > > LOL, > > One trick is to use www.trimurl.com and copy and paste the link into their > window and you will get http://trimurl.com/6N6 which is a shorted version > and is especially great for any links that have spaces in them. > > Dave > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of brian.z123 > Sent: Sunday, July 16, 2006 8:10 PM > To: [email protected] > Subject: [amibroker] Re: Historical Fundamental Data > > Third time lucky? > > http://finance.groups.yahoo.com/group/amibroker/files/Fundamental% > 20Data/ > group/amibroker/files/Fundamental%20Data amibroker/files/Fundamental%20Data files/Fundamental%20Data > --- In [email protected], "brian.z123" <brian.z123@> > wrote: > > > > Hello Joe, > > > > Thanks to you and also treliff for jumping in and putting some weight > > on the oars; we have moved a little further up the stream. > > > > I think there will be a lot more questions about the subject when the > > SQL plug-in comes out. > > It is all new to me, as it will be to most others. > > Prior to this I couldn't find a retail program that would allow me to > > use fdata inputs in formulas. > > Of course, I haven't tried every single program e.g I bypassed > > Tradestation as it is 'trading platform' based and since 9/11 USA > > regulators have tightened up on foreign investors and TS no longer > > accepts accounts from US non-residents. > > Prior to this I did my funda analysis by manually entering data to > > Xcel, and that was for the Aussie market only. > > > > So for the list of sites I have posted there are a lot of > questions > > to be answered and trefill's question is one of the more important > > ones. > > > > 'Will an AAII subscription truly enable me to pour all past data into > > a .csv file?' > > > > It is a question equally as relevant to all the sites. > > > > The reason I posted the list in the first place was because the > > inititial reaction of many would be to go straight for the AAII > > version or perhaps similar sources. > > By questioning a little further perhaps we will find about the > pros > > and cons of each site in advance, and in some cases, save > ourselves > > some time and money. > > There are also going to be additional problems with f databases > > compared to price databases; price only comprises 6 fields (OHLCVOI), > > the fields/formats are standard across all providers, data is > > precisely time dependent, data is continuous and histories are > > complete and deep in most cases i.e apples = apples almost > every > > time. > > The opposite applies to fdata in all five areas. > > > > > > Re your comments. > > > > No it is not more than we need to know. > > It is spot on. > > > > So far, as I understand it, AAII has 100-200 data fields available > > with varying number of years available for each. > > The screening software will export in a suitable format for AB but it > > will not export the database in its entirety in one step. > > AB users would need to export,say, 5-10 segments of the database > > separately and then join them together if they wanted one database. > > Alternatively they could just keep them as,say, 10 separate SQL bases. > > > > If this is correct, it leaves us with a big question mark over the use > > of the keys (what are they and what are they for) and also the timing > > of the updates (weekly/monthly are always lagging updates). > > There is also a minor question of whether the database will always be > > 7yrs/8qtrs or is it growing each year? > > > > The files re this topic are at the Fundamental Data folder; menu > at > > the top left corner of this page>files?fundamental data. > > > > I think this will take users to it: > > > > http://groups.yahoo.com/group/fundamental data > > > > If you can post a .csv of one table downloaded for as many years > as > > you can get, with the relevant key, that would be great. > > Even screenshots pasted into Word would do. > > That would be service 'above and beyond the call of duty' and > enough > > for anyone contemplating fdata use and AAII in particular. > > > > From there interested users should move to their own trial via the > > money back guarentee. > > > > I have posted a text file there that I am using to keep track of > all > > fdata providers of any kind. > > > > Regards, > > > > BrianB2. > > > > > > --- In [email protected], "Joe Landry" <jelandry@> wrote: > > > > > > Brian - A few notes back someone mentioned that SI Pro had a > > feature to > > > export data. I fired up the dated > > > version I have and found that the data is organized in 22 > > tables/files that > > > can be exported one at a time. Also there are keys that get > > > exported with each file. If any interest I > can > > store 2 or > > > 3 of these keys in the files section of the fundamental forum for > > > folks to consider, if you'll clue > me > > into the > > > link to that forum. > > > > > > The Standard Table export consists of 6.8 MB in XLS format. > > > There are 7968 issues back in 2004 > > > Formats available are XLS, Lotus, XBase(dbf), fixed length, > > comma > > > separated, or tab separated fields. > > > > > > I'm still working on it but what I see are 2 dimensional > tables, > > ticker > > > rows by column data, as a sample > > > of the Growth Rates keys table below shows. Looks like the > > historical > > > aspect is relative coarse grained > > > going back 8 years on some fields, but that's expected since the > > statistics > > > are reported quarterly. > > > A stumper is how would you get a historical institutional > > ownership unless > > > you had collected the monthly CDs over > > > 8 years. I could be off the mark here, and if so would > appreciate > > someone > > > setting me straight. > > > > > > Probably more than you'd want to know. Looks to be a lot of > work > > to > > > interface to SQL server, even with > > > the SQL Server's data transformation tool. > > > > > > Best regards > > > JOE > > > > > > > > > short_name long_name > > > COMPANY Company name > > > TICKER Ticker > > > EXCHG_DESC Exchange > > > SMG_DESC Sector > > > IMG_DESC Industry > > > CFPS_G1T Cash Flow-Growth 12m > > > SALES_G1T Sales-Growth 12m > > > SALES_G1F Sales-Growth 1yr > > > SALES_G3F Sales-Growth 3yr > > > SALES_G5F Sales-Growth 5yr > > > SALES_G7F Sales-Growth 7yr > > > RSALES_G1T % Rank-Sales-Growth 12m > > > RSALES_G1F % Rank-Sales-Growth 1yr > > > RSALES_G3F % Rank-Sales-Growth 3yr > > > RSALES_G5F % Rank-Sales-Growth 5yr > > > RSALES_G7F % Rank-Sales-Growth 7yr > > > SALES_G1Q5 Sales-Growth from Q5 to Q1 > > > SALES_G2Q6 Sales-Growth from Q6 to Q2 > > > SALES_G3Q7 Sales-Growth from Q7 to Q3 > > > SALES_G4Q8 Sales-Growth from Q8 to Q4 > > > > > > > > > > > > > > > ----- Original Message ----- > > > From: "brian.z123" <brian.z123@> > > > To: <[email protected]> > > > Sent: Saturday, July 15, 2006 9:18 PM > > > Subject: [amibroker] Re: Historical Fundamental Data > > > > > > > > > > Hello treliff, > > > > > > > > Agreed that all historical fundamental data is not created > equal. > > > > > > > > I am looking out for peoples favourites or recommended sites. > > > > > > > > It is a fair question to ask of the sites that have > screen>export > > > > software if indeed all fields can be exported in one file and > if > > so > > > > what is the depth (years)? > > > > > > > > Re your comment 'the habit of kicking out the previous value > and > > > > simply replacing it with the new one seems to be the norm in > > > > fundaland'. > > > > Do you mean that many of the historical sites I have listed > are > > in > > > > fact only current data providers? > > > > I am trying to understand what you pointed out to us there. > > > > > > > > > > > > Minor comments. > > > > > > > > I have QP and IQ data as two providers who bundle current > fdata > > with > > > > their price data. > > > > There are probably others. > > > > It used to be a very short list but new players pop up every > day. > > > > > > > > http://www.qp2.com > > > > http://www.iqfeed.net/ > > > > > > > > I had Stockwiz in the short list for hist fdata but the site > has > > > > changed recently and I couldn't find any reference to it that > the > > > > public can access. > > > > They do talk about fundas but no details are given and the > link > > to > > > > the data site is know a log on restricted access site. > > > > > > > > I added tbsp to the histo list. > > > > > > > > http://www.tbsp.com/public/default.htm > > > > > > > > AAII Stock Investor Pro lists the financials that are > available > > for > > > > 7yrs/8qtrs and has a 'money back period'. > > > > Admittedly 'money backs' are not as user frienly as free demo > > > > versions. > > > > > > > > http://www.aaii.com/stockinvestor/intro/guarantee.cfm > > > > > > http://www.aaii.com/stockinvestor/intro/overview/statementcomp.cfm > > > > > > > > Brian. > > > > > > > > --- In [email protected], "treliff" <treliff@> wrote: > > > >> > > > >> Thanks to everyone sharing their insights on fundamental data > > > >> collection. A small contribution: > > > >> > > > >> Those interested only in: > > > >> > > > >> Shares out > > > >> Float > > > >> Short interest > > > >> Insider ownership > > > >> Institutional ownership > > > >> > > > >> may consider shortsqueeze.com. At $28 they allow access to > their > > > >> historical data (starting only mid 2004) in XL format. > > > >> > > > >> ... and a small request: > > > >> > > > >> In joining the search for historical funda's I found AAII most > > > > likely > > > >> to indeed have this ability by their Data Exporting feature: > > > >> > > > >> " All of the fields found in Stock Investor Pro can be > exported > > in > > > > a > > > >> variety of formats, including Excel & Lotus spreadsheets, > ASCII > > > > tab- > > > >> and comma-delimited formats, and dBase format. " > > > >> > > > >> But does this indeed include ALL historicals? Daily, weekly, > > > > monthly, > > > >> at whichever frequency each field was updated in the past? > > > >> > > > >> I'm very suspicious and they don't have a trial. Suspicious > > > > because > > > >> the habit of kicking out the previous value and simply > replacing > > > > it > > > >> with the new one seems to be the norm in fundaland (QP, tbsp, > > > > zacks, > > > >> reuters, stockwiz etc etc... and I'm afraid many of the sites > > > > Brian > > > >> has listed). > > > >> > > > >> So can anyone confirm (Mike perhaps, who has a subscription), > > for > > > >> example re. short interest (or any other fundamental field): > > will > > > > an > > > >> AAII subscription truly enable me to pour all past data into > > > > a .csv > > > >> file? No PowerTools or SuperScreens, just good'ol plain raw > > data :) > > > >> > > > >> Stock XYZ short interest: > > > >> > > > >> Jan '05: ... > > > >> Feb '05: ... > > > >> . > > > >> . > > > >> Jun '06: ... > > > >> > > > >> Thanks for your advice! > > > >> > > > >> -treliff > > > >> > > > >> --- In [email protected], "brian.z123" <brian.z123@> > > wrote: > > > >> > > > > >> > Now you see it, now you don't. > > > >> > > > > >> > Here it is! > > > >> > > > > >> > http://betterinvesting.stores.yahoo.net/23303.html > > > >> > http://nt3.zacks.com/default.htm > > > >> > http://online.barrons.com/public/main > > > >> > http://sec.freeedgar.com/ > > > >> > http://today.reuters.com/news/home.aspx > > > >> > http://www.aaii.com/stockinvestor/intro/ > > > >> > http://www.angelfire.com/in/vestinukgrowthshares/cdrefs.html > > > >> > http://www.aspecthuntley.com.au/af/home?xtm- > > > > licensee=aspecthuntley > > > >> > http://www.capitaliq.com/ > > > >> > http://www.cbs.curtin.edu.au/index.cfm?objectId=1B3273A3- > 0C32- > > > > 2E2E- > > > >> > 4B5B799689FF74FC > > > >> > http://www.crsp.chicagogsb.edu/ http://www.csidata.com/ > > > >> > http://www.exchange- data.com/products/fundamental_data.aspx > > > >> > http://www.fisonline.com/ > > > >> > http://www.fordequity.com/html/pr_data_usdaily.htm > > > >> > http://www.globalfinancialdata.com/index.php3 > > > >> > http://www.hemscottdata.com/ > > > >> > http://www.investmenteasy.com/home.aspx > > > >> > http://www.it is a capital mistake to theorize in advance > of > > the > > > >> > facts.Sherlock Holmes > > > >> > http://www.market-eye.co.uk/ > > > >> > http://www.marketdata.sungard.com/ > > > >> > http://www.msodata.com/ > > > >> > http://www.perfectinfo.com/product_detail.asp?productid=4 > > > >> > http://www.qaisoftware.com/index.html > > > >> > http://www.rimes.com/index.xmp > > > >> > http://www.securities.com/ > > > >> > http://www.thomson.com/index.jsp http://www.trackdata.com/ > > > >> > http://www.tradetools.com/web/scripts/default.asp > > > >> > http://www.valueline.com/ > > > >> > http://www.wvb.com/ > > > >> > http://www.zacks.com/ > > > >> > http://www2.standardandpoors.com/servlet/Satellite? > > > >> > pagename=sp/Page/HomePg&r=1&l=EN&b=10 > > > >> > > > > >> > Some offer full financials, some are summarised (financial > or > > > > key > > > >> > statistics/ratios) and the third possiblity also applies. > > > >> > > > > >> > Brian. > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > > >> > --- In [email protected], "brian.z123" <brian.z123@> > > > >> > wrote: > > > >> > > > > > >> > > Historical fundamental data providers. > > > >> > > > > > >> > > > > > >> > > > > > >> > > Here is a list of links to sites that provide historical > > fdata > > > >> > that > > > >> > > may be of interest to AB users when the SQL plug-in is > > > > released. > > > >> > > > > > >> > > Some of them were reviewed by forum members at the 'New > > > >> > Fundamental > > > >> > > Data' and 'Institutional Ownership' topics. > > > >> > > > > > >> > > Most are USA market biased with some global providers and > a > > > >> couple > > > >> > > for specific markets (UK and Aus - sorry I don't have any > > for > > > >> > other > > > >> > > individual markets). > > > >> > > They include retail investor providers, investment club > > > >> providers, > > > >> > > academic providers (free to accredited people???) and > > > >> > institutional > > > >> > > level data (some institutional providers package parts of > > > > their > > > >> > > systems for individual users). > > > >> > > > > > >> > > The links don't necessarily lead straight to the data; > some > > > >> > snooping > > > >> > > around is required in some cases. > > > >> > > It might also contain errors or dead leads. > > > >> > > > > > >> > > It is not a complete list by any means but includes most > of > > > > the > > > >> > main > > > >> > > suspects. > > > >> > > Any further leads would be welcomed, including non- English > > > >> > speaking > > > >> > > sites/markets (as long as the post is in English). > > > >> > > The criteria for the list is that the database must > include > > > > some > > > >> > > industry standard fundamental data and be exportable in a > > > > format > > > >> > > that can be used by AB or other similar programs (for > those > > > > who > > > >> > own > > > >> > > more than one software package). > > > >> > > For anyone who has info readily available; providers home > > > >> country, > > > >> > > site URL, market, cost, instruments covered, database > > length, > > > > EOD > > > >> > or > > > >> > > weekly data etc, download/update method and frequency, > data > > > >> > fields, > > > >> > > CD available, download or intermediatry software needed > and > > > >> > download > > > >> > > formats available is the type of stuff that provides > useful > > > >> > guidance > > > >> > > for forum members. > > > >> > > > > > >> > > I might make a comparison table, and file it at this > site, > > at > > > > a > > > >> > > later date. > > > >> > > > > > >> > > Brian. > > > >> > > > > > >> > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 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 other support material please check also: > > > > http://www.amibroker.com/support.html > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor -------------------- ~--> > Yahoo! Groups gets a make over. See the new email design. > http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/GHeqlB/TM > ------------------------------------------------------------------- -~-> > > 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 other support material please check also: > http://www.amibroker.com/support.html > > > Yahoo! Groups Links > ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/GHeqlB/TM --------------------------------------------------------------------~-> 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 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/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
