compoundinglife Posted December 31, 2017 Share Posted December 31, 2017 I went to knock the dust off of some of my code for screening and analyzing companies. I used to use the free yahoo and google finance APIs to get 20 minute delayed quotes. It appears as though both of though APIs have shut down. All I want is a simple 20 minute delayed quote for a ticker. I have looked at quandal and the yahoo csv download that is still available. These are great for EOD data but not if I want to get a somewhat current quote. Does anyone know of anything still available without a subscription? Link to comment Share on other sites More sharing options...
rukawa Posted December 31, 2017 Share Posted December 31, 2017 Not sure what the best is. But one solution is to use xpath to screenscrape prices off bloomberg. Find mine here: http://www.cornerofberkshireandfairfax.ca/forum/general-discussion/excel-addin-to-pull-prices-from-bloomberg/msg315889/#msg315889 And find the Google method here (see Writser comment) http://www.cornerofberkshireandfairfax.ca/forum/general-discussion/google-spreadsheet-tips-and-tricks/40/ Link to comment Share on other sites More sharing options...
compoundinglife Posted January 1, 2018 Author Share Posted January 1, 2018 Not sure what the best is. But one solution is to use xpath to screenscrape prices off bloomberg. Find mine here: http://www.cornerofberkshireandfairfax.ca/forum/general-discussion/excel-addin-to-pull-prices-from-bloomberg/msg315889/#msg315889 And find the Google method here (see Writser comment) http://www.cornerofberkshireandfairfax.ca/forum/general-discussion/google-spreadsheet-tips-and-tricks/40/ Thanks rukawa. I was hoping to avoid screen scraping but it looks like that might be my only choice. It was nice when I could I just use the yahoo or google finance APIs available in for various programming languages. Link to comment Share on other sites More sharing options...
gokou3 Posted January 1, 2018 Share Posted January 1, 2018 http://ogres-crypt.com/SMF/ This stopped working a while back, but has worked again with the nov update. Link to comment Share on other sites More sharing options...
oddballstocks Posted January 1, 2018 Share Posted January 1, 2018 https://www.alphavantage.co It’s realtime with 20 year history. You have to write code to call and parse, but it sounds like you already have that. Link to comment Share on other sites More sharing options...
compoundinglife Posted January 2, 2018 Author Share Posted January 2, 2018 http://ogres-crypt.com/SMF/ This stopped working a while back, but has worked again with the nov update. Thanks Gokou3, I remember this from the original spreadsheet that Old School Value used to release. I am not using Excel so it does not help me at the moment. But will keep in my notes for future reference. I am looking for real time or delayed quotes in either the Python or Java programming languages. In the past I had used publicly available libraries/apis but they all seem broken now since Yahoo and Google finance are stopping their services. I can write my own code to screen scrape fairly easily but that tends to be brittle so was looking for something a little more stable. Link to comment Share on other sites More sharing options...
compoundinglife Posted January 2, 2018 Author Share Posted January 2, 2018 https://www.alphavantage.co It’s realtime with 20 year history. You have to write code to call and parse, but it sounds like you already have that. Thanks! This appears to be exactly what I am looking for. It seems from their intraday API you get a time series and just pull the latest one for a realtime or near realtime quote. Its JSON so that is great. I also found opensource client libraries available. Thanks Oddballstocks. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now