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

Stockaholics Watch List

Discussion in 'Stock Market Today' started by T0rm3nted, Jan 10, 2017.

  1. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    14,193
    Likes Received:
    4,471
    went ahead and added a column for "spark chart" in the individual members watch list sheet to give people a little visual of the past 90 trading days, since i'm not sure there will be a way to copy & paste people's charts into the spreadsheet if they posted one. :p

    also added a column for "likes it" to identify if people like the stock long or short.

    [​IMG]

    did the same on the master sheet as well.

    [​IMG]

    will continue tinkering around with this over time, and if you guys have any other ideas/suggestions definitely feel free to post them up in here as well.

    i just want to reiterate the "rationale" aspect of this new version of stockaholics watch list.

    it will be super helpful to hear why people have particular stocks on their watch list. again, my goal is to make this thread way more engaging and interactive than just simply having people come in and posting tickers. :p
     
  2. jazz

    jazz New Member

    Joined:
    Apr 16, 2018
    Messages:
    29
    Likes Received:
    8
    this is a great idea.
    can people please post when the stocks you are watching are nearing major support and resistance. this would help greatly
     
  3. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    14,193
    Likes Received:
    4,471
    Bumping this thread back to the top!

    So, seeing as we've got a few of our regulars checking back in on the forums again, I thought we could finally give this thread some much needed action. :p

    Personally, I thought I did a pretty bang up job on the creating the spreadsheets for this watch list idea, however, unfortunately they never did get used.

    I always thought this was a good idea for the community, but I guess it never quite took off during the summer when I was attempting to set it up.

    The idea of this thread was to bring members together to exchange thoughts and ideas.

    Our first attempt at a watch list a few years back was pretty bland as we only had members posting their tickers that they were watching.

    However, on this new attempt here, I am trying to get members add some rationale for their tickers.

    If you guys have any ideas how we can make these threads interesting, fun and most importantly useful for others, let me know!

    Anyway, I'm going to try my best to give this thread another attempt in there. If all fails, at least I know I tried lol. :D
     
  4. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    14,193
    Likes Received:
    4,471
    ^^ Any1? :p

    So, here's an idea. I'm thinking of possibly incorporating the Google Forms idea that was first brought to my attention by @Three Eyes for the Stockaholics competitions, and maybe putting them in my Stockaholics Watch List Google Sheet template. That may work, and I assume it would make it a lot easier and fun for everyone, rather than asking everyone to post their watch lists to this thread. IDK, just thinking out loud here.

    I'm going to see what I can come up with. Shouldn't be too difficult to setup since I've gotten the hang of how Google Forms work, and have already made it a fixture on the Stockaholics contests. :D

    I'll report back in here if/when I got something up and I'll ask you guys to test run it for me to make sure I got everything functioning w/o any issues.
     
  5. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    14,193
    Likes Received:
    4,471
    Alrighty! I think I've managed to set this up in fairly quick order. Getting the hang of Google Forms pretty nicely I might say. And it never would have been possible if @Three Eyes never mentioned it to me a few weeks back! So many Many MANY thanks goes out to him too! :cool:

    OK, so here's what I got...

    I setup 2 different forms for inputting members pick into my already existing watch list spreadsheet.

    One master spreadsheet that lists everyone's stocks and if they like it long or short, as well as individual members spreadsheets with lots of stock data, where members can also put in a brief rationale (optional) for why a certain stock is making it on their watch list. :)

    I've set it so people can submit up to 15 stocks on their watch list. Is that too few? I wasn't very sure. I think that was about what we had going a few years back when we attempted to run this in here. Anyway, yeah let me know on that. It's 15 for now but can be changed later if needed. I'm using 15 for this trial run for now.

    Let's test this out shall we?

    So, here is my main Google Form for submitting stocks to my master members watch list spreadsheet-

    [​IMG] <-- click there to view!

    ...and then here is the form members can use to submit their stocks and show up on individual sheets within the same spreadsheet. You'll notice that I'm using @Three Eyes for my test in this example. But, obviously I can add to this.

    [​IMG] <-- click there to submit your stocks!

    For the individual members watch lists, I'll just need to know who is interested to take part in this so that I can go ahead and create an individual sheet for you. Simply posting to this thread and letting me know would do the trick. :)

    Anyway, w/o getting into further ado, I'd be curious to see if I got this all working properly. :p

    Seems like I'm really using Google Forms for my spreadsheets a lot lately. It's pretty amazing to me what one can do with Google Forms and Google Sheets together. :D
     
    Three Eyes likes this.
  6. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    14,193
    Likes Received:
    4,471
    I guess it would help if I also included the actual spreadsheet where the Google Forms would be dumping the data to lol. Whoops my bad! :p

    Here we are-

    [​IMG] <-- click there to view!
     
    Three Eyes likes this.
  7. Three Eyes

    Three Eyes 2018 Stockaholics Contest Winner

    Joined:
    Dec 14, 2017
    Messages:
    453
    Likes Received:
    416
    Ahh, I hope this works! I tried my hand at using the Three Eyes-specific form. I wanted to test it with three picks. The Form, however, is requiring all 15 picks.
     
    bigbear0083 likes this.
  8. Three Eyes

    Three Eyes 2018 Stockaholics Contest Winner

    Joined:
    Dec 14, 2017
    Messages:
    453
    Likes Received:
    416
    So I got around the required fields feature by simply typing in "To Be Determined" and selecting "Long".
     
    bigbear0083 likes this.
  9. Three Eyes

    Three Eyes 2018 Stockaholics Contest Winner

    Joined:
    Dec 14, 2017
    Messages:
    453
    Likes Received:
    416
    ...then I went back in and edited the Form and changed Pick #4 from "To Be Determined" to MTN. It worked flawelessly.
     
    bigbear0083 likes this.
  10. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    14,193
    Likes Received:
    4,471
    Thanks big time for testing this out for me @Three Eyes!

    Just wondering, but are you able to "edit" the form? I think adding and removing tickers should be possible no? Let me know!
     
  11. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    14,193
    Likes Received:
    4,471
    Nice! Good to hear. That was what I was hoping for too! Glad to hear it worked! :D
     
  12. Three Eyes

    Three Eyes 2018 Stockaholics Contest Winner

    Joined:
    Dec 14, 2017
    Messages:
    453
    Likes Received:
    416
    Only thing is, the picks are not carrying over from the Three Eyes tab to the Master List tab.

    Not sure how you would control for the "To Be Determined" selections either.
     
  13. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    14,193
    Likes Received:
    4,471
    D'oh! I should probably remove the "required" part for all fields to be filled. I'll change that momentarily! Thanks for that heads up. :)
     
  14. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    14,193
    Likes Received:
    4,471
    Oh that one! I'm using another form to put data into the Master list tab.

    [​IMG] <-- click there!

    I'll look into now and see if I can just pull your data from the Three Eyes tab instead. Pretty sure it's possible. Would probably be a lot better if I was pulling from there I guess. :p
     
  15. Three Eyes

    Three Eyes 2018 Stockaholics Contest Winner

    Joined:
    Dec 14, 2017
    Messages:
    453
    Likes Received:
    416
    Ahh, okay.

    Finger's crossed. Let us know when you're ready to field test again! ;)
     
    bigbear0083 likes this.
  16. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    14,193
    Likes Received:
    4,471
    I think got it! :D

    Spreadsheet now pulls the data from the Three Eyes tab to the master list.

    How's that lookin' now?

    And just to make sure that I definitely got this working @Three Eyes could you do me a quick favor try editing your form again and either change or add something and see if it updates on the master list as well?

    I also removed the "require fields to be filled".

    Thanks again for helping me test all of this out!

    [​IMG] <-- click there to view!

    [​IMG]
     
  17. stock1234

    stock1234 2017 Stockaholics Contest Winner

    Joined:
    Apr 3, 2016
    Messages:
    3,415
    Likes Received:
    2,249
    I will post some stocks here later on, want a fresh start in 2019 :D
     
  18. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    14,193
    Likes Received:
    4,471
    Sweet! I'll create your spreadsheet and google form momentarily! Thanks for the heads up. :D
     
    stock1234 likes this.
  19. Three Eyes

    Three Eyes 2018 Stockaholics Contest Winner

    Joined:
    Dec 14, 2017
    Messages:
    453
    Likes Received:
    416
    Yes! I removed all the "To Be Determined" entries and they came off the Three Eyes and Master List tabs. Te votes ("Long") still show up because I could not deselect those. But that's a minor issue I don't think anyone would care about.
     
  20. Three Eyes

    Three Eyes 2018 Stockaholics Contest Winner

    Joined:
    Dec 14, 2017
    Messages:
    453
    Likes Received:
    416
    I also noticed "Three Eyes" has 11 blank entries on he Master List tab. I think since you're reading in the entire Three Eyes tab (which in turn is determined by a single Three Eyes form), we'll always have these blanks. Again, not a big problem.
     

Share This Page