stocks

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

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?

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

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

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

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

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

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