SI
SI
discoversearch

   Technology StocksMicrosoft Corp. - Moderated (MSFT)


Previous 10 Next 10 
From: louisaricci7/19/2017 2:02:56 AM
   of 19150
 
The data glitch on the stock prices appeared on several platforms including Yahoo Finance, Google Finance and on Bloomberg terminals. Several stocks briefly showed the stock price to be at $123.47 which is equivalent to a 14% drop in Apple’s shares, a whopping 87% drop for Amazon and a 70% surge Microsoft Stocks.

Share RecommendKeepReplyMark as Last ReadRead Replies (1)


To: louisaricci who wrote (19089)7/19/2017 2:12:18 AM
From: FUBHO
   of 19150
 
This is the second time in a couple weeks. I know that that these data providers have all sorts of legal clauses, but somebody must have lost money from this bad data. They really need to get their acts together.

Share RecommendKeepReplyMark as Last Read


To: Kirk © who wrote (19076)7/20/2017 1:28:04 AM
From: Jurgis Bekepuris
   of 19150
 
Let us know if you learn how to replace this functionality.
I was also using it and it's a big loss.

I'm also using ogres-crypt.com but its data sources are also unreliable, change, disappear, do not update once in a while. So it's possible to use it as replacement, but not reliably so.

Share RecommendKeepReplyMark as Last ReadRead Replies (2)


To: Jurgis Bekepuris who wrote (19091)7/20/2017 9:26:20 AM
From: PMS Witch
   of 19150
 
I've been using Google to get stock quotes. Here's a link one can try. It returns a bit of a mess, but the data's there. It should be a trivial exercise to automate the extraction of what you need.

Note: Remove the periods from h.t.t.p before using. (I needed to alter the string so SI wouldn't recognize it as a link and "help" by altering it.)

h.t.t.p://finance.google.com/finance/info?client=ig&q=NASDAQ:MSFT

Cheers, PW.

Share RecommendKeepReplyMark as Last ReadRead Replies (1)


To: Jurgis Bekepuris who wrote (19091)7/20/2017 10:53:01 AM
From: Kirk ©
   of 19150
 
Currently I've been experimenting with GoogleFinance function in Google Docs. =googlefinance(D$3,$A$5)
Let us know if you learn how to replace this functionality.I was also using it and it's a big loss.
It is superior to the old MSN lookup as it :
  1. is a function that you call in a cell not some special look-up that is buggy and often freezes worksheets.
  2. seems to update every minute with real time data AND
  3. it will pull down a quote for the Dow which an add-on I have as a workaround doesn't pull.

I'm not a big fan of having to use Chrome to do spreadsheets, but since my spreadsheets are already backed up in the Cloud at Google (since MSFT was too unreliable and kept making changes, I only trust MSFT for backing up my music which is also backed up by Google) I can live with Chrome/Google knowing what stocks I'm interested in...

I'm writing my newsletter this week so quite consumed, but next week I'll see if I can port some of my more complex and important sheets to Google Docs and if the charts I generate from the data still work.

Share RecommendKeepReplyMark as Last ReadRead Replies (3)


To: Kirk © who wrote (19093)7/20/2017 11:03:04 AM
From: Don Green
   of 19150
 
(I only trust MSFT for backing up my music which is also backed up by Google)


Kirk


How do you backup your music with MSFT? Also how much music are you backing up?

I use Apple Itunes Match for my music, I have 200+ gigs of music which I also store / back-up on my onedrive.


Don

Share RecommendKeepReplyMark as Last ReadRead Replies (1)


From: JakeStraw7/20/2017 12:06:09 PM
   of 19150
 
Microsoft unveils a Cortana-powered thermostat
techcrunch.com

Share RecommendKeepReplyMark as Last Read


To: Don Green who wrote (19094)7/20/2017 12:33:30 PM
From: Kirk ©
   of 19150
 
One Drive.

I'm old fashioned. I buy CDs, rip them to hard drives on my PC and my BMW X3 then copy them to flash drives for my windsurfing van. The Pioneer head unit in my van is cool. It lets me quickly switch from Radio (I listen to sports talk or traffic), SD, Flash and a single CD. So, I can have four different items cued up that I can switch to depending on mood. If i use it to make a call while driving, it lowers the sound of the onboard music while using the phone to make a call with a microphone on the windshield. If I were to use my unlimited wireless plan, it is too many touches of the phone plus there is no background music while making a call since it only does one thing at a time over Bluetooth.

Share RecommendKeepReplyMark as Last Read


To: Kirk © who wrote (19093)7/20/2017 12:53:17 PM
From: E_K_S
   of 19150
 
I use Google Sheets and they have "import" functions that you can scrape from Yahoo Finance, Google Finance and/or pretty much any web site (or URL).

I have been experimenting w/ "importXML", load a company's data into a specific data sheet, then populate another sheet where I calculate different metrics. There are a lot of examples out there. Google even has many free Ad-On's that work w/ Google Docs and/or Google Spreadsheets.

The Ad-On Apps are simple to use but allow a lot of flexibility in stocks you want to track and monitor.

You can even upload excel spread sheets into Google Sheets and then re-map/replace the import data cells using the Google import data functions. That way you use the original spread sheet you designed.

In the cloud you can share spread sheet w/ other people and/or have it updated every time you open the spread sheet in your browser (I use the Chrome Browser).

There is lots of flexibility in their platform (I have a Google Drive in the cloud and sync to my PC). Also, you can launch a google spread sheet to one or more of your devices (PC, tablet, smart phone) by installing the Google Cloud App on one or more of your devices.

EKS

Share RecommendKeepReplyMark as Last ReadRead Replies (1)


To: E_K_S who wrote (19097)7/20/2017 1:17:06 PM
From: Kirk ©
   of 19150
 
Thanks. I just loaded my newsletter into a sheet I built that has all my daily stuff so I can cut and paste the data into Excel sheets while I work on porting them over. Google Docs is very well thought out and it is quite obvious that their plan to hire all the smart folks left a huge vacuum at places like MSFT. It is hard to believe a company as large as MSFT would not have many users of Excel WHO WORK THERE complaining about the lost ability to get current stock info imported into sheets.

One thing that impresses me with Google, and why I bought at $150 some years ago after it proved itself and had its first major bear market to give a good entry price, is they seem to anticipate well "what I'd like to see" be it Google Maps or Google's version of Excel. Clearly, MSFT is lacking in this so it is a good thing they pay a nice dividend.

Share RecommendKeepReplyMark as Last ReadRead Replies (1)
Previous 10 Next 10 

Copyright © 1995-2017 Knight Sac Media. All rights reserved.Stock quotes are delayed at least 15 minutes - See Terms of Use.