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

[amibroker] Re: Amiquote data downloads



PureBytes Links

Trading Reference Links

Steve,
If you download[today] MSFT from 1996 till now, you will read, for 
Dec6, 1996 C=152.88.
The adjusted value for the same date is 9.56.
Dimitris Tsokakis
--- In amibroker@xxxxxxxxxxxxxxx, "Steve Almond" <steve2@xxxx> wrote:
> Hmmm, I guess I started at the wrong end. I was assuming that MSFT 
(started
> at $28, as your article shows) if unadjusted for splits would now 
be $28 *
> 144 = $4032 .
> 
> 
> Steve
> 
> MSFT  is STILL at $28 after 17 years! (although we have 144 times 
as many
> shares......).
> 
> 
> 
> 
> 
> 
> ----- Original Message ----- 
> From: "Tomasz Janeczko" <amibroker@xxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Thursday, September 18, 2003 09:05
> Subject: Re: [amibroker] Amiquote data downloads
> 
> 
> > Steve,
> >
> > > If unadjusted prices are now given, will MSFT be a $1000 stock? 
It
> doesn't
> > > seem to be on the Yahoo! pages I see.
> >
> > Of course not. Prices downloaded by AmiQuote are the same as new 
Yahoo
> shows.
> > There is no difference. Just download using AmiQuote and you will 
see that
> there is NO difference for current quote.
> >
> > There is NO difference in ***current*** price between 
adjusted/unadjusted.
> >
> > The difference is for OLD data.
> >
> > Unadjusted means that OLD data ( BEFORE SPLIT) -
> > are left in ORIGINAL levels (exactly as they were traded then).
> >
> > Unadjusted are simply ORIGINAL prices, NOT MODIFIED in any way.
> >
> > Adjusted historical data are modified.
> >
> > From Yahoo help pages:
> > http://help.yahoo.com/help/us/fin/quote/quote-12.html
> >
> > Adjusted close provides the closing price for the requested day, 
week, or
> month, adjusted for all applicable splits and dividend
> > distributions. Data ***prior*** to the split is adjusted using a
> multiplier determined by the split ratio. Data prior to the
> > dividend is adjusted using a multiplier based on dividend as a 
percentage
> of price.
> >
> > Also from:
> > http://www.fool.com/foolu/askfoolu/2001/askfoolu010703.htm
> >
> > "What may be confusing you is their "split-adjusted" price. When 
a stock
> splits, historical quote services and charts split the past
> > prices as well so that it doesn't look like the stock just 
dropped 50%.
> Split adjustments are a convenient way to illustrate the
> > relationship between current price and historical performance, 
but they
> don't give you a true historical price. If a stock has split
> > a number of times, the initial price can get down to pennies when 
split
> adjusted. But that doesn't mean that it ever actually sold
> > for pennies.
> > For example, Microsoft went public on March 13, 1986 and closed 
at $28,
> but the split-adjusted price you will see on a chart or in
> > historic quotes is $0.19. That's because it has split so often 
that a
> single share purchased on March 13, 1986 would have turned
> > into 144 shares by today. Cisco has split even more. An original 
share of
> Cisco has turned into 288 shares. The closing price on the
> > day of Cisco's IPO on February 16, 1990 was $22.25, but the split-
adjusted
> price was $0.08. Neither Microsoft nor Cisco ever sold
> > for much less than their IPO prices."
> >
> >
> > Best regards,
> > Tomasz Janeczko
> > amibroker.com
> > ----- Original Message ----- 
> > From: "Steve Almond" <steve2@xxxx>
> > To: <amibroker@xxxxxxxxxxxxxxx>
> > Sent: Thursday, September 18, 2003 9:44 AM
> > Subject: Re: [amibroker] Amiquote data downloads
> >
> >
> > > Tomasz,
> > >
> > >
> > > Steve
> > >
> > >
> > > ----- Original Message ----- 
> > > From: "Tomasz Janeczko" <amibroker@xxxx>
> > > To: <amibroker@xxxxxxxxxxxxxxx>
> > > Sent: Wednesday, September 17, 2003 22:29
> > > Subject: Re: [amibroker] Amiquote data downloads
> > >
> > >
> > > > Steve,
> > > >
> > > > So called "new" yahoo changed in fact 2 things when it comes
> > > > to "Download spreadsheet link" that AmiQuote uses:
> > > > 1. UNADJUSTED quotes are now given (previously were split 
adjusted)
> > > > 2. New column "adj. close" has been added
> > > >
> > > > AmiQuote is still at 1.55 but it works OK with 'new Yahoo'
> > > > with one difference that quotes are now NOT adjusted for 
splits.
> > > >
> > > > New 'adj. close' column is simply ignored by AQ 1.55.
> > > > New version of AQ or AmiBroker (I have not yet decided
> > > > where to handle this) will make the use of 'adj. close' 
column.
> > > >
> > > > Best regards,
> > > > Tomasz Janeczko
> > > > amibroker.com
> > > > ----- Original Message ----- 
> > > > From: "Steve Almond" <steve2@xxxx>
> > > > To: <amibroker@xxxxxxxxxxxxxxx>
> > > > Sent: Wednesday, September 17, 2003 11:17 PM
> > > > Subject: Re: [amibroker] Amiquote data downloads
> > > >
> > > >
> > > > > Tomasz,
> > > > >
> > > > > Is Amiquote now fully compatible with the "new" Yahoo! data?
> > > > >
> > > > > Steve
> > > > >
> > > > >
> > > > > ----- Original Message ----- 
> > > > > From: "Tomasz Janeczko" <amibroker@xxxx>
> > > > > To: <amibroker@xxxxxxxxxxxxxxx>
> > > > > Sent: Wednesday, September 17, 2003 22:06
> > > > > Subject: Re: [amibroker] Amiquote data downloads
> > > > >
> > > > >
> > > > > > Hello,
> > > > > >
> > > > > > There is no limit in AmiQuote.
> > > > > >
> > > > > > In the past however it happened that Yahoo blocked
> > > > > > the person who downloaded too much for 20 minutes.
> > > > > >
> > > > > > Increasing time between requests to 1 second helps in such
> situations.
> > > > > > see http://www.amibroker.com/troubleshooting.html
> > > > > >
> > > > > >
> > > > > > Best regards,
> > > > > > Tomasz Janeczko
> > > > > > amibroker.com
> > > > > > ----- Original Message ----- 
> > > > > > From: "garyhw_98" <garyhw_98@xxxx>
> > > > > > To: <amibroker@xxxxxxxxxxxxxxx>
> > > > > > Sent: Wednesday, September 17, 2003 6:38 PM
> > > > > > Subject: [amibroker] Amiquote data downloads
> > > > > >
> > > > > >
> > > > > > > I am thinking of purhasing a licenses for AmiQuote.  
Before I
> do, I
> > > > > > > have a few questions.  Is there a limit on the number 
of stocks
> you
> > > > > > > can download? And, Is their a limit on the time period? 
In
> essence
> > > > > > > can you down load price and volume figures for every 
stock in
> the
> > > > > > > NYSE, NASDAQ and AMEX stock over the past 5 years?
> > > > > > >
> > > > > > >
> > > > > > > Thanks
> > > > > > >
> > > > > > > Gary
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Send BUG REPORTS to bugs@xxxx
> > > > > > > Send SUGGESTIONS to suggest@xxxx
> > > > > > > -----------------------------------------
> > > > > > > Post AmiQuote-related messages ONLY to: 
amiquote@xxxxxxxxxxxxxxx
> > > > > > > (Web page: 
http://groups.yahoo.com/group/amiquote/messages/)
> > > > > > > --------------------------------------------
> > > > > > > Check group FAQ at:
> > > > > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > > > > > >
> > > > > > > Your use of Yahoo! Groups is subject to
> > > > > http://docs.yahoo.com/info/terms/
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > Send BUG REPORTS to bugs@xxxx
> > > > > > Send SUGGESTIONS to suggest@xxxx
> > > > > > -----------------------------------------
> > > > > > Post AmiQuote-related messages ONLY to: 
amiquote@xxxxxxxxxxxxxxx
> > > > > > (Web page: 
http://groups.yahoo.com/group/amiquote/messages/)
> > > > > > --------------------------------------------
> > > > > > Check group FAQ at:
> > > > > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > > > > >
> > > > > > Your use of Yahoo! Groups is subject to
> > > http://docs.yahoo.com/info/terms/
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > Send BUG REPORTS to bugs@xxxx
> > > > > Send SUGGESTIONS to suggest@xxxx
> > > > > -----------------------------------------
> > > > > Post AmiQuote-related messages ONLY to: 
amiquote@xxxxxxxxxxxxxxx
> > > > > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > > > > --------------------------------------------
> > > > > Check group FAQ at:
> > > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > > > >
> > > > > Your use of Yahoo! Groups is subject to
> > > http://docs.yahoo.com/info/terms/
> > > > >
> > > > >
> > > > >
> > > >
> > > > Send BUG REPORTS to bugs@xxxx
> > > > Send SUGGESTIONS to suggest@xxxx
> > > > -----------------------------------------
> > > > Post AmiQuote-related messages ONLY to: 
amiquote@xxxxxxxxxxxxxxx
> > > > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > > > --------------------------------------------
> > > > Check group FAQ at:
> > > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > > >
> > > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > Send BUG REPORTS to bugs@xxxx
> > > Send SUGGESTIONS to suggest@xxxx
> > > -----------------------------------------
> > > Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> > > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > > --------------------------------------------
> > > Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> >
> >
> >
> > Send BUG REPORTS to bugs@xxxx
> > Send SUGGESTIONS to suggest@xxxx
> > -----------------------------------------
> > Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > --------------------------------------------
> > Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> >
> > Your use of Yahoo! Groups is subject to 
http://docs.yahoo.com/info/terms/
> >
> >
> >
> >


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Remanufactured Ink Cartridges & Refill Kits at MyInks.com for: HP $8-20. Epson $3-9, Canon $5-15, Lexmark $4-17. Free s/h over $50 (US & Canada).
http://www.c1tracking.com/l.asp?cid=6351
http://us.click.yahoo.com/0zJuRD/6CvGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/