- Find a Real Estate Professional
- Realtors®
- Mortgage Lenders
- Home Improvement Pros
- Other Real Estate Services
- Review an Agent, Lender or Pro
- Marketing on Zillow
- Real Estate Agent Advertising
- Join the Professional Directory
- Popular
- Real Estate Market Reports
- More
Answers (1)
- Pasadenan
- Contributions:21453
I had asked a similar question earlier...
Two things showed up that I had previously missed:
1) No sales data showed in the excel as "blank", not "0". And I had assumed "0", which is not at all the same as "no data". On the charts on the local info pages, the graph shows extrapolation between the known data points; not going down to 0.
2) Round off error. The default on the Excel file didn't have enough decimal places shown, thus I was "assuming" zero when the data wasn't zero at all.
Once I corrected for these two items, the excel produced chart matched the website chart. Also, one needs to remember the charts on the local info pages usually have the "X" axis shifted up. In other words, zero is not the lowest point shown on the "Y" axis.
Also, date of download may affect ones results. Zillow updates their data as often as they can get new county record data. So previous downloaded data may not have been complete, or may have had discrepancies someone found that have since been corrected.
(I should also mention the Excel files go back about 14 years while the chart on the local info page can only go back 10 years).
Two things showed up that I had previously missed:
1) No sales data showed in the excel as "blank", not "0". And I had assumed "0", which is not at all the same as "no data". On the charts on the local info pages, the graph shows extrapolation between the known data points; not going down to 0.
2) Round off error. The default on the Excel file didn't have enough decimal places shown, thus I was "assuming" zero when the data wasn't zero at all.
Once I corrected for these two items, the excel produced chart matched the website chart. Also, one needs to remember the charts on the local info pages usually have the "X" axis shifted up. In other words, zero is not the lowest point shown on the "Y" axis.
Also, date of download may affect ones results. Zillow updates their data as often as they can get new county record data. So previous downloaded data may not have been complete, or may have had discrepancies someone found that have since been corrected.
(I should also mention the Excel files go back about 14 years while the chart on the local info page can only go back 10 years).
Graph data points don't agree to excel worksheet points
Scott Sheaffer
ssheaffer@johnsonbank.com
Stating a discriminatory preference in an advertisement for housing is illegal. If you think this content is discriminatory or otherwise inappropriate and feel it should be removed from Zillow, please let us know by completing the information above.
We will review this content. Thanks for helping make the site more useful to everyone. To learn more, read Zillow's Good Neighbor Policy.