2019 Stockaholics Members Watch Lists

Discussion in 'Stock Market Today' started by Stockaholic, Dec 22, 2018.

  1. Stockaholic

    Stockaholic Content Manager

    Joined:
    Mar 29, 2016
    Messages:
    13,767
    Likes Received:
    7,050
    Also here is the view of the individual members watch list sheet-

    I just added a field for ROI from today's open. Assuming that's what you mean by "today's roi".

    [​IMG]

    I also have this stats sheet, but this one only works when all picks have been submitted via the form-

    [​IMG]
     
  2. Stockaholic

    Stockaholic Content Manager

    Joined:
    Mar 29, 2016
    Messages:
    13,767
    Likes Received:
    7,050
    BTW @rStock I know you had also asked for an overall "total roi" of all picks.

    I actually have that on my individual sheet here down at the very bottom-

    However, that will only show up once all members picks have been entered from the Google Form.

    I suppose I could "manually" add only the cells that have data in them and that would work too, but admittedly that would be kind of a pain in rear to do it that way. :p

    [​IMG]
     
  3. rStock

    rStock Well-Known Member

    Joined:
    Sep 27, 2016
    Messages:
    89
    Likes Received:
    105
    Look good CY

    Can we have new watch list link pls... thanks
     
    Stockaholic likes this.
  4. Stockaholic

    Stockaholic Content Manager

    Joined:
    Mar 29, 2016
    Messages:
    13,767
    Likes Received:
    7,050
    Yup, here ya go-

    [​IMG] <-- click there!

    Oh, and I went ahead and made some additional changes to the individual members spreadsheet.

    Where I have my arrow pointing to in the screenshot below-

    (I've added a second Total ROI from Entry, this one could be used to just pull only from the cells that have data in them. However, this would need to be changed manually once additional picks have been submitted and added to the spreadsheet. But, this should work fine for the time being I guess. :))

    [​IMG]
     
  5. rStock

    rStock Well-Known Member

    Joined:
    Sep 27, 2016
    Messages:
    89
    Likes Received:
    105
    You have (-) negative on today roi. Pls check my pick on weekly contest

    Thanks CY
     
  6. Stockaholic

    Stockaholic Content Manager

    Joined:
    Mar 29, 2016
    Messages:
    13,767
    Likes Received:
    7,050
    Haha, I'm not sure how I botched that one up there :p

    Check it now, should be fixed I think. Let me know when you get a chance @rStock. Thanks. :)
     
  7. rStock

    rStock Well-Known Member

    Joined:
    Sep 27, 2016
    Messages:
    89
    Likes Received:
    105
    Good now ... I will add more picks later to see how they work

    Thanks
     
    Stockaholic likes this.
  8. rStock

    rStock Well-Known Member

    Joined:
    Sep 27, 2016
    Messages:
    89
    Likes Received:
    105
    CY, please check 'Final P/L from Entry' ... I think it's not right. Thanks
     
  9. Stockaholic

    Stockaholic Content Manager

    Joined:
    Mar 29, 2016
    Messages:
    13,767
    Likes Received:
    7,050
    @rStock - actually i think that one is correct. that just calculates your entry and exit price.

    since your exit price field is "empty" in the spreadsheet, then it will just simply show your entry price in that field.

    pretty sure if you add an exit price, the "final p/l from entry" as well as the "final roi from entry" in the spreadsheet will show the correct data.

    give it a shot as a test and let me know if that is indeed the case. haven't tested it but i think it will work.
     

Share This Page