stocks

  1. J

    Flash/Blink Cell Color Based on Live Changing Values while Keeping Background Color of the Cell the same.

    I have this excel document with a Finansu Add-in that pulls live stock feeds from Google Finance. As of now, if the % change is negative overall then the cell is red and if it is positive it is green. I want to find a way to make it so if the stock changed from 1% down to .5% down the cell will...
  2. D

    Automated Stock Prices?

    I have a web query of stock quotes in one worksheet and I want to know how to continuously refresh its' contents. Does anyone have an idea as to how I can go about doing this?
  3. H

    Charts

    I create several stock charts using excel 2007, I include in the chart the "moving average", after I include it in the chart the information is "compressed" meaning that the information in the X axis (20 columns) is compressed and in a few columns (3 columns) so you can not read the chart. But...
  4. H

    Updating a sheet

    I have several sheets in a workbook, the first one is called "daily", the others are called "stock1", "stock2", "stock3",...., "stock20". In the sheet called "daily" I paste everyday information abouth the sheets "stock1", "stock2", etc. This is the information I copy in the "daily" sheet...
  5. C

    Matching data from two or more timeseries

    Hi there, I have a number of timeseries (stock prices closing prices) which have different date ranges due to the fact that exchanges are on holidays at different times. I need to figure out a way to quickly "match" these timeseries so that the dates and line up with each other. I would...
  6. J

    Code to get Excel to record the value in a cell(updated daily) into a database

    I am new to excel (excel 2011 for Mac OSX) I set up MSN stock tracker so that on "Sheet 2" I have the MSN app and on "sheet 1" the company names in Column 1 and the price in column 2 - The cells in sheet one update every time I refresh MSN data. Looks like this.... ..........A.......B...
  7. T

    Stock Moving Averages

    I am trying to build an excel formula for doing some basic stock analysis. I found a way for excel to automatically link with MSN money and import LIVE basic stock quotes. What I am now looking for is a way to calculate the current 200 and 50 day moving averages of the stock price without...
  8. R

    storing trading data

    dear programmers, i am using excel 2007, and i was hoping if someone can help me. i am using DDE stock quotes from think or swim. i want to capture the quotes and have them being stored so i can run some analysis on the data. below is what i want to accomplish: SHEET1 column A column B...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top