stock market

  1. DRSteele

    North American Stock Market Indexes with 52-Week Performance Chart

    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...
  2. WarPigl3t

    Excel VBA buy and sell stock market API

    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...
  3. E

    using Excel for Stock Market Graphs - simplify/automate?

    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...
  4. A

    Stock information into Excel

    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...
  5. M

    Stock market rolling period returns

    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...
  6. S

    Delete rows that contains certain text - fastest way

    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...
  7. P

    Finding corrolation between 2 (or more data sets - stockprices)

    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...
  8. D

    chart on skydrive

    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...
  9. P

    Real Time Stock Price Graphs

    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...
  10. T

    Fill down stock informatio

    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...
  11. H

    determine lead/lag times between data series

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back