Author Topic: Quarter end skew  (Read 10385 times)

lascott

  • Hero Member
  • *****
  • Posts: 1423
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Quarter end skew
« Reply #15 on: August 10, 2015, 02:25:15 AM »
... in progress ... need to rebuild graph below ...
Nice.  Didn't know that you can do this with Google Calendar.  Good to know!
Just to keep the discussion around payment, could you also graph payment (instead of payoff) vs day-of-week?
I corrected it. I meant to do payments ("Actual amount") in the first place and accidentally did payoffs. Keep manipulating my spreadsheet as I was playing.

BTW, I had know idea you could do this either. I just started playing with it a few hours ago after doing searches for calendar and charts/graphs.
« Last Edit: August 10, 2015, 02:29:30 AM by lascott »
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

Fred

  • Hero Member
  • *****
  • Posts: 1421
    • View Profile
Re: Quarter end skew
« Reply #16 on: August 10, 2015, 02:29:00 AM »
Try to change your x-axis to day-of-week (Mon-Sun).  My account shows large payments on Thursdays.
...

Mine too.

Thanks.  Looks like BruiserB theory is right.

Now off we go to implement a "bang-hard-on-weekend" strategy. ;-)
« Last Edit: August 10, 2015, 02:32:11 AM by Fred »

lascott

  • Hero Member
  • *****
  • Posts: 1423
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Quarter end skew
« Reply #17 on: August 10, 2015, 02:35:30 AM »
A shockingly large amount of money popped into my account today.  Do you understand what caused this?

Thursdays are always the highest payment day since LC credits the money to our accounts 3 business days after they withdraw it from the payers' accounts.  They don't take money from the payer until Monday if the payment due date fell over the weekend.  So Thursdays' payments are always made up of payments that were due on the previous Saturday, Sunday and Monday. <snip>
To your underlined point, look at Memorial day.

Image: http://i.imgur.com/pMK3BPM.png
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

lascott

  • Hero Member
  • *****
  • Posts: 1423
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Quarter end skew
« Reply #18 on: August 10, 2015, 10:39:01 AM »
I wonder why people select those payment dates.  Maybe a lot of people get paid in the middle of the month?

My calendar also visually shows that as well (just past middle point of month is biggest payment week).

Image: http://i.imgur.com/BMB5bna.png
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

BruiserB

  • Sr. Member
  • ****
  • Posts: 418
    • View Profile
Re: Quarter end skew
« Reply #19 on: August 10, 2015, 01:53:52 PM »
I wonder why people select those payment dates.  Maybe a lot of people get paid in the middle of the month?

My calendar also visually shows that as well (just past middle point of month is biggest payment week).

Image: http://i.imgur.com/BMB5bna.png


Yes, when there are holidays on Monday, we get the big payout on Friday and it is a combined payment of loans that were due on on the previous Saturday, Sunday, Monday and Tuesday.  A Friday holiday causes a larger payout on Thursday as you get loans that were due on the previous Friday, Saturday, Sunday and Monday.

What happens to loans with payment dates of the 31st?  Do these get collected on the 30th in short months, or on the following 1st?  The end of February should generate a large payment as well since loans that come due on 29th, 30th and 31st will either get collected on the 28th or on the 1st of March. (EDIT: Just looked back and the 28th of Feb and 1st of March fell over a Saturday/Sunday this year....hence why your first Thursday in March payment was larger than the one later in the month)
« Last Edit: August 10, 2015, 01:57:55 PM by BruiserB »

BruiserB

  • Sr. Member
  • ****
  • Posts: 418
    • View Profile
Re: Quarter end skew
« Reply #20 on: August 10, 2015, 02:03:31 PM »
I noticed the Thursday big payment thing a while back and it always kind of irked me.  We get the big payout after the last note drop on Thursday, so we only get a chance to re-invest it on Friday with normal loan activity.  Loans seem to usually drop off over the weekend, so it often takes me until the following Tuesday/Wednesday to get caught up on re-investing.

BruiserB

  • Sr. Member
  • ****
  • Posts: 418
    • View Profile
Re: Quarter end skew
« Reply #21 on: August 10, 2015, 02:18:30 PM »
I wonder why people select those payment dates.  Maybe a lot of people get paid in the middle of the month?

I had one employer that paid on the 1st and 15th of the month, so I imagine there are a few like that out there.  Mortgage and rent payments are almost always due on the 1st of the month, so, personally, I try to stagger out my other payments the rest of the month if possible.

My company pays bi-monthly on 14th and day before last day of month (29th or 30th...or 27th in February!).  It works well when my main credit card has a due date in the second half of the month so that mortgage gets covered with the end of month paycheck and credit card gets covered with mid month paycheck.  So I can imagine that's why some LC loan holders ask to move their due date to the second half of the month.

lascott

  • Hero Member
  • *****
  • Posts: 1423
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Quarter end skew
« Reply #22 on: August 10, 2015, 11:10:22 PM »
<snip>
What happens to loans with payment dates of the 31st?  Do these get collected on the 30th in short months, or on the following 1st?  The end of February should generate a large payment as well since loans that come due on 29th, 30th and 31st will either get collected on the 28th or on the 1st of March. (EDIT: Just looked back and the 28th of Feb and 1st of March fell over a Saturday/Sunday this year....hence why your first Thursday in March payment was larger than the one later in the month)

Thanks for the added info. Yes, I see in Feb and July that the last day of the month was on a Friday ... then the next months 1st Thur is a big payout.

February also had Presidents' Day in it so it shows a large payout on Friday that week. That is your point about the 3 business days.

Added as much as February as I could since I could only go back 6 months using my current method.
Image: http://i.imgur.com/QCMPNDk.png
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

lascott

  • Hero Member
  • *****
  • Posts: 1423
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Quarter end skew
« Reply #23 on: August 11, 2015, 06:49:09 AM »
My previous charts (and the quoted one) are a percentage (0-100%) and each months max is used for each day within that month to determine the shade -- hence the title: % monthly payment by day

The bottom chart below is simply by payment. I am still investing in this account but to the OPs point the Aug payment was quite a bit bigger than previous ones. See the red arrow.

Image: http://i.imgur.com/QCMPNDk.png


Image: http://i.imgur.com/0kq11M0.png
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

lascott

  • Hero Member
  • *****
  • Posts: 1423
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Quarter end skew
« Reply #24 on: November 01, 2015, 05:04:07 PM »
Got around to updating my spreadsheet and google calendar HTML page. New quarter was a big "payday".

Taxable --
Image: http://i.imgur.com/B0YbVZ8.png


ROTH --
Image: http://i.imgur.com/qudyn10.png
« Last Edit: November 01, 2015, 05:05:55 PM by lascott »
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

lascott

  • Hero Member
  • *****
  • Posts: 1423
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Quarter end skew
« Reply #25 on: January 09, 2016, 07:00:11 PM »
Note: Thur 1/7/2016 was a very big payment.

Got around to updating my spreadsheet and google calendar HTML page. Here is how holidays looked on the calendar for my two account (new (ROTH) and old (Taxable)).

Taxable --
Image: http://i.imgur.com/jBIjlqH.png


ROTH --
Image: http://i.imgur.com/YM2fxm2.png
« Last Edit: January 13, 2016, 04:19:29 PM by lascott »
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y