Welcome Stockaholics!

We are a new and fast growing financial forum! Sign up for free and let's talk stocks!

  1. Do you want to help develop this community? We are looking for contributions from investors and traders like you! What stocks do you follow? What is hot right now? Sign up and get in on the ground floor of the newest, fastest growing financial forum!
    Dismiss Notice
  2. You will notice a live chat widget on the right. Click in to join us and lets hear about how you nailed that last UWTI trade!
    Dismiss Notice

2019 Stockaholics Members Watch Lists

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

  1. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    17,749
    Likes Received:
    6,044
    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. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    17,749
    Likes Received:
    6,044
    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:
    760
    Likes Received:
    381
    Look good CY

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

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    17,749
    Likes Received:
    6,044
    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:
    760
    Likes Received:
    381
    You have (-) negative on today roi. Pls check my pick on weekly contest

    Thanks CY
     
  6. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    17,749
    Likes Received:
    6,044
    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:
    760
    Likes Received:
    381
    Good now ... I will add more picks later to see how they work

    Thanks
     
    bigbear0083 likes this.
  8. rStock

    rStock Well-Known Member

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

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    17,749
    Likes Received:
    6,044
    @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