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

Google Sheets live and historical prices

Discussion in 'Ask any question!' started by bigbear0083, Feb 3, 2018.

  1. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    15,592
    Likes Received:
    4,943
    dang, last hours eh? gonna miss ya @Three Eyes! thx for the quick check here much appreciate it.

    hope you have an absolutely amazing time out there!! :cool:

    hearing about your trip here has me motivated to maybe taking a summer trip myself (not quite as lengthy as yours though haha! :p)

    i haven't taken a trip outside of NC since 2015 ... so yeah, i'm kinda overdue here! thinking maybe heading down to visit uncle and family in south FL for the 4th of july. we'll see!

    have fun and be safe!! ;)
     
    Three Eyes likes this.
  2. Three Eyes

    Three Eyes 2018 Stockaholics Contest Winner

    Joined:
    Dec 14, 2017
    Messages:
    565
    Likes Received:
    498
    Thanks for the "bon voyage" and good wishes @bigbear0083 !

    Oh, man, you truly are overdue! And early July would be perfect before hurricane season starts messing with Florida.

    Have a GREAT summer!
     
    T0rm3nted and bigbear0083 like this.
  3. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    15,592
    Likes Received:
    4,943
    jeebus, still having issues here with some tickers not pulling in historical prices past 5/17, and i have still yet to find a reliable workaround ... i'm not a big fan of implementing add-on's :confused:

    going on the google docs support forums has been absolutely zero help...no one has a dang clue what is going on. :rolleyes:
     
  4. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    15,592
    Likes Received:
    4,943
    looks like all is well again on the historical data front ... but still looking around for a reliable workaround that doesn't require an add-on in google sheets. have still yet to find one.

    meanwhile, i just saw this post on the google docs help forums in response to another user who was complaining about this same issue.

    seems to answer the question regarding the intermittent missing historical data.

    [​IMG]
     
  5. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    15,592
    Likes Received:
    4,943
    ok, so is it just me or are any of you not able to pull prices for the SPX in google finance anymore?

    i used to be able to pull under the ticker .INX but it's returning #N/A for me using the google finance "price" formula. da fuq? :confused:

    interestingly enough, i noticed it was no longer showing up on the google finance main page as of this morning.

    i'm hoping that this is just some sort of glitch on their end that will get corrected soon, or maybe it's now under a new ticker that i'm not aware of?

    can anyone confirm? thx in advance!

    [​IMG]
     
  6. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    15,592
    Likes Received:
    4,943
    ^^ hah! well looks like this may have been nixed (or at least according to some on their support forums) which if indeed is true, is probably the beginning of the end for google finance as we know it... sad.

    miss the old google finance :(
     
  7. stock1234

    stock1234 2017 Stockaholics Contest Winner

    Joined:
    Apr 3, 2016
    Messages:
    3,656
    Likes Received:
    2,432
    That’s sucks :( Will you able to pull the live prices from another source for the contest here Cy?
     
  8. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    15,592
    Likes Received:
    4,943
    for the moment it doesn't actually appear to have spread into the individual stock tickers (yet!) but i suspect that may very well come to fruition at some point in the future. i certainly hope not! but, truthfully nothing would surprise me at this point with google finance...sadly, they have been quietly making changes and removing things under the hood the past year now. :confused:

    at any point our spreadsheets for the competitions could indeed stop working.

    as for if i'm able to pull live prices from another source. there is actually another data feed that i can use, in fact i gave it a test run a few months back if you might recall. it was called "iextrading". only drawback to using that source is that the prices are not live, and they don't auto update if you have the spreadsheet opened throughout the day. this one requires a "page refresh" to get the latest prices. that is a big time pain in the ass if you ask me. :confused:

    i guess we'll just have to play this by ear and see what transpires in the days/weeks/months to come.

    i'd really hate it if we had to close down the competitions for good. i'm going to try spending some time perhaps over this coming weekend to dig deeper into looking for other data feeds and see if there is anything that might work with google sheets, even if it is really delayed. i'll take whatever we can get to keep our comps up and running for the remainder of this year at the very least.

    edit: oh and another thing that would really suck if google finance stopped working is the "historical price data" which i rely heavily on for our members stock picking records spreadsheets. if google ever decided to pull the plug on this (which is very possible) then we lose all member stock picking records.......this includes the stock picking winners lists, as well as the individual records.

    the only thing that i could continue running here in the event that google finance went to shit are the market direction polls. at least with that i'm not relying on google finance's data feeds! so, at worst case scenario i could still keep running the market polls indefinitely if nothing else.

    i'll try to keep you guys posted on the latest...for now i think we're okay. but, for how long? idk... o_O
     
    rStock and stock1234 like this.
  9. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    15,592
    Likes Received:
    4,943
    whelp, scratch that! looks like it was just a "glitch" thankfully, which seems to have been corrected today.

    [​IMG]
     
    Three Eyes and stock1234 like this.
  10. stock1234

    stock1234 2017 Stockaholics Contest Winner

    Joined:
    Apr 3, 2016
    Messages:
    3,656
    Likes Received:
    2,432
    Good news :)
     
    bigbear0083 likes this.
  11. bigbear0083

    bigbear0083 Content Manager
    Staff Member

    Joined:
    Mar 29, 2016
    Messages:
    15,592
    Likes Received:
    4,943
    I think today might be the first time I have ever experienced an issue with Google Finance's live data feed...I usually only had issues with its "historical" data feed in the past, but today (as was noted here) the live data feed was actually down (and still is even now up to this point). :eek:

    I'm sure this has been brought up to the GF team, and hopefully they'll have it resolved soon enough.

    I had to resort to using a delayed data feed from IEX for the contests today. Not the greatest of workaround but better than no data feed at all.

    The contests (or the spreadsheets I use for them) rely heavily on this data feed for live pricing. When that goes down, the contests are essentially in the dark like they were for a good part of this morning.

    What a terrible timing for the outage too as we're on month end trading today.
     
  12. Three Eyes

    Three Eyes 2018 Stockaholics Contest Winner

    Joined:
    Dec 14, 2017
    Messages:
    565
    Likes Received:
    498
    I've been out most of the day, but here at end of trading day, GF seems to be up and running again. :)
     
    bigbear0083 likes this.

Share This Page