stock market

Would anyone know how to compile the history of the Dow Jones (either from inception or say the past 20 years) where I could figure out probability of stocks going up two times and then down once AND ALSO three times up and then down once. Here are the 2 questions and patterns I am looking to...

With the intention to help those struggling to find stock names and symbols for Data Types | Stocks, I put in some effort. I have uploaded to OneDrive a file containing all the stocks in the TSX Composite, the Dow Jones Industrial Average, the S&P500 and the NASDAQ100, current as of December 29...

I am an expeienced VBA programmer. I have been researching like crazy to see if I can find an API that would support VBA. The only one I found doesnt exist anymore. I want to buy and sell stocks from the stock market automatically when I initiate a VBA macro and leave the house to let it do...

Hi, I presently dl historical data from Google Finance for stocks. I copy and paste to excel. In excel, I have formulas from the downloaded data, that I graph (I graph the formulas). I track 2,000 stocks. Of course, my graphs are updated only when I paste the downloaded stock data. Is...

I have been having a heck of a time finding specific stock information and bringing it into Excel. I am aware of the formulas that allow you to bring in certain Yahoo Finance information. That is helpful for some of the variables I am working with, but I still have a few pices of info I can't...

Hello, I am trying to calculate stock market returns over different periods. I have downloaded the daily index values from yahoo finance for the S&P 500 and the Russell 2000 index. I would like to start with the 1 year, 3 year and 6 year rolling periods. This is difficult because the data...

Hi guys! Here's my problem: I have some huge txt files (~700k lines) with csv data from stock prices. One of the columns is the name of the company. So I want to get only the lines of certain companies. I actually already have a solution, but it is taking too much time. I think it may take...

Im just getting to grips with macros and VBA in excel im trying to find an automated way to see if there are any correlations between 2 (or more stock) prices ie. Stock A's price moves -> Stock B's price tends to do this Im at a bit of a loss as to were to start with this, could someone...

I have a stock chart (open-high-low-close candlesticks). In excel on my PC, I have no prob. However, on skydrive, under menu Insert----Chart, there is no option for stock chart. I do not wish to edit it on a local PC. (wish to open in webApp only). Any idea how it might be implemented? Thanks...

Thank you for reading my post. I am using Excel 2010 on Windows 7. I work in the purchasing department and have been asked to develop a dashboard to monitor supplier performance. One of the metrics I would like to include is stock performance. I would like to include a line graph of...

Very simple issue here. I come update my excel everyday after the stock market closes, but I have to many entries to manually update. I need a one or two click solution. In A1 I have a ticker symbol, and in B1,C1,D1,E1,F1 I want to show the percent change 1,2,3,4, and 5 days after I post the...

Hello everyone, I have two data series (two columns, ~600 rows long each; one is the monthly closing price of a stock index and the other is a macroeconomic indicator) and I'm looking to find out some information between them (the lead/lag times). I need to figure out how to: - determine...