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.
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work.
Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction.
I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """