Skip to content
×
PRO
Pro Members Get Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. Cancel anytime
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Real Estate Deal Analysis & Advice
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated almost 9 years ago,

Account Closed
  • Accountant
  • Collegeville, PA
25
Votes |
105
Posts

Macros to make ARV analysis more efficient!

Account Closed
  • Accountant
  • Collegeville, PA
Posted

Hi Everyone -

In an effort to determine ARV on a potential fix and flip in an efficient manner, I've asked my r/e agents to send me data extracts from the MLS on the comps. This allows me to avoid manually typing in the information (sold price, concessions, beds, baths, sq ft etc.) for each property into excel. This has saved me significant amount of time.

What I would like to do now is create some sort of macro that can take such information and automate various formatting and calculation functions (based own my own assumptions) to calculate the ARV estimate (something similar to what an appraisal calculation would look like, where the address is presented horizontally, and the inputs vertically starting with the sale price and making adjustments between the subject property and the comps).

I tried doing the "Record Macro" function in excel but Excel gets confused easily. For example, the macro was built recording an analysis I did with 4 comps. If I try to use the macro for an analysis with 5 comps, it doesn't pick up the extra comp. 

Is there any kind of (legitimate) add-in that can do the above? If not, are there any programmers out there that could assist me?

Any assistance would be greatly appreciated.

Thanks!

Loading replies...