ftp.xmission.com

home *** CD-ROM | disk | FTP | other *** search

/ ftp.xmission.com / 2014.06.ftp.xmission.com.tar / ftp.xmission.com / pub / lists / canslim / archive / v02.n1183 < prev next >

Wrap

Internet Message Format | 2001-03-06 | 50KB

From: owner-canslim-digest@lists.xmission.com (canslim-digest) To: canslim-digest@lists.xmission.com Subject: canslim-digest V2 #1183 Reply-To: canslim Sender: owner-canslim-digest@lists.xmission.com Errors-To: owner-canslim-digest@lists.xmission.com Precedence: bulk Content-Transfer-Encoding: quoted-printable X-No-Archive: yes canslim-digest Tuesday, March 6 2001 Volume 02 : Number 1183 In this issue: Re: [CANSLIM] Medical/Dental/Svcs + AIQ RE: [CANSLIM] importing from qp2 into excel RE: [CANSLIM] importing from qp2 into excel Re: [CANSLIM] averaging up/dn & tax free vs taxable acct Re: [CANSLIM] Late IBD Re: [CANSLIM] Late IBD Re: [CANSLIM] Pitbull Investor / Stocktables.com Re: [CANSLIM] LNCR RE: [CANSLIM] spreadsheet of excel from qp2 data ---------------------------------------------------------------------- Date: Tue, 6 Mar 2001 21:04:48 -0500 From: "Tom Worley" <stkguru@netside.net> Subject: Re: [CANSLIM] Medical/Dental/Svcs + AIQ This is a multi-part message in MIME format. - ------=_NextPart_000_009C_01C0A681.14986EA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Frank, I am not an AIQ user (frankly, no pun intended, don't even know what the = letters stand for), but as a thought, when I saw you had 197 groups it = occurred to me you may have used WON's list of groups to construct = exactly the same ones with the same composition. If so, perhaps you = could share that part of your labors with those members also using AIQ? Tom Worley stkguru@netside.net ICQ # 5568838 ----- Original Message -----=20 From: Frank V. Wolynski=20 To: canslim@lists.xmission.com=20 Sent: Monday, March 05, 2001 9:34 PM Subject: Re: [CANSLIM] Medical/Dental/Svcs + AIQ At 08:46 AM 3/5/2001 -0500, you wrote:=20 How does it fit into the CANSLIM approach? Did you=20 define the Dental Services group or do they define groups,=20 I had to manually define all 197 groups and populate the groups by = assigning the tickers to them. I't was more than worth it though. AIQ's = Trading Expert can be for the casual weekend chartists, but to get the = kind of performance from it I do, will take many, many hours of setting = up and building of groups. My group analysis is primarily from weekly = scans I run with EDS, my stock analysis is done daily with a different = scan that includes fundamental data. To me, although labor intensive, it = is everything I wanted it to be. I haven't been able to think of a = single idea, I haven't been able to replicate and test in TEX. - ------=_NextPart_000_009C_01C0A681.14986EA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV>Hi Frank,</DIV> <DIV> </DIV> <DIV>I am not an AIQ user (frankly, no pun intended, = don't even=20 know what the letters stand for), but as a thought, when I saw you had = 197=20 groups it occurred to me you may have used WON's list of groups to = construct=20 exactly the same ones with the same composition. If so, perhaps you = could share=20 that part of your labors with those members also using AIQ?</DIV> <DIV> Tom Worley <A=20 href=3D"mailto:stkguru@netside.net">stkguru@netside.net</A> ICQ # = 5568838</DIV> <DIV> </DIV> <DIV> </DIV> <BLOCKQUOTE=20 style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black">From:=20 <A href=3D"mailto:wolynski@tampabay.rr.com" = title=3Dwolynski@tampabay.rr.com>Frank=20 V. Wolynski</A> </DIV> <DIV style=3D"FONT: 10pt arial">To: <A=20 href=3D"mailto:canslim@lists.xmission.com"=20 title=3Dcanslim@lists.xmission.com>canslim@lists.xmission.com</A> = </DIV> <DIV style=3D"FONT: 10pt arial">Sent: Monday, March 05, 2001 = 9:34=20 PM</DIV> <DIV style=3D"FONT: 10pt arial">Subject: Re: [CANSLIM]=20 Medical/Dental/Svcs + AIQ</DIV> <DIV> </DIV>At 08:46 AM 3/5/2001 -0500, you wrote: <FONT=20 size=3D3> <BLOCKQUOTE cite type=3D"cite">How does it fit into the CANSLIM = approach? Did=20 you define the Dental Services group or do they define groups,=20 </BLOCKQUOTE> I had to manually define all = 197 groups=20 and populate the groups by assigning the tickers to them. I't was more = than=20 worth it though. AIQ's Trading Expert can be for the casual weekend = chartists,=20 but to get the kind of performance from it I do, will take many, many = hours of=20 setting up and building of groups. My group analysis is primarily from = weekly=20 scans I run with EDS, my stock analysis is done daily with a different = scan=20 that includes fundamental data. To me, although labor intensive, it is = everything I wanted it to be. I haven't been able to think of a single = idea, I=20 haven't been able to replicate and test in=20 TEX. </BLOCKQUOTE></BODY></HTML> - ------=_NextPart_000_009C_01C0A681.14986EA0-- - - ------------------------------ Date: Tue, 6 Mar 2001 20:05:44 -0600 From: "curtis" <curtis@ticnet.com> Subject: RE: [CANSLIM] importing from qp2 into excel This is a multi-part message in MIME format. - ------=_NextPart_000_0000_01C0A678.D4384E00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit John; Are you going to share the code or a .xla file? Did you reverse engineer the OÆNeill .dll functions? Curtis - -----Original Message----- From: owner-canslim@lists.xmission.com [mailto:owner-canslim@lists.xmission.com]On Behalf Of John Adair Sent: Monday, March 05, 2001 10:11 PM To: Canslim@Lists.Xmission.Com Subject: [CANSLIM] importing from qp2 into excel Hi This is a luker for a long time <John> I am developing a spreadsheet using the dll files in quotes plus to down load about 500 days of data on any stock in their database. I import into excel, date, open, hi, lo, close, volume, qrs,. To this data I program the 20 day mov of volume, 50 day mov of volume,% off the 50 day mov of volume. I program the accumulation/dist days based on Oneals formula. I then enter any stock in cell A1of excel and all the data instantly appear. If the volume is not up in all columns. I consider there is not accumulation of this stock and not worth further evaluation. Note the accumulation and the % off hi columns are surprising . I note accumulation for months but the volume will not be that much up I think I need to rework my formula for this portion. Btw If you havenÆt tried the dll files in quotes plus to download data into excel you might like it. Actually any piece if data in quotes plus may be imported into excel at the same time. I would send a spreadsheet but I donÆt think it would fit In the xmission . I submit this for criticism and comment. - ------=_NextPart_000_0000_01C0A678.D4384E00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 9"> <meta name=3DOriginator content=3D"Microsoft Word 9"> <link rel=3DFile-List href=3D"cid:filelist.xml@01C0A677.C6B7B0A0">  <style>  </style> </head> <body lang=3DEN-US style=3D'tab-interval:.5in'> <div class=3DSection1> John;<o:p></o:p></fon= t> <![if = !supportEmptyParas]> <![endif]><o:p></o:p><= /p> Are you = going to share the code or a .xla file? Did you reverse engineer the O’Neill .dll = functions?<o:p></o:p> <![if = !supportEmptyParas]> <![endif]><o:p></o:p><= /p> Curtis<o:p></o:p></fo= nt> <![if = !supportEmptyParas]> <![endif]><o:p></o:p><= /p> -----Original Message----- From:</f= ont> owner-canslim@lists.xmission.com [mailto:owner-canslim@lists.xmission.com]On Behalf Of John Adair Sent:<fo= nt size=3D2 color=3Dblack face=3DTahoma> Monday, March 05, 2001 10:11 PM To:<font= size=3D2 color=3Dblack face=3DTahoma> Canslim@Lists.Xmission.Com Subject:= [CANSLIM] importing from qp2 into excel <![if = !supportEmptyParas]> <![endif]><o:p></o:p> Hi This is a luker for a long time <John><o:p></o:p> I am developing a spreadsheet using the dll files in = quotes plus to down load about 500 days of data on any stock in their database. = I import into excel, date, open, hi, lo, close, volume, = qrs,.<o:p></o:p><= /b> To this data I program the 20 day = mov of volume, 50 day mov of volume,% off the 50 day mov of volume. = <o:p></o:p><= /b> I program the accumulation/dist days = based on Oneals formula.<o:p></o:p> I then enter any stock in cell A1of = excel and all the data instantly appear. If the volume is not up in all columns. I consider there is not accumulation of this stock and not worth further evaluation. Note the accumulation and the % off hi columns are = surprising . I note accumulation for months but the volume will not be that much = up<o:p></o:p><= /b> I think I need to rework my formula = for this portion.<o:p></o:p> Btw If you haven’t tried the = dll files in quotes plus to download data into excel you might like it. Actually any = piece if data in quotes plus may be imported into excel at the same time. I = would send a spreadsheet but I don’t think it would fit In the xmission = .<o:p></o:p><= /b> I submit this for criticism and = comment.<o:p></o:p> </div> </body> </html> - ------=_NextPart_000_0000_01C0A678.D4384E00-- - - ------------------------------ Date: Tue, 6 Mar 2001 20:13:14 -0600 From: "John Adair" <xjadair@brightok.net> Subject: RE: [CANSLIM] importing from qp2 into excel My spreadsheet is far too big to transfer over the xmission. - -----Original Message----- From: owner-canslim@lists.xmission.com [mailto:owner-canslim@lists.xmission.com]On Behalf Of rolatzi Sent: Tuesday, March 06, 2001 6:57 AM To: canslim@lists.xmission.com Subject: Re: [CANSLIM] importing from qp2 into excel John, I use QP2 and would appreciate receiving a copy of your spreadsheet. I haven't downloaded data from the dll's but tend to write scans that give me the information that I want. With regard to accumulation, According to Ralph Icanmakeyoupoora, to really do accumulation, you should examine the daily trasaction by transaction accumulation. Often stocks close with big swings on small volumes and the large volume traded during the day doesn't reflect the actual distribution going on. He claims that this data gives a much more accurated prediction of return. rolatzi - --- John Adair <xjadair@brightok.net> wrote: > Hi This is a luker for a long time <John> > I am developing a spreadsheet using the dll files in > quotes plus to down > load about 500 days of data on any stock in their > database. I import into > excel, date, open, hi, lo, close, volume, qrs,. > To this data I program the 20 day mov of volume, 50 day > mov of volume,% off > the 50 day mov of volume. > I program the accumulation/dist days based on Oneals > formula. > I then enter any stock in cell A1of excel and all the > data instantly appear. > If the volume is not up in all columns. I consider there > is not accumulation > of this stock and not worth further evaluation. Note the > accumulation and > the % off hi columns are surprising . I note accumulation > for months but the > volume will not be that much up > I think I need to rework my formula for this portion. > Btw If you haven't tried the dll files in quotes plus to > download data into > excel you might like it. Actually any piece if data in > quotes plus may be > imported into excel at the same time. I would send a > spreadsheet but I don't > think it would fit In the xmission . > I submit this for criticism and comment. > __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - - - - ------------------------------ Date: Tue, 6 Mar 2001 18:14:32 -0800 From: "Mike Lucero" <mikelu57@hotmail.com> Subject: Re: [CANSLIM] averaging up/dn & tax free vs taxable acct James O'Shaugnessy has books that compare different strategies, including CANSLIM and Dogs of the Dow. Mike - ----- Original Message ----- From: "Patrick Wahl" <pwahl@prodigy.net> To: <canslim@lists.xmission.com> Sent: Tuesday, March 06, 2001 11:39 AM Subject: Re: [CANSLIM] averaging up/dn & tax free vs taxable acct > > > On 6 Mar 01, at 12:10, Norman wrote: > > > > My friend and I have 'compared' CANSLIM vs buy-n-hold tech blue chips at > > length. My delimma is that I find both mehtods 'logical' when used in the > > right type of account: CANSLIM in any type account, and b-n-h in a long term account such as retirement money. I am not particularly drawn to b-n-h, but the way > > he is doing it, it seems logical, especially in the current market. Has any one else thought about this: CANSLIM vs buy-n-hold in a long-term account? > > Actually, your friends idea seems sound, and I do that sort of > investing a bit in my IRA accounts, it has worked out ok. I think it > is a personality thing as much as anything else. I like a little more > activity than that, and I feel my risk management is better with > CANSLIM, since I am not letting anything run away from me. > > > - > > - - ------------------------------ Date: Tue, 06 Mar 2001 19:16:54 -0700 From: esetser <esetser@covad.net> Subject: Re: [CANSLIM] Late IBD This sounds worse than my experience. I get the paper delivered, and I probably miss one issue every 2 weeks. I have gotten the on-line complaint form down, and just send in for a credit. It seems like it's much worse during the winter, and that is supposed to be due to airline issues getting it to Salt Lake. However, I seem to miss quite a few issues all year long anyway. At 09:40 AM 3/4/01 -0600, you wrote: >In the 9 months I have subscribed I have never had even one week where all >my IBD issues arrived on time. 1 or 2 issues are always late. IBD says >it's my post office. My post office says it's the distribution point. >Anyone who is not having this problem? > >--Patti > >----- Original Message ----- >From: "Ann Hollingworth" <annholly@mediaone.net> >To: <canslim@lists.xmission.com> >Sent: Saturday, March 03, 2001 4:53 PM >Subject: RE: [CANSLIM] Worth thinking about > > >> I subscribe to IBD, but my Friday issue didn't arrive. Is there any way to >> go back to the Fri. issue on the website? >> >> Ann Hollingworth >> Reading Recovery Teacher >> Massachusetts >> >> -----Original Message----- >> From: owner-canslim@lists.xmission.com >> [mailto:owner-canslim@lists.xmission.com]On Behalf Of Bill Triffet >> Sent: Saturday, March 03, 2001 3:19 PM >> To: canslim@lists.xmission.com >> Subject: Re: [CANSLIM] Worth thinking about >> >> Ton, >> >> Well then maybe there's hope! (g) >> In Fridays Investors Corner the topic was, " Earnings Don't Add Up As >Market >> Indicator". Goes on to say in 1990 earnings fell from year ago levels. But >> (and a big but IMHO), investor bearish sentiment shot up to 56%. I realize >> this may mean nothing in todays fast paced markets or could be somthing. I >> don't know. >> >> This is all a real learning experience for me. Being a post 1992 investor >I >> have no real experience (unlike those baby faced anylists on tv) with what >a >> real bottom going into a real start of a new bull looks like other than >what >> I read. It will be interesting to see how it unfolds. Will it be a tricle >> out of defensive to high growth or a mad rush? With so much information >> available now it seems that every move is countered with an equal >reversal. >> >> Time will tell... >> >> -Bill Triffet >> >> - >> >> > > >- > > > - - ------------------------------ Date: Tue, 06 Mar 2001 19:33:03 -0700 From: esetser <esetser@covad.net> Subject: Re: [CANSLIM] Late IBD Ben, I believe IBD has a money-back guarantee as far as issues you have not yet received. (I could be wrong, of course) Given that, you should be able to get a refund on the rest of your subscription. At 10:32 PM 3/4/01 -0700, you wrote: > >I am very unhappy with IBD's service. About three months ago, they started >delivery to Western Colorado. Over the last three months, on average, I >received no more then 2-3 papers a week and I would call or submit my >missed deliveries for credit which was always pleasantly given. Apologies >were always offered and calls to the supervisors were always placed. > >Two weeks ago, I had had it and asked Bill to allow me to view the DGO just >until reliable service was in place because the company could not deliver >as promised. He has not had the courtesy to respond to what I think is a >reasonable request considering their poor delivery service. If IBD >personnel are in fact reading this listserv, perhaps they can encourage >better service and responsiveness from the founder of CANSLIM. > >Because of their delivery problems, I've had to request that mail service >be reinstated so at least I'd get the papers two or three days late but get >them. > >Ben Heffer > > > > > > >- > > > - - ------------------------------ Date: Tue, 6 Mar 2001 21:35:54 -0500 From: "Dan Forant" <dforant1@nycap.rr.com> Subject: Re: [CANSLIM] Pitbull Investor / Stocktables.com Works for me. Saves me time searching the IBD paper constantly. Dan F - ----- Original Message ----- From: "canslim" <canslim@twopointfive.com> To: <canslim@lists.xmission.com> Sent: Tuesday, March 06, 2001 4:48 PM Subject: [CANSLIM] Pitbull Investor / Stocktables.com > does anyone out there know anything about Pitbull Investor and > Stocktables.com? > > I know what it is (a service that help people pick canslim stocks but is it > any good? > > bj downes > > - > > - - ------------------------------ Date: Tue, 6 Mar 2001 18:38:21 -0800 From: "Mike Lucero" <mikelu57@hotmail.com> Subject: Re: [CANSLIM] LNCR Huh? I was trying to clarify the definition of the "Funds" number in DGO. What I meant was that if the "Funds" number in DGO is 50%, it means that funds own 50% of the float, not that 50% of all mutual funds own this stock. Mike - ----- Original Message ----- From: "Tom Worley" <stkguru@netside.net> To: <canslim@lists.xmission.com> Sent: Tuesday, March 06, 2001 5:35 PM Subject: Re: [CANSLIM] LNCR > If 50% of the float is owned by funds, it doesn't hold that 50% > of the funds have not invested in it yet. It just means that 50% > of the float is still not owned by funds, but there could still > be a sizable portion of that held by investors through private > placements, counted in the float but not necessarily freely > trading. So the effective liquidity could be even less than 50%. > The more liquidity is reduced, the more the ADV (Average Daily > Volume) declines, the less a fund manager is willing to be > involved, and the less he will commit in monetary terms. And, of > course, the more volatility is likely to increase, making the > chance of a decent base and a predictable entry point that much > harder. > > Tom Worley > stkguru@netside.net > ICQ # 5568838 > > > ----- Original Message ----- > From: Mike Lucero <mikelu57@hotmail.com> > To: <canslim@lists.xmission.com> > Sent: Tuesday, March 06, 2001 1:29 AM > Subject: Re: [CANSLIM] LNCR > > > A quibble is that 50% of funds haven't invested in the stock; 50% > of the > float of the stock is owned by funds. > > Mike > ----- Original Message ----- > From: <Spencer48@aol.com> > To: <canslim@lists.xmission.com> > Sent: Monday, March 05, 2001 6:57 AM > Subject: Re: [CANSLIM] LNCR > > > Tom: > > > > I hadn't fully considered "additional institutional > buying" as being > > necessary to raise the stock price. Thus,since there are so > many funds > > already invested in the stock (50%), it's unlikely, as you put > it, any > more > > funds would invest in it. Thanks for the interesting heads-up. > > > > jans > > > > - > > > > > > - > > > > - > > - - ------------------------------ Date: Tue, 6 Mar 2001 20:45:21 -0600 From: "John Adair" <xjadair@brightok.net> Subject: RE: [CANSLIM] spreadsheet of excel from qp2 data This is a multi-part message in MIME format. - ------=_NextPart_000_000A_01C0A67E.5CD7A3A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by mail2.brightok.net id UAA06674 I don=92t mind sharing the spreadsheet code If some one will tell me how = to cram it into the xmission. I think it would be better if we took it in a stepwise fashion. You have to set up excel to receive the dll file. The sequence is complicated the first time it is used. If you can get to the part you cli= ck on qp2com.xla the complicated part is over. Open excel/tools/addins/browse/qp2data/excel(DON=92T GET CONFUSED HERE YO= U WILL HAVE QP2DATA IN THE LOOKIN BOX/qp2com.xla Now you are setup each time you start thereafter I then open a spreadshee= t in excel /qp2data/excel/ price data.xls Enter the stock you want to evaluate into cell A1 press ENTER and you will immediately get 532 days of data. (If I haven=92t lost everyone ) On= e then is able to add to this spreadsheet and may import any data in qp2 database at the same time. For those hardy souls interested let me know a= nd I will parcel out the additional at intervals. It is really a very different way of looking at stocks from graphs. You get exact numbers an= d percentages and numerical relationships . I feel more comfortable with ex= act numbers and percentages than graphs. I still look at graphs but only afte= r I am satisfied the volume indicates there Is an increasing demand.I am very conscious of woodards =93Rust and Blackspot =93 - -----Original Message----- From: owner-canslim@lists.xmission.com [mailto:owner-canslim@lists.xmission.com]On Behalf Of curtis Sent: Tuesday, March 06, 2001 8:06 PM To: canslim@lists.xmission.com Subject: RE: [CANSLIM] importing from qp2 into excel John; Are you going to share the code or a .xla file? Did you reverse engineer = the O=92Neill .dll functions? Curtis - -----Original Message----- From: owner-canslim@lists.xmission.com [mailto:owner-canslim@lists.xmission.com]On Behalf Of John Adair Sent: Monday, March 05, 2001 10:11 PM To: Canslim@Lists.Xmission.Com Subject: [CANSLIM] importing from qp2 into excel Hi This is a luker for a long time <John> I am developing a spreadsheet using the dll files in quotes plus to down load about 500 days of data on any stock in their database. I import into excel, date, open, hi, lo, close, volume, qrs,. To this data I program the 20 day mov of volume, 50 day mov of volume,% o= ff the 50 day mov of volume. I program the accumulation/dist days based on Oneals formula. I then enter any stock in cell A1of excel and all the data instantly appe= ar. If the volume is not up in all columns. I consider there is not accumulat= ion of this stock and not worth further evaluation. Note the accumulation and the % off hi columns are surprising . I note accumulation for months but = the volume will not be that much up I think I need to rework my formula for this portion. Btw If you haven=92t tried the dll files in quotes plus to download data = into excel you might like it. Actually any piece if data in quotes plus may be imported into excel at the same time. I would send a spreadsheet but I do= n=92t think it would fit In the xmission . I submit this for criticism and comment. - ------=_NextPart_000_000A_01C0A67E.5CD7A3A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 9"> <meta name=3DOriginator content=3D"Microsoft Word 9"> <link rel=3DFile-List href=3D"cid:filelist.xml@01C0A67E.5C4093C0">  <style>  </style> </head> <body lang=3DEN-US style=3D'tab-interval:.5in'> <div class=3DSection1> I = don’t mind sharing the spreadsheet code If some one will tell me how to cram it = into the xmission. I think it would be better if we took it in a stepwise = fashion.<o:p></o:p> You have = to set up excel to receive the dll file. The sequence is complicated the first = time it is used. If you can get to the part you click on qp2com.xla the complicated part = is over.<o:p></o:p> Open = excel/tools/addins/browse/qp2data/excel(DON’T GET CONFUSED HERE YOU WILL HAVE QP2DATA IN THE LOOKIN = BOX/qp2com.xla<o:p></o:p> Now you = are setup each time you start thereafter I then open a spreadsheet in excel = /qp2data/excel/ price data.xls <o:p></o:p> Enter = the stock you want to = evaluate into cell A1 press ENTER = and you will immediately get 532 days of data. (If I haven’t lost everyone = ) One then is able to add to this spreadsheet and may import any data in qp2 = database at the same time. For those hardy souls interested let me know and I will = parcel out the additional at = intervals. It is really a very different way of looking at stocks from graphs. You get exact numbers and = percentages and numerical relationships . I feel more comfortable with exact numbers = and percentages than graphs. I still look at graphs but only after I am = satisfied the volume indicates there Is an increasing demand.I am very conscious = of woodards “Rust and Blackspot = “<o:p></o:p> <![if = !supportEmptyParas]> <![endif]><o:p></o:p><= /p> -----Original Message----- From:</f= ont> owner-canslim@lists.xmission.com [mailto:owner-canslim@lists.xmission.com]On Behalf Of curtis Sent:<fo= nt size=3D2 color=3Dblack face=3DTahoma> Tuesday, March 06, 2001 8:06 PM To:<font= size=3D2 color=3Dblack face=3DTahoma> canslim@lists.xmission.com Subject:= RE: [CANSLIM] importing from qp2 into = excel <![if = !supportEmptyParas]> <![endif]><o:p></o:p> John;<o:p></o:p></fon= t> <![if = !supportEmptyParas]> <![endif]><o:p></o:p><= /p> Are you going to share the code or a .xla file? Did you reverse engineer the O’Neill .dll functions?<o:p></o:p> <![if = !supportEmptyParas]> <![endif]><o:p></o:p><= /p> Curtis<o:p></o:p></fo= nt> <![if = !supportEmptyParas]> <![endif]><o:p></o:p><= /p> -----Original Message----- From:</f= ont> owner-canslim@lists.xmission.com [mailto:owner-canslim@lists.xmission.com]On Behalf Of John Adair Sent:<fo= nt size=3D2 color=3Dblack face=3DTahoma> Monday, March 05, 2001 10:11 PM To:<font= size=3D2 color=3Dblack face=3DTahoma> Canslim@Lists.Xmission.Com Subject:= [CANSLIM] importing from qp2 into excel<o:p></o:p><= /p> <![if !supportEmptyParas]> <![endif]><o:p></o:p> Hi This is a luker for a long time <John><o:p></o:p> I am developing a spreadsheet using the dll files in = quotes plus to down load about 500 days of data on any stock in their database. = I import into excel, date, open, hi, lo, close, volume, = qrs,.<o:p></o:p><= /b> To this data I program the 20 day = mov of volume, 50 day mov of volume,% off the 50 day mov of volume. = <o:p></o:p><= /b> I program the accumulation/dist days = based on Oneals formula.<o:p></o:p> I then enter any stock in cell A1of = excel and all the data instantly appear. If the volume is not up in all columns. I consider there is not accumulation of this stock and not worth further evaluation. Note the accumulation and the % off hi columns are = surprising . I note accumulation for months but the volume will not be that much = up<o:p></o:p><= /b> I think I need to rework my formula = for this portion.<o:p></o:p> Btw If you haven’t tried the = dll files in quotes plus to download data into excel you might like it. Actually any = piece if data in quotes plus may be imported into excel at the same time. I = would send a spreadsheet but I don’t think it would fit In the xmission = .<o:p></o:p><= /b> I submit this for criticism and = comment.<o:p></o:p> </div> </body> </html> - ------=_NextPart_000_000A_01C0A67E.5CD7A3A0-- - - ------------------------------ End of canslim-digest V2 #1183 ****************************** To unsubscribe to canslim-digest, send an email to "majordomo@xmission.com" with "unsubscribe canslim-digest" in the body of the message. For information on digests or retrieving files and old messages send "help" to the same address. Do not use quotes in your message.