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". I also have this stats sheet, but this one only works when all picks have been submitted via the form-
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.
Yup, here ya go- <-- 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. )
Haha, I'm not sure how I botched that one up there Check it now, should be fixed I think. Let me know when you get a chance @rStock. Thanks.
@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.