Ask Experts Questions for FREE Help !
Ask
    judy.warren's Avatar
    judy.warren Posts: 3, Reputation: 1
    New Member
     
    #1

    May 25, 2010, 05:27 PM
    Formula to figure total cost of stock for an odd lot
    What is the formula that will add to the cost of stock, the commission for an odd lot, (where the lots of 100 have one commission and the remaining amt <100 has a different commission). Also, the formula that will subtract commission from the proceeds on an odd lot.
    ebaines's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
     
    #2

    May 26, 2010, 08:55 AM

    Are you asking for the specific commission schedule for odd lot trading by a particular broker? There is no set fee for this - it all depends on who your brokerage house is. I'm sure you can find the schedule of trading fees on the web site of your brokerage house.
    judy.warren's Avatar
    judy.warren Posts: 3, Reputation: 1
    New Member
     
    #3

    Jun 4, 2010, 10:15 AM

    It could be for any commission rate. I don't think I ever mentioned that the formula I am looking for is an Excel formula. How do I enter a formula that will figure the odd lot and round lot commissions separately and then add or subtract them from the cost or the proceeds?
    ebaines's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
     
    #4

    Jun 4, 2010, 11:59 AM


    If there is one rate for purchasing in blocks of 100, and another rate for lots of 1, then what you need is a formula that determines how many times 100 divides into the amount being purchased, and what the remainder is after you do the division. Let:

    = number of shares
    = number of whole lots (multiples of 100),
    = number of individual lots
    = commisision rate for whole lots (per hundred)
    = commission rate for individual shares.

    Then:

    Commission =

    where W and I can be calculated using the Excel functions:

    W=floor(N/100, 1)
    I = mod(N, 100)
    judy.warren's Avatar
    judy.warren Posts: 3, Reputation: 1
    New Member
     
    #5

    Jun 4, 2010, 02:26 PM

    IT WORKS!! Thank you. You are awesome.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

What is the formula total expense [ 2 Answers ]

Company ZZZ reports net income for 2007 of $2.4 million on total revenue of $30 million. Deprecton expense totaled $1 million. What were total expense for 2007.

Formula for current total annual inventory cost. [ 4 Answers ]

Novelty Gifts, Inc. is experiencing some inventory control problems. The manager, Wanda LaRue, currently orders 5,000 units four times each year to handle annual demand of 20,000 units. Each order costs $15 and each unit costs $1.50 to carry. Ms. LaRue maintains a safety stock of 200 units. a)...

How to figure total debt [ 1 Answers ]

If one knows asset turnover, debt to equity ratio, and sales, what is the formula to calculate total debt? Sales = $4,500,000 Asset Turnover = 5X's Debt to equity = 60% What is the total debt?


View more questions Search