STOCK PURCHASE PRICE ADVERAGE CACULATOR

STOCK PURCHASE PRICE ADVERAGE CACULATOR AIM: BUY STOCK AT LOWEST PRICE. PROBLEM: STOCK PRICE GOES LOWER. GOAL: KEEP MY CURRENT STOCK HOLDING PRICE EQUAL TO THE NEW LOWER PRICE, BY PURCHASE OF STOCK AT THE NEW CURRENT PRICE TO ADVERAGE MY PRICE DOWN, NEED TO BE ABLE TO CACULATE: EXAMPLE: I HAVE 300 SHARES AT $1.50 EQUALS $450.00. NEW CURRENT PRICE IS $ 1.35. ? HOW MANY SHARES AT CURRENT $1.35 NEEDED TO BUY TO LOWER / ADVERAGE MY CURRENT PRICE OF $1.50 TO $1.35. NOTE: I WILL THEN BUY # SHARES CALCULATE TO EQUAL NEW SHARE PRICE AT $1.35. PRICES GOES LOWER TO 1.15 . NEED TO AGAIN INPUT NEW PRICE AND CALULATE NEW AMOUNT OF SHARES NEEDED TO PURCHASE TO TO ADVERAGE MY $1.35 TO $1.15. AND REPEAT AS NEEDED TO KEEP MY COST AT LOWEST PRICE. SAME SPREADSHEET: NEED ACTUAL RUNNING TOTAL OF MY SHARES OWENED . TOTAL VALUE OF SHARES OWNED. % DOWN.