Tips on using data to find deals

[Solomon Stavis]

Hello PB community!

Does anyone have any experience using data to identify deal opportunities? Ideally, want I would like to do is download all the houses for sale in a particular zip code and then sort based on home sale price against rent estimate. From there, I could then just search on my own those homes that fall in say the top 20/10 percentile on best buy to rent ratio, for example. I know Zillow has home price and rent estimate data on their webpage but I can't figure out how to download that data to an excel file where I can better analyze it.   Zillow and Redfin both allow you to download their data into excel and Zillow even has an API but all their data is better for analyzing trends in the market since it doesn't allow you to download the individual address per se.

Just wondering if anyone out there who is good with data has any suggestions on how to do this and or how they are using data to funnel deals. 

Thanks!