HomeНаука и техникаRelated VideosMore From: APMonitor.com

Analyze Stock Data with Microsoft Excel

90 ratings | 17339 views
Visualization of data is a powerful method to see trends and make decisions. Microsoft Excel trending capabilities are tools to visualize large data sets, such as financial information on company performance.
Html code for embedding videos on your blog
Text Comments (11)
Johnny Ilca (24 days ago)
Excel is great at all sorts of data analysis!
Prem Sai (1 year ago)
APMonitor can i get connected you.. i need your help in analyzing Twitter.Inc stock
APMonitor.com (1 year ago)
Unfortunately, I can't help with all the requests I get through the YouTube channel. You are welcome to contact [email protected] if you need help with the APMonitor software.
Ammar Ali Arif (1 year ago)
why are you normalizing the data?
APMonitor.com (1 year ago)
+Ammar Ali Arif, normalizing isn't required but it does help to see fractional growth of a stock and compare the different growth profiles directly on the same plot.
Mike Doody (1 year ago)
Great video!
Adam Magnusson (1 year ago)
Hi! I've a question. When I open the file in Excel it won't split Date/Open and the other one to each individual block instead all goes in A1. What have I done wrong?
Adam Magnusson (1 year ago)
It worked! Really appreciate your help!
APMonitor.com (1 year ago)
Adam Magnusson, yes, just select the entire column.
Adam Magnusson (1 year ago)
APMonitor.com Great! Can I do it with all rows at the same time?
APMonitor.com (1 year ago)
The data can be split into columns by selecting the column A and then select "Data" from the top menu and then "Text to Columns". It will give you a dialog box that will walk you through selecting the delimiters.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.