#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Sell to reinvest

Hi

I need an excel formula that i can work out how many shares i need to sell
to buy an amount of shares

Example

i have 1000 shares on X stock priced at $10, but i need to rise enough cash
to buy Y stock priced at $30 without paying out any extra cash.

So i need to know how many i can sell of X and how many i can buy of Y

Thanks in advance
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default Sell to reinvest

A2 = # of stocks of X
B2 = Price of stock X
A3 = # of stocks desired of Y
B3 = Price of stock Y

Maximum amount of stock you can get of Y
=INT(A2*B2/B3)
# needed to sell of X to buy desired Y
=ROUNDUP(A3*B3/B2,0)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Purfleet" wrote:

Hi

I need an excel formula that i can work out how many shares i need to sell
to buy an amount of shares

Example

i have 1000 shares on X stock priced at $10, but i need to rise enough cash
to buy Y stock priced at $30 without paying out any extra cash.

So i need to know how many i can sell of X and how many i can buy of Y

Thanks in advance

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Available to sell Hugues Excel Discussion (Misc queries) 1 October 31st 08 09:17 PM
Can you Sell Excel spreadsheets scott56hannah Excel Discussion (Misc queries) 3 March 9th 07 07:00 AM
Absolute sell references PowerPoint Jedi Excel Discussion (Misc queries) 4 February 1st 07 06:13 PM
Triggers to buy/sell based on histogram x3mist Excel Discussion (Misc queries) 0 July 24th 06 02:30 AM
I sell jewelry what template should i use to keep track of it? template Excel Discussion (Misc queries) 1 July 23rd 06 11:57 PM


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"