cancel
Showing results for 
Search instead for 
Did you mean: 

Clean/Thin/Young..ish/New Account DPs

Highlighted
Super Contributor

Re: Clean/Thin/Young..ish/New Account DPs


@GoNavy wrote:

@Birdman7  Ok, got it.  I had been listing young..ISH as I understood TU and EX to be young at 6 months history and EQ is the ish part as it is aged.  EQ is the only bureau still listing the account that is 27 years since originally opened (closed 2014).  Wasn’t really sure what to consider or describe profile as a whole.  I can tend to overthink things.🤦‍♀️  

 

I’m not sure of the exact formula how to manually calculate AAoA....probably pretty simple, but need help here.  If you have time to point me to a thread explaining this or even if you have a template I can plug the info in I can do?


@GoNavy You are mature because your oldest account is over 3 years as far as version 8 is concerned.


Having a revolver less than 12 months of age affects the last segmentation point, new account or no new account.

 

To calculate your AAoA, get the opening date for every account on each CR. (it may be different at each bureau.) take every opening date and change it to the first of the month, no matter what day of the month it is.

 

Start with one bureau and for each account, calculate how many months from the opening date to the first of this month. Once you have the age in months for each account, add them all together and then divide the sum by the number of accounts. That will give you your AAoA for that bureau. Repeat for the other two bureaus.

 

The same is true for AAoRA and AAoIA, But for those metrics you exclude  non-revolvers and non-loans respectively.

 

@CassieCard should we make a chart/table for aging?

 

@AllZero could be a decent macro?

For a collection of our current FICO scoring wisdom, updated as we learn, read the following. Watch the revision dates on the bottom of the first 8 posts as they are regularly updated: Link to Scoring Primer.


RIP:

Oldest/average age varies by bureau. Estimates above.


Updated Oct 2020, unless otherwise noted.

(Forgive typos, mobile.)(Everything said is Just IMHO.)

In order to better answer your questions and record your DPs, please provide your profile stats: Any baddies? Severity and recency? (clean/dirty), Number of accounts, both open and closed on CRs (thick/thin), AoOA? (Mature/young), AOYRA-Age of Youngest Revolving Account (new accounts/no new accounts)? Open/closed loan on CR?
For example, mine is clean/thick/mature/new account, with open loan on record.
If you don't know where you fall, just detail any baddies, your number of open and closed accounts, AoOA, AOYRA and whether you have a loan on record to start.

For utilization questions, list individual and aggregate utilizations, revolving and installment, please.
Message 31 of 73
Highlighted
Valued Contributor

Re: Clean/Thin/Young..ish/New Account DPs


@Birdman7 wrote:

@CassieCard should we make a chart/table for aging?

Did you mean a table with 9 aging values? Normal, Revolving, and Installment? That's a good idea.

 

I already have a macro to insert the usual 6 aging metrics. Easy to add another row.

27 FICO Scores + 3 VS3. MTG (Mortgage), AUT (Auto), and BKC (Bankcard) are scores 5,4, and 2 from the top.

Keeper of the Scrolls of ResilienceEQ FICO Resilience Index Score Leaderboard

46 forum members have shared this new credit score. Share yours today!

Message 32 of 73
Highlighted
Super Contributor

Re: Clean/Thin/Young..ish/New Account DPs

@CassieCardI mean a chart with instructions on how to calculate those values, but the table sounds awesome too!

 

Unless the macro calculates ages and displays them?

For a collection of our current FICO scoring wisdom, updated as we learn, read the following. Watch the revision dates on the bottom of the first 8 posts as they are regularly updated: Link to Scoring Primer.


RIP:

Oldest/average age varies by bureau. Estimates above.


Updated Oct 2020, unless otherwise noted.

(Forgive typos, mobile.)(Everything said is Just IMHO.)

In order to better answer your questions and record your DPs, please provide your profile stats: Any baddies? Severity and recency? (clean/dirty), Number of accounts, both open and closed on CRs (thick/thin), AoOA? (Mature/young), AOYRA-Age of Youngest Revolving Account (new accounts/no new accounts)? Open/closed loan on CR?
For example, mine is clean/thick/mature/new account, with open loan on record.
If you don't know where you fall, just detail any baddies, your number of open and closed accounts, AoOA, AOYRA and whether you have a loan on record to start.

For utilization questions, list individual and aggregate utilizations, revolving and installment, please.
Message 33 of 73
Highlighted
Super Contributor

Re: Clean/Thin/Young..ish/New Account DPs

 
For a collection of our current FICO scoring wisdom, updated as we learn, read the following. Watch the revision dates on the bottom of the first 8 posts as they are regularly updated: Link to Scoring Primer.


RIP:

Oldest/average age varies by bureau. Estimates above.


Updated Oct 2020, unless otherwise noted.

(Forgive typos, mobile.)(Everything said is Just IMHO.)

In order to better answer your questions and record your DPs, please provide your profile stats: Any baddies? Severity and recency? (clean/dirty), Number of accounts, both open and closed on CRs (thick/thin), AoOA? (Mature/young), AOYRA-Age of Youngest Revolving Account (new accounts/no new accounts)? Open/closed loan on CR?
For example, mine is clean/thick/mature/new account, with open loan on record.
If you don't know where you fall, just detail any baddies, your number of open and closed accounts, AoOA, AOYRA and whether you have a loan on record to start.

For utilization questions, list individual and aggregate utilizations, revolving and installment, please.
Message 34 of 73
Highlighted
Epic Contributor

Re: Clean/Thin/Young..ish/New Account DPs


@Birdman7 wrote:

 

@AllZero could be a decent macro?


@Birdman7, I think @AllZero ran out of room for macro's a loooooong time agosmiley-laughing021.gif

hides-behind-couch.gif

Message 35 of 73
Highlighted
Super Contributor

Re: Clean/Thin/Young..ish/New Account DPs


@M_Smart007 wrote:

@Birdman7 wrote:

 

@AllZero could be a decent macro?


@Birdman7, I think @AllZero ran out of room for macro's a loooooong time agosmiley-laughing021.gif

hides-behind-couch.gif


@M_Smart007 😂😂😂

For a collection of our current FICO scoring wisdom, updated as we learn, read the following. Watch the revision dates on the bottom of the first 8 posts as they are regularly updated: Link to Scoring Primer.


RIP:

Oldest/average age varies by bureau. Estimates above.


Updated Oct 2020, unless otherwise noted.

(Forgive typos, mobile.)(Everything said is Just IMHO.)

In order to better answer your questions and record your DPs, please provide your profile stats: Any baddies? Severity and recency? (clean/dirty), Number of accounts, both open and closed on CRs (thick/thin), AoOA? (Mature/young), AOYRA-Age of Youngest Revolving Account (new accounts/no new accounts)? Open/closed loan on CR?
For example, mine is clean/thick/mature/new account, with open loan on record.
If you don't know where you fall, just detail any baddies, your number of open and closed accounts, AoOA, AOYRA and whether you have a loan on record to start.

For utilization questions, list individual and aggregate utilizations, revolving and installment, please.
Message 36 of 73
Highlighted
Super Contributor

Re: Clean/Thin/Young..ish/New Account DPs

@Birdman7. @M_Smart007. True. I'll have to make room for it by getting rid of others. 😃

Message 37 of 73
Highlighted
Valued Contributor

Re: Clean/Thin/Young..ish/New Account DPs


@Birdman7 wrote:

@CassieCardI mean a chart with instructions on how to calculate those values, but the table sounds awesome too!

 

Unless the macro calculates ages and displays them?


They don't allow Javascript in a macro - otherwise, piece of cake.

 

One thing I never found a definitve answer for, but am 90% sure of based on observations of my profile data:

What rounding method is used for averages?

 

In Excel, a straight ROUND function works fine for me, but I've never had a value that could round down - only up, like 17.8 months. So it's probably normal midpoint rounding (e.g., 17.4 average would be 17 months).

 

Formula in Excel for calculating Age of a single account in Months:

=DATEDIF(DATE(YEAR(B3), MONTH(B3), 1), TODAY(),"m")

 

Where B3 is a cell containing the exact opening date (date of approval). The '1' argument in the DATE function above makes DATE return an an intermediate date value that is reset to the 1st anyway. The original value of B3 stays the same.

 

To display that in yr mo:

=INT(E3/12)&"yr "&MOD(E3,12)&"mo"

 

