dvcrofr.com

[Galactic Reversal]

My hubby got his Masters win data science not too long ago. Going to share this with him to blend our two loves!

Awesome! I'm making some upgrades right now to improve performance so if you see anything that looks off just bear with me. Should be done in a few days.

 

[miTnosnhoJ]

Do you have a definition for “Lifetime $ per point”?

 

[Galactic Reversal]

Do you have a definition for “Lifetime $ per point”?

It's just the total cost (initial + annual dues) divided by the total points over the life of the contract (no inflation or discounting). Any available points at purchase are reduced by 50% if <7 months to expiration and 100% if <4 months to expiration.

 

[DarthDadMan]

As a data nerd, I love this. I always thought about finding a way to develop a tool that integrates listings from different brokers. Whether they provided APIs for things this. Great stuff!

 

[Dotluvsdisney]

Awesome! I'm making some upgrades right now to improve performance so if you see anything that looks off just bear with me. Should be done in a few days.

I would never know if anything looks off nor would I bring it up here. Thanks for sharing this!

 

[Cyberc1978]

How is the Disc $/pt and $/pt calculated?

I would assume that the $/pt would be the cost of the contract + closing cost(but excluding annual dues) divided with the remaining points for the life of the contract + annual dues. If there are any banked points how are they valued?

 

[Galactic Reversal]

@Cyberc1978

$/pt is the total cost (initial + annual dues) divided by the total points over the life of the contract (no inflation or discounting). Disc $/pt discounts everything at 5% per annum with some simplifying assumptions (e.g., dues paid on 1st of the year, points are used immediately upon earning them, no dues inflation). Any available points at purchase are reduced by 50% if <7 months to expiration and 100% if <4 months to expiration.

 

[Cyberc1978]

@Cyberc1978

$/pt is the total cost (initial + annual dues) divided by the total points over the life of the contract (no inflation or discounting). Disc $/pt discounts everything at 5% per annum with some simplifying assumptions (e.g., dues paid on 1st of the year, points are used immediately upon earning them, no dues inflation). Any available points at purchase are reduced by 50% if <7 months to expiration and 100% if <4 months to expiration.

Thanks

When I take my string: Cyberc1978---$81-$15006-160-SSR-Jun-0/22, 272/23, 160/24- sent 4/5, passed 5/8 I see that Disc $/pt and $/pt listed as:

12.70

10.40

How do you come to that?

Total cost = $15,006
Total points over the life if the contract (2053 - 2023 * 160) = 4800

When I try to calculate it: total cost including dues / total points:15006 divided with 4800 = $3.13

If I add the annual dues: 3.13 + 7.86 = $10.99

How do I take the extra 112 points into account?

What am I missing or doing wrong?

 

[Galactic Reversal]

Thanks

When I take my string: Cyberc1978---$81-$15006-160-SSR-Jun-0/22, 272/23, 160/24- sent 4/5, passed 5/8 I see that Disc $/pt and $/pt listed as:

12.70

10.40

How do you come to that?

Total cost = $15,006
Total points over the life if the contract (2053 - 2023 * 160) = 4800

When I try to calculate it: total cost including dues / total points:15006 divided with 4800 = $3.13

If I add the annual dues: 3.13 + 7.86 = $10.99

How do I take the extra 112 points into account?

What am I missing or doing wrong?

You're almost there. A couple things:

1. Subtracting 2053 - 2023 will give you the number of years between 2023 and 2053, but you're missing the 2023 points. So the total points are 4800 + 272 = 5072.
2. Calculating the $/point without dues and then adding the dues/yr rate makes the implicit assumption that there are 160 points available for all years, but you've got 272 points in 2023. You need to adjust the $7.86 by (4800/5072) to get $7.44

IMO it's easier to just add all the costs and divide by all the points:
(15006 + 1257.6 * (2053 - 2023)) / (272 + 160 * (2053 - 2023))
= 52734 / 5072
= 10.40

 

[CVG]

Super work. Quick question. Apologies if it's been asked before.

I saw a contract with https://www.fidelityrealestate.com/. It has half its current year points available. The listing shows the full year annual dues (presume it does this in every case?). And the pricing tool picks up this full amount as part of the Buyer Costs.

However, any right-minded disboarder would only pay the proportion of the dues (half) as a maximum. Am I missing something or making a mistake here? Thanks.

 

[CVG]

Tongue in cheek request: On the resale listings could you add a broker exclusion filter?

 

[sab53085]

Great work! Any way you can add an option to sort by Date Listed and possibly modifying the "Resort" filter to allow more than one resort?

 

[Sandisw]

Super work. Quick question. Apologies if it's been asked before.

I saw a contract with https://www.fidelityrealestate.com/. It has half its current year points available. The listing shows the full year annual dues (presume it does this in every case?). And the pricing tool picks up this full amount as part of the Buyer Costs.

However, any right-minded disboarder would only pay the proportion of the dues (half) as a maximum. Am I missing something or making a mistake here? Thanks.

I do think that this late in the year most people here would negotiate dues for less due to those being based on calendar year.

But, my guess is the tool is designed to take the approach that most resale companies die and that is buyers pay full dues if getting full points for the UY that matches the calendar year.

 

[Galactic Reversal]

Super work. Quick question. Apologies if it's been asked before.

I saw a contract with https://www.fidelityrealestate.com/. It has half its current year points available. The listing shows the full year annual dues (presume it does this in every case?). And the pricing tool picks up this full amount as part of the Buyer Costs.

However, any right-minded disboarder would only pay the proportion of the dues (half) as a maximum. Am I missing something or making a mistake here? Thanks.

Thanks! When populating the pricing tool, it first uses whatever the broker lists as the dues. If they don't specify, then it calculates dues based on the points available in the current and next year. I designed it that way thinking the broker would have the best info, but maybe I should just calculate them for everything.

 

[CVG]

I do think that this late in the year most people here would negotiate dues for less due to those being based on calendar year.

But, my guess is the tool is designed to take the approach that most resale companies die and that is buyers pay full dues if getting full points for the UY that matches the calendar year.

Just to be clear, I wasn't thinking about timing - the amount of time left in the use year (that's another issue!). I was just looking at a, say, 200 point contract with only 100 points available in the current use year, i.e. 100 previously used or borrowed. I'm only prepared to consider paying half the dues for the current years points.

 

[Galactic Reversal]

Great work! Any way you can add an option to sort by Date Listed and possibly modifying the "Resort" filter to allow more than one resort?

Thanks! Yes #1 is in the pipeline, but not many listings include list date so I have to rely on pulling at regular intervals and keeping track of what's new. The resort filter should be multi-select. If it's not working for you please let me know what browser you're using and I will look into it.

 

[sab53085]

Ah yes it is multi-select! Thanks again.

 

[CVG]

Ah yes it is multi-select! Thanks again.

Yes, the same is true for the brokers, but it's time consuming to select 6 or 7 in order to exclude 1!

 

[CVG]

Thanks! When populating the pricing tool, it first uses whatever the broker lists as the dues. If they don't specify, then it calculates dues based on the points available in the current and next year. I designed it that way thinking the broker would have the best info, but maybe I should just calculate them for everything.

Yep, I'd just pro-rata the annual payable dues based on the ratio of available current year points to full use year points.

I don't think you can do much about the timing issue. You'd have to leave that to individual negotiations.

 

[Headless Horseman]

Awesome site! Any chance to get a Best of 2022, 2021, etc? I want to see how poorly I did with my first contract! These tools are great for new buyers.