| Help - Frequently Asked
Questions |
-Why is the "Date" field missing or
garbled when I try to import the data?
-What does the "Adjusted Close" field indicate?
-What does the "Percentage Change" field indicate?
-Does your data account for stock splits?
|
-What Indecis are included in your Indices
database?
-Do you provide minute by minute intraday data?
-Do you guarantee your databases to be 100% accurate?
|
Why is the date field missing or garbled when I import the data?
The date format used in these files is Year-Month-Day i.e. 2000-12-30. This
needs to be specified in certain software for dates to import correctly.
|
What does the "Adjusted Close" field indicate? Does your data
account for stock splits?
Adjusted Close provides the closing price for the requested day, week,
or month, adjusted for all applicable splits and dividend distributions. Data
is adjusted using appropriate split and dividend multipliers, adhering to
Center for Research in Security Prices (CRSP) standards. Split
multipliers are determined by the split ratio. For instance, in a 2 for 1
split, the pre-split data is multiplied by 0.5. Dividend multipliers are
calculated based on dividend as a percentage of price, primarily to avoid
negative historical pricing. For example, when a $0.08 cash dividend is
distributed on Feb 19 (ex-date), and the Feb 18 closing price was 24.96, the
pre-dividend data is multiplied by (1-0.08/24.96) = 0.9968. Below is a detailed
example of adjusted close calculations.
Example: Adjusted Close Calculations
2/13/03 Close = 46.99
2/14/03 Close = 48.30
2/18/03 Split = 2:1
2/18/03 Close = 24.96
2/19/03 Cash Dividend = 0.08 (ex-date)
2/19/03 Close = 24.53
Split Multiplier = 0.5
Dividend Multiplier = 1 - (0.08/24.96) = 0.9968
2/13/03 Adj. Close = 0.5 * 0.9968 * 46.99 = 23.42
2/14/03 Adj. Close = 0.5 * 0.9968 * 48.30 = 24.07
2/18/03 Adj. Close = 0.9968 * 24.96 = 24.88
2/19/03 Adj. Close = 24.53
|
What does the "Percentage Change" field indicate?
The Percentage Change field is the percentage of Adjusted Close change
by trading day.
Example:
LOJN 1999-05-03 Adjusted Close = $7.75
LOJN 1999-05-04 Adjusted Close = $8.06
100(8.06 / 7.75) - 100 = 4% The adjusted close was up 4% from the last trading
day.
LOJN 1999-05-04 Adjusted Close = $8.06
LOJN 1999-05-05 Adjusted Close = $7.75
100(7.75 / 8.06) - 100 = -3.85% The adjusted close was down 3.85% from the last
trading day.
|
What Indices are included in the Indices database?
You can view the included Indices here:
http://www.bigdbs.com/INDEXLIST.ASP. |
Do you provide minute by minute intraday data?
At this time we sell end of day data and have no plans to add an intraday
product. |
Do you guarantee your databases to be 100% accurate?
The information provided in all BigDBs databases is accurate to the best of our
knowledge. Even though great care has been taken to ensure accuracy BigDBs
makes no warranties about the accuracy or completeness of any information
contained in the databases. However, all of our products come with a 100%
Satisfaction Guarantee. If you are not completely satisfied with a
purchase from BigDBs, you may return it for a full refund, no questions asked. |
|