Results 1 to 5 of 5

Thread: Help with model of tomorrows price

  1. #1
    Neophyte andybandy123's Avatar
    Join Date
    Oct 2019
    Posts
    3
    Articles
    0
    Excel Version
    Office 365

    Help with model of tomorrows price



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I have got a task which I cant figure out. I want to build a prediction model if we should buy stocks or not. And by using an external parameter (demand from customer on the whole market in our area which we get daily) I want to predict if the stock price tomorrow goes up or down.

    I have columns with:
    Daily prices for last 10 months.
    The price change per day in %
    The price change per day in $
    Customer Ratio (The variable Im suppose use to predict with)


    I want excel by the end of each day to look at the daily %change and on the customer ratio, and give me a signal if I should "Buy / No buy" TOMORROW (not the same day since it just closed). We always sell after 24 hours if excel doesnt tell us otherwise.


    a) Maximize the profit
    b) Keep the number of "loss-days" to a minimum (I.e control the risk!)
    b) What threshold should be used on the customer ratio? I.e when is it good to buy or not?
    c) What should the %-change be?

    For example...I want to be able to say:
    Okey if the customer ratio is below 4 and the price went up 5$ yesterday, we should buy today.

    I CANT FIGURE IT OUT!

    Click image for larger version. 

Name:	Skärmklipp.PNG 
Views:	9 
Size:	21.0 KB 
ID:	9416

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,280
    Articles
    0
    Excel Version
    Office 365 Subscription
    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Neophyte andybandy123's Avatar
    Join Date
    Oct 2019
    Posts
    3
    Articles
    0
    Excel Version
    Office 365
    I have cross-posted this thread to other forums too: https://www.excelforum.com/excel-for...ml#post5217840
    Last edited by andybandy123; 2019-10-27 at 07:04 PM.

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,280
    Articles
    0
    Excel Version
    Office 365 Subscription
    We do not need to ignore it - you are allowed to post on multiple forums as long as you provide links.

    I suggest you read the rules here and over on Excel Forum before posting again, because when joining both fora, you agreed to abide by them.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Neophyte andybandy123's Avatar
    Join Date
    Oct 2019
    Posts
    3
    Articles
    0
    Excel Version
    Office 365
    Thanks=)

Posting Permissions

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