Quotes plus keeps raw data that reflects price and volume pre split. From the excel help file is the following which is self descriptive.
Raw Price Functions The Raw functions return the unsplit adjusted values. QP_RawOpen(day As Integer, symbol As String) Returns the Open for the day that you choose. QP_RawHigh(DayNumber As Integer, symbol As String) Returns the High for the day that you choose. QP_RawLow(DayNumber As Integer, symbol As String) Returns the Low for the day that you choose. QP_RawClose(DayNumber As Integer, symbol As String) Returns the Close for the day that you choose. QP_RawVolume(DayNumber As Integer, symbol As String) Returns the Volume for the day that you choose. QP_RawOI(DayNumber As Integer, symbol As String) Returns the Open Interest for the day that you choose. QP_RawDate(DayNumber As Integer, symbol As String) Returns the Date for the day that was passed. Charles _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Dugas Sent: Wednesday, September 10, 2008 11:00 AM To: [email protected] Subject: Re: [quotes-plus] quotes plus split adjustments Hi Howard - I have wondered in the past just exactly what their policy is for dividend adjustments. My impression is that they generally adjust for larger dividends, perhaps around 5% or more, but not for smaller ones. Would you happen to know exactly what their policy is? Are the adjustments generally made by QP or their supplier? Thanks very much! another Steve ----- Original Message ----- From: "Howard Hansen" <[EMAIL PROTECTED] <mailto:hrhan%40att.net> > To: <quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com> Sent: Tuesday, September 09, 2008 6:23 PM Subject: Re: [quotes-plus] quotes plus split adjustments > Steve, > > The share price is adjusted for splits and stock dividends. For example > a 2 for 1 stock split means all historical share prices prices prior to > the split are divided by 2. > > An historical record of the divisor used to adjust the stock prices of > each stock is kept in the SMaster.qpf Access database file. As reported > by Gary a while back the data in this file can be viewed with > Microsoft's Access program. Hence if you own a copy of Access you can > use the divisor data to verify historical share price data has been > corrected for splits and dividends. > > Howard > > xxnospamxx wrote: >> >> Could someone describe how the quotes plus historical data is adjusted >> for splits and dividends? >> >> One of my system rules is to exclude stocks with low liquidity. I want >> to be sure the rules will work correctly on adjusted historical data. >> >> Thanks, >> Steve >> >> > > > ------------------------------------ > > Yahoo! Groups Links > > > > No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.19/1662 - Release Date: 9/9/2008 10:47 AM
