Does anyone have a chart that they use to track stock investments, which shows the price history (that part is easy) but also the Buy and Sell points on the chart?
Thanks
Phil
I have created a stock price bar chart [high, low and close] and a spread sheet column of 9 day moving average values of the closing prices.
If it is possible, how do I plot the moving average of the prices on the chart?
Hope everyone is well. I turn to your expertise for assistance with the following two items - any and all help will be greatly appreciated.
I'm trying to create a dynamic stock chart that returns only the 120 most current values in column(D). D1 is the header, and D2:D6 are empty due to adjacent data-sensitive formulas. Data formally begins at D7 and ends at D759. The desired chart series would initially be D:640,D:759. What would be the necessary steps / formula to create a dynamic chart that would continue to 'roll' as new daily-data is entered?
Finally, using the same data range requirements, how would I have H2 for instance, continually calculate the Average of this dynamic series?
The attached file contains all the above information, and any I may have omitted. Thanks for your time and any help.
-Chris
I am new to this fourm and ne wto excel world . but have tried a lot to solve the problem by myself but in vain
what i require is in the excel sheet ( whihc takes streaming data from nseindia.com) is if
1 LTP is greater or equal to my price alert given in certain col L/ give a sound alert and colour alert with true and fasle
i have tried ,,some coding with true / false through conditionla setting but the problem is sound ,,,alert if LTP is greater then col L
and second the cells whihc are taking adta form sheet 1 are reshuffling so my alerts get messed up
can anybody help me
( no options for attaching file!!!!)
http://rapidshare.com/files/31249478...NSE50.xls.html
renu
I'd like to be able to to adjust bar widths on an open-high-low-close stock chart (AKA: candle chart). This is possible to do on a column chart, but I'm not able to find a way of doing it on this particular chart.
To bring this chart up, first paste the following example data into your spreadsheet and select all of it:
111.20 111.74 109.09 109.21
113.92 114.27 111.56 111.70
114.28 114.45 112.98 113.89
113.62 115.13 113.59 115.06
114.73 114.84 113.20 113.64
114.49 115.14 114.42 114.93
113.95 114.94 113.37 114.62
113.97 114.21 113.22 113.66
115.08 115.13 114.24 114.73
Then:
insert -> other charts -> all charts -> stock chart -> select second one from the left.
it should read "open-high-low-close" when you hover over it's icon.
What I'd like to do is make the bars 50% wider or so. If it is not possible to do it with standard excel commands, is there a way to program this with basic?
Thank you.
Hello-
I am trying to figure out how to scale stock prices in excel while drawing charts. For example, if we have bunch of stocks that have values ranging from $1 to let's say $700. The instructions state:
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12">
Translate all stock prices to the same scale, starting at 100, and plot a single time series graph with the re-based stock prices on the left-hand scale and the index (not re-based) on the right hand scale.
So if I have prices of stock in one column how do achieve this in the adjacent column to satsify the instruction above?
I can draw the time series graph, it is just scaling I am having an issue with.
Hey guys I've been searching around for plugins and such to allow me to get automatic update on stock prices for my portfolio spreadsheet.
The most popular one seems to be the MSN money stock quotes plugin but the link does not seem to be working, I've tried for days....
Is there any other good ones to use? Anybody know?
When I add a new series to an Excel stock chart, the added series has stretched some of the high-low lines of the stock H-L-C bars. (they are stretched so as to meet the value of the new series)
Bob Peltier describes on a webpage how to deal with this for some circumstances. However, the example he shows to create a chart with H -L-C bars with an added series is not detailed well on this webpage so I don't understand what he did to get the H-L-C chart with the Index that he shows. It is not clear to me how to fix the problem. The webpage is:
http://peltiertech.com/Excel/Charts/StockChartPlus.html
Maybe I missed something.
Can anyone in this forum offer a suggestion?
Thanks,
Art
I was using the MSN Money add-in in excel 03 to download stock prices into an excel sheet, but haven't been able to get the add-in for 07. Does anyone know of a free way to pull multiple stock prices into a workbook? Delayed quotes are fine and I don't mind having to manually update prices several times a day, I just want a group of prices to pull into a sheet at least one a day. I've set up the getting external data from a webpage, but that pulls in way more info than I want. I just want the price to pull into one cell and be able to have multiple tickers working. Thanks
