COL Financial Average Down Calculator
Published: 5/25/2018

Updated: August 19, 2024
2 minute read

Trading and Investing in stocks only mean one thing, you will be dealing with numbers all the time. As the main principle of stock is to "Buy Low - Sell High", it is difficult to determine if a stock that you are planning to buy is a good deal or not. Especially, if you already have that particular stock in your portfolio.

So how do go about it? The answer is to do some AVERAGING, if the old average price is much higher than the new average price then it is a good buy since you are averaging down your stock price.

Below is a PSE Calculator that I've created to save you the trouble of manually calculating the amount.

COLFINANCIAL Average Down Calculator

Instruction: Do not add a comma when inputting values. For example, you need to enter 1700 instead of 1,700 to calculate the values correctly.

Current # of Shares:

Current Average Price:

New # of Shares to Buy:

Market Price:

Total Buying Fees:

Total Buy Amount:

Average Price:

Your Total # of Shares:

Your New Stock Average Price:

Average Difference:

If you have a hard time deciding when to sell. The COLFinancial Buy and Sell Calculator is for you.

Read the article "How To Calculate The Weighted Average Price" to know how it is computed.

Stay tuned also for the mobile app version of this calculator. For the meantime, just visit this post every time you want to use the calculator.

I am hoping that it can help someone out there.

- Your Life In Perspective -

Comments (34)

Logging you in...

Dashboard | Edit profile | Logout

Logged in as

+1 Vote up Vote down

Joyce · 197 weeks ago

yes, nde nag cocompute ung calculator :(

1 reply · active 196 weeks ago

+2 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 196 weeks ago

It is working on my end when I tested the calculator.

0 Vote up Vote down

Ryan · 211 weeks ago

calculate is not working sir, please update.

0 Vote up Vote down

Robert Almario · 216 weeks ago

Sir, meron po kayo na excel file na ganito?

0 Vote up Vote down

anon · 218 weeks ago

not working mate :(

1 reply · active 217 weeks ago

+1 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 217 weeks ago

Working on my end sir.

0 Vote up Vote down

GuestLancer · 221 weeks ago

Paano po sir ang computation ng new average price? Marami pong salamat!

4 replies · active 221 weeks ago

0 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 221 weeks ago

Kindly Refer to this link: https://www.yourlifeinperspective.com/2018/07/how-to-calculate-weighted-average-price.html

0 Vote up Vote down

GuestLancer · 221 weeks ago

*New Stock Ave Price

0 Vote up Vote down

Jov · 221 weeks ago

Na click mo na ba ung green bar/banner na "Calculate New Stock Average" sa ibabaw ng ads?

0 Vote up Vote down

GuestLancer · 221 weeks ago

Yes po. Pero di kasi ung match ng new average price na meron sa COL port :)

+1 Vote up Vote down

PHTrader · 225 weeks ago

May nagbago ba boss sa formula ng calculator mo? bakit mali na yung pag average up.

eto sample: https://ibb.co/StF46ZL

check mo sa excel calculator malayo yung average na lumalabas.

2 replies · active 225 weeks ago

0 Vote up Vote down

PHTrader · 225 weeks ago

sakto dati ang pag average up ngayon hindi na.

+1 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 225 weeks ago

Good day PHTrader,

Based on your screenshot, you've added a comma to 1700. Dapat 1700 instead of 1,700.

I'll update the calculator to add some instructions to guide future users.

Thank you.

0 Vote up Vote down

Rob · 226 weeks ago

How do you compute for the New Stock Average Price?

1 reply · active 226 weeks ago

+1 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 226 weeks ago

Hi Rob,

I've written an article way back explaining the formula behind averaging.

Refer to this link: https://www.yourlifeinperspective.com/2018/07/how-to-calculate-weighted-average-price.html

Thank you.

0 Vote up Vote down

Rej · 242 weeks ago

May we kindly follow-up on the certificate renewal? The calculator is still not working now. Thank you!

1 reply · active 242 weeks ago

+1 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 242 weeks ago

Calculators are up again. Thanks.

0 Vote up Vote down

Joshua · 243 weeks ago

its not working again, pls fix if you have time tnx so much

1 reply · active 242 weeks ago

+2 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 242 weeks ago

The free certificate for this site to operate had expired last 3 days ago. Currently in the process of renewing the certificate. Thanks.

0 Vote up Vote down

Marisol · 243 weeks ago

Hi Alfred, I can't use the calculator, I can't find the ads that might be overshadowing it if there's any. Kindly check your calculator. thank you.

1 reply · active 242 weeks ago

+1 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 242 weeks ago

The free certificate for this site to operate had expired last 3 days ago. Currently in the process of renewing the certificate. Thanks.

0 Vote up Vote down

Zam · 243 weeks ago

It's not working again =( But thanks for creating this, this helps bigtime!

1 reply · active 242 weeks ago

+1 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 242 weeks ago

The free certificate for this site to operate had expired last 3 days ago. Currently in the process of renewing the certificate. Thanks.

0 Vote up Vote down

Damian · 244 weeks ago

Thank you for this tool :D

1 reply · active 243 weeks ago

+1 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 243 weeks ago

You're welcome! Don't forget to spread the word.

0 Vote up Vote down

Rej · 260 weeks ago

Thank you very much for this! This is a big help. This is exactly what I'm looking for.

3 replies · active 249 weeks ago

+3 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 259 weeks ago

You're very welcome! Help spread the word by sharing this tool.

0 Vote up Vote down

Roger · 249 weeks ago

please fix your calculator. it's no longer working. Thanks.

+1 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 249 weeks ago

Issue Fixed. You can use the calculators again.

Thanks!

+1 Vote up Vote down

Roger · 249 weeks ago

Your calculator does not work anynore.

1 reply · active 249 weeks ago

+1 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 249 weeks ago

Encountered some issues with my hosting, but it is fixed now. You can use the calculators again.

Thanks!

0 Vote up Vote down

Joshua · 249 weeks ago

its is not working anymore :( :(

1 reply · active 249 weeks ago

+1 Vote up Vote down

Ælfræd (Elf Counsel) 28p · 249 weeks ago

Apologies for the downtime. I've already fixed the issue. You can use the calculators again.

Thanks!

Post a new comment

Comment as a Guest, or login:

Submit Comment

Subscribe to

Comments by IntenseDebate