stock market

  1. W

    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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top