+ Reply to Thread
Results 1 to 13 of 13

Building Logic for Effective Distribution in Stock-Portfolio

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Building Logic for Effective Distribution in Stock-Portfolio

    Help Needed in Building a Logic to distribute any given amount "X" for "N" number of Stocks with different Prices.

    Dear Forum,

    I have a situation where I need to develop a scientific and mathematical approach which involves a lot of business sense before I put my money in Stocks.

    While Investing in Stocks, we come across a situation where we need to diversify and put our money in specific stocks....Now this step is already been done...

    Now, I have already selected the number of Stocks and also the Names of the Stocks...Each Stock has a different price and each is expected to rise or fall differently..

    I would like to know how much money I need to put in each Stock so as to earn more profits with that combination.

    Ex:-
    Lets say If I have $ 10000 and I have selected three Stocks to be bought with this amount..

    STOCK-NAME--PRICE------PROFIT
    Stock I---------$ 32--------$ 37
    Stock II--------$ 55--------$ 62
    Stock III-------$ 77--------$ 81

    I want to get a Logic which gives me which utilises the Investin amount and buys Stocks in such a way that can yield the maximum Profit...

    This is a concept and the No of Stocks can increase or decrease as well as the Investing amount, the logic should be strong enough to be able to expand ...

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Building Logic for Effective Distribution in Stock-Portfolio

    Hi,

    You really need to define your precise rules and the relationships between the variables. Until you do this the details you give are insufficient. For instance you imply that the main goal is to maximise the profit. If so, and if you've already predicted the various returns then the obvious answer in the absence of any other criteria is to invest the whole amount in Stock II which generates the highest rate of return and forget the other two.

    HTH
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Building Logic for Effective Distribution in Stock-Portfolio

    Hi Richard!

    I am looking for a logic firstly a Mathematical Logic to start with which can deal with the given situation and then later it can be Computerised or Excelified...

    I am not a Mathematician but I trust with my gut instinct that most of the Moderators and Gurus would be able to help me on this as they are HIgh-Profile Engineers with superb mathematical acumen..

    Though my main goal is to make profits but it is also to buy all the three stocks maybe not in the same quantity..

    Lets Say If I buy Stock I - 100 nos then I would have spend $ 3200 and Then I would remain with $ 6800 for the other two , then lets say If I buy 70 of Stock II then I would have used $ 3850 and then with the remaining amount i.e. $ 10000 -($ 3200 + $ 3850 ) = $ 2950.

    With $ 2950 remaining I would be able to buy $ 2950 / 77 = 38 Stocks of Stock III.

    Now I want some helping hand to understand why Im buying which Stock more and which Stock Less and also give mt he appropriate no of Stocks to be bought for each variety.

    I am also looking for this logic to be expandable if more no f Stocks are included as well as one more criterion of Risk is Induced alongwith the prices as follows.

    STOCK-NAME--PRICE------PROFIT---RISK
    Stock I---------$ 32--------$ 37-----HIGH
    Stock II--------$ 55--------$ 62-----MEDIUM
    Stock III-------$ 77--------$ 81-----LOW

  4. #4
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Building Logic for Effective Distribution in Stock-Portfolio

    I was thinking of getting some help in buildingthis concept.

    Maybe I I could divide the Amount of $ 10,000 in three equal parts of $ 3333 each and increment each portion with some value in the stock which gives maximum profit..

    Can someone suggest something more better?

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Building Logic for Effective Distribution in Stock-Portfolio

    Hi,

    Your requirements are still somewhat contradictory. As I said if your main aim is to maximise your profit, then just invest in the stock which yields the highest %.

    If as you intimated you want to invest in all three stocks for some other reason which is unclear, then buy just one share in each of the lower yielding stocks and put all the rest in the high yield stock.

    However I fear this is not what you're after.

    If you want to invest in several stocks, then only you can write the rules which you want to apply in determining which stocks and how much. Until you do this the task is not yet a mathematical one which any of us can help you with.

    You might for instance want to spread stocks in different industrial sectors, or create a hierarchy of risk attached to each stock, but until you give us something to work with I don't see how we can advise.

    Regards

  6. #6
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Building Logic for Effective Distribution in Stock-Portfolio

    Hi Richard,

    Your requirements are still somewhat contradictory. As I said if your main aim is to maximise your profit, then just invest in the stock which yields the highest %.
    I agree that they are as its not so linear and more dynamic as diversification is always neccessary when dealing with stocks

    If as you intimated you want to invest in all three stocks for some other reason which is unclear,
    For two reasons to prevent losses ( "By Keeping all your eggs in one Basket " as the adage) as well as to make more profits..

    The Stocks chosen would always be good stocks to Invest In, however within those Stocks what will be the Best Combination to make more profits is the requirement..

    If you want to invest in several stocks, then only you can write the rules which you want to apply in determining which stocks and how much.
    Yes I want to Invest in several Stocks however not every day and moreover there are different Lifetimes for each Stock to Hold..

    Like based on News, there are some Stocks would give a decent appreciation within two weeks while some stocks are very Volatile and can daily allow you to make some profits however it would still be not prudent to put your bet only on these stocks..Then there are the Long Term Investor Stocks which are of Good Companies which give you benefits in the Long Term however these always blocks your Capital..as these are very expensive and only come handful compared to the small up-coming companies..


    Until you do this the task is not yet a mathematical one which any of us can help you with.
    So we would need to only concentrate the first two type of Stocks which can be traded on a Short Term like a (Week to 15 Days ) or very Short Term of a Day or Two..Hope this is a good explanation...

    I have also a School of thought where I could equate the Stock Prices mathematically but do not know how..

    STOCK-NAME--PRICE------PROFIT
    Stock I---------$ 32--------$ 37
    Stock II--------$ 55--------$ 62
    Stock III-------$ 77--------$ 81

    Whether making a Profit of $ 5 on $ 32 purchase is better or a $ 7 on a buy of $ 55 or $ 4 on a buy of $ 77..

    Some Analogy, In Cricket the Opener may score a Century in lets say 132 balls and a 6 Down Batsman a quickfire 26 in just 9 balls..Now how can you equate both eye for an eye terms....as both innings are of consequence..

    Until you give us something to work with I don't see how we can advise
    Hope this would be useful..

  7. #7
    overbet
    Guest

    Re: Building Logic for Effective Distribution in Stock-Portfolio

    I dont know much about excel but I know a lot about stock trading. I think you need to determine why you are investing in each stock and what the time frame is for the return you expect as well as what the catalyst is that will make your "picks" come to fruition before anyone can help you quantify it. To me it sounds like you are asking for help to build a system that doesnt yet exist. The information about the stocks you listed is very vague and that is the problem. You have 3 stocks with 3 different prices and different returns. Stock 1 is a better choice than stock 3 because your % return is better but you are even so vague that you arent even specifying the time your money is tied up. Stock 3 is a better choice if you make that return in 1 day versus having to hold stock 1 for a year.

    You should look at your investing bankroll and make plays more along these lines: I want to buy shares of company ABC because the research I have done suggest they are going to have blowout earnings. The companies they supply had much better than expected sales and their market share has been growing steadily for the past few years. They are due to report earnings at the end of the month and there is speculation they will be making a special announcement on there earnings call. You then decide how much of your capital you want to risk on this trade, 3-5% is generally a good number. You buy the stock and buy a put option on the stock to hedge your bet in case you are wrong. You are gambling they will have a big beat of earnings and that the amount you are risking is the money spent on the put option. That is your max risk of 3-5%. Hope that helps.
    Last edited by teylyn; 01-03-2010 at 08:47 PM. Reason: removed quote

  8. #8
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Building Logic for Effective Distribution in Stock-Portfolio

    overbet, please don't quote whole posts. It's just clutter. Use the Quick Reply box or the Post Reply button rather than the Quote button.

    Thanks.

  9. #9
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Building Logic for Effective Distribution in Stock-Portfolio

    Quote Originally Posted by overbet View Post
    To me it sounds like you are asking for help to build a system that doesnt yet exist. .
    You are absolutely right, I am a novice in the Stock Market and therefore not aware of all the criterions that need to be satisifed before buying a stock and so Im trying to get ideas..

    Now there are times when you need to buy more than a stock and within a stipulated amount then what would be the best combination?

    Please go through my earlier posts to get more clarity in what Im wanting..

  10. #10
    overbet
    Guest

    Re: Building Logic for Effective Distribution in Stock-Portfolio

    These guys on this site can help you with coding but you are on the wrong site asking for stock picking help. Read these and you will get some ideas: http://pragcap.com/the-ultimate-guid...s-and-outlooks

  11. #11
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Building Logic for Effective Distribution in Stock-Portfolio

    Dear overbet,

    These guys on this site can help you with coding but you are on the wrong site asking for stock picking help.
    The best thing to have ever happened to me was to sign up on this site and get to know so much knowledge in every possible way...
    I think this site is a very good example of philanthropy of one sorts..

    Most of the people are not only good in coding but also in explaining their code..Most of them are qualified engineers good in their respective fields and therefore I feel that this is not a wrong place to be...

    More importantly the question is not based on picking stocks but rather distributing the amount which I suppose is not Stock-Inclined..but a Mathematical one..

    I have asked the question in the hope of getting an idea in building a system as this is just a concept..

    Maybe if this query would have asked with a different example other than Stocks than it would not have been as apt as now...

    The above site would be useful, however I am form India and just about started dealing in Indian Stocks...

    So I humbly request one and all, please feel free to offer some ideas for this...

  12. #12
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Building Logic for Effective Distribution in Stock-Portfolio

    e4excel, I don't think that it would have made a difference if the subject was stocks or baby shampoo. It's more that you don't define the terms on which an equation can be built. With every suggestion you've been given, you've changed the goal posts.

    So, come up with clearly defined criteria, and a solution will be much closer.

  13. #13
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Building Logic for Effective Distribution in Stock-Portfolio

    Quote Originally Posted by teylyn View Post

    So, come up with clearly defined criteria, and a solution will be much closer.
    Actually, I am also confused about that and am trying to build some concept which can later be Excelified..

    So, I shall go in hibernation for some time to ponder over it..This is not regular stuff and moreover it involves money so need to be very prudent..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1