SI
SI
discoversearch

   Technology StocksMicrosoft Corp. - Moderated (MSFT)


Previous 10 Next 10 
To: Kirk © who wrote (19093)7/20/2017 12:53:17 PM
From: E_K_S
   of 19127
 
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 19127
 
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 19127
 
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 19127
 
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 19127
 
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 19127
 
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


From: JakeStraw7/21/2017 10:57:08 AM
   of 19127
 
Microsoft Corporation had its price target raised by analysts at BMO Capital Markets from $75.00 to $86.00. They now have an "outperform" rating on the stock.

Share RecommendKeepReplyMark as Last ReadRead Replies (1)


To: JakeStraw who wrote (19103)7/21/2017 11:10:56 AM
From: Don Green
   of 19127
 
price target raised by analysts at BMO Capital Markets from $75.00 to $86.00


Most likely done by a computerized analysis


Computerized algorithms are quickly replacing single-stock analysts and investors, leading to big changes in the way the stock market will value companies and increasing the chance that software glitches or hack attacks will jeopardize market stability.


Technological forces—including high-frequency trading, an explosion in exchange-traded funds and the proliferation of free information via social media—are behind this seismic shift, according to Nicholas Colas of ConvergEx Group.

"The changes that started with high-frequency and algorithmic trading are just the first step to an entirely different process of determining stock prices," Colas wrote in a sweeping note to clients Monday. "Will an equity market running on algorithmic autopilot serve to tie the managers of capital (senior executives) to the ultimate owners (shareholders) as robustly as one dominated by flesh-and-blood money managers? It seems a stretch to think so."



In other words, we've come a long way from the days of the Buttonwood tree and Benjamin Graham.

Share RecommendKeepReplyMark as Last Read


From: Eric L7/22/2017 10:30:43 AM
2 Recommendations   of 19127
 
The Cloud Game (Business Insider) ...

Below are the openining and closing paragraphs of a very good long article. IBM and Oracle are discussed as well as the big 3.


>> The cloud wars explained: Amazon is dominating, but Microsoft and Google are striking back

Matt Weinberger
Business Insider
July 22, 2017

businessinsider.com

The cloud computing market is dominated by some familiar names. Amazon's cloud service is its most profitable unit. Microsoft has pegged its future to its cloud computing businesses, leading to a very enthusiastic response from Wall Street. Google, too, is betting big on cloud computing as something that could be bigger than its advertising business.

What exactly are these companies selling? Who's buying it? And why is one company that wasn't even in enterprise technology a decade ago — Amazon — beating the pants off everyone else? Here's the state of play in the cloud game.

The most important concept in cloud computing is "hyperscale." To support their own websites and services, Amazon, Microsoft, and Google have all built a ton of computing infrastructure. Their data centers are vastly bigger — and way more efficient — than those operated by or could be built by most other companies. ... <Big Snip>

there's clearly not space in the market for everyone, and there have already been some shakeouts. GoDaddy just sold off its cloud computing division. Early cloud provider Rackspace pivoted to offering support for others' platforms, and HP and VMware both threw in the towel entirely. It's expensive to compete with Amazon. ... Amazon and Microsoft have the no. 1 and no. 2 slots locked down for at least the next few years. "The fight now is for no. 3" ... {In a few years]"Amazon will still be the leader, and Microsoft will have closed the gap to be a strong second" <<

Full article at link above.



- Eric L -

Share RecommendKeepReplyMark as Last Read


From: Don Green7/22/2017 7:22:13 PM
   of 19127
 
Windows 10 is SHARING your files with the internet - here's how you can stop it

express.co.uk

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.