SI
SI
discoversearch

   Technology StocksMicrosoft Corp. - Moderated (MSFT)


Previous 10 Next 10 
To: Jurgis Bekepuris who wrote (19091)7/20/2017 10:53:01 AM
From: Kirk ©
   of 19128
 
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 19128
 
(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 19128
 
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 19128
 
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 19128
 
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 19128
 
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)


To: Kirk © who wrote (19098)7/20/2017 1:28:43 PM
From: E_K_S
1 Recommendation   of 19128
 
Here is a link to The Grahm No. Valuation Model built using Google Sheets Notice the Data and Set-Up tabs at the bottom of the main sheet. You can see how all the Yahoo Finance data is loaded in Set-up and the specific company ticker Yahoo URL in the Data Sheet.

There are a lot of very powerful features. Google Sheets even has the hooks to run scripts, similar to what MSFT does w/ virtual basic.

Google Sheets allows Python and other programming scripts.

Try uploading one or more of your Excel spreadsheets into a Google Sheet and just see if it works and/or you need to edit some of the formulas.

I have done this for a few sheets out on the Internet and most worked. Only those with scripts had a problem working but i did not drill down into the scrip to see what was the issue. I was able to launch the Google script editor that is part of the tools option in Google Sheets.

Good luck.

EKS

Share RecommendKeepReplyMark as Last Read


To: PMS Witch who wrote (19092)7/20/2017 2:58:08 PM
From: Jurgis Bekepuris
   of 19128
 
Thanks, but this does not work for me. I need things like company market cap and this does not provide it.

Share RecommendKeepReplyMark as Last Read


To: Kirk © who wrote (19093)7/20/2017 3:00:39 PM
From: Jurgis Bekepuris
   of 19128
 
Thanks, but I have to use Excel, I cannot port to Google Sheets. I have >300 Excel spreadsheets (spreadsheet per company) and porting them all to Google sheets would be nightmare.

Also, I don't need quotes. Quotes are easy to get. I need things like market cap.

Share RecommendKeepReplyMark as Last ReadRead Replies (1)


To: Jurgis Bekepuris who wrote (19101)7/20/2017 3:21:02 PM
From: Kirk ©
   of 19128
 
Please keep us posted if you find an acceptable solution. I'd rather not spend the time to port my Excel sheets over....

Share RecommendKeepReplyMark as Last Read
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.