Where E3 is the cell containing the 'Age in Months' returned by the previous function.

27 FICO Scores + 3 VS3. MTG (Mortgage), AUT (Auto), and BKC (Bankcard) are scores 5,4, and 2 from the top.

Keeper of the Scrolls of ResilienceEQ FICO Resilience Index Score Leaderboard

46 forum members have shared this new credit score. Share yours today!

Message 38 of 73
Highlighted
Super Contributor

Re: Clean/Thin/Young..ish/New Account DPs


@CassieCard wrote:

@Birdman7 wrote:

@CassieCardI mean a chart with instructions on how to calculate those values, but the table sounds awesome too!

 

Unless the macro calculates ages and displays them?


They don't allow Javascript in a macro - otherwise, piece of cake.

 

One thing I never found a definitve answer for, but am 90% sure of based on observations of my profile data:

What rounding method is used for averages?

 

In Excel, a straight ROUND function works fine for me, but I've never had a value that could round down - only up, like 17.8 months. So it's probably normal midpoint rounding (e.g., 17.4 average would be 17 months).

 

Formula in Excel for calculating Age of a single account in Months:

=DATEDIF(DATE(YEAR(B3), MONTH(B3), 1), TODAY(),"m")

 

Where B3 is a cell containing the exact opening date (date of approval). The '1' argument in the DATE function above makes DATE return an an intermediate date value that is reset to the 1st anyway. The original value of B3 stays the same.

 

To display that in yr mo:

=INT(E3/12)&"yr "&MOD(E3,12)&"mo"

 

Where E3 is the cell containing the 'Age in Months' returned by the previous function.


@CassieCard That's so awesome maybe you can add a post in the primer explaining how to do ages and utilization in excel maybe?

 

i'm real rusty on my Excel, so when I made my chart I had to Google it and figure it out. Lol. I still got it update it and then go back and plot my old data as we discussed. No telling what we might learn. 

For a collection of our current FICO scoring wisdom, updated as we learn, read the following. Watch the revision dates on the bottom of the first 8 posts as they are regularly updated: Link to Scoring Primer.


RIP:

Oldest/average age varies by bureau. Estimates above.


Updated Oct 2020, unless otherwise noted.

(Forgive typos, mobile.)(Everything said is Just IMHO.)

In order to better answer your questions and record your DPs, please provide your profile stats: Any baddies? Severity and recency? (clean/dirty), Number of accounts, both open and closed on CRs (thick/thin), AoOA? (Mature/young), AOYRA-Age of Youngest Revolving Account (new accounts/no new accounts)? Open/closed loan on CR?
For example, mine is clean/thick/mature/new account, with open loan on record.
If you don't know where you fall, just detail any baddies, your number of open and closed accounts, AoOA, AOYRA and whether you have a loan on record to start.

For utilization questions, list individual and aggregate utilizations, revolving and installment, please.
Message 39 of 73
Highlighted
Super Contributor

Re: Clean/Thin/Young..ish/New Account DPs

@CassieCard could you provide the JavaScript and could someone put it in notepad and then make it an executable? Or something easy like that or you could make a nice app that does it and put it in the App Store? 😁
For a collection of our current FICO scoring wisdom, updated as we learn, read the following. Watch the revision dates on the bottom of the first 8 posts as they are regularly updated: Link to Scoring Primer.


RIP:

Oldest/average age varies by bureau. Estimates above.


Updated Oct 2020, unless otherwise noted.

(Forgive typos, mobile.)(Everything said is Just IMHO.)

In order to better answer your questions and record your DPs, please provide your profile stats: Any baddies? Severity and recency? (clean/dirty), Number of accounts, both open and closed on CRs (thick/thin), AoOA? (Mature/young), AOYRA-Age of Youngest Revolving Account (new accounts/no new accounts)? Open/closed loan on CR?
For example, mine is clean/thick/mature/new account, with open loan on record.
If you don't know where you fall, just detail any baddies, your number of open and closed accounts, AoOA, AOYRA and whether you have a loan on record to start.

For utilization questions, list individual and aggregate utilizations, revolving and installment, please.
Message 40 of 73
Advertiser Disclosure: The offers that appear on this site are from third party advertisers from whom FICO receives compensation.