Chart points into Excel

[DugDug]

Hi,
in brief does anyone know of a charting program that i can link to an excel spreadsheet that picks up chart line values.
(many offer indicator valeus - but i am after my values)
Basically i find myself, checking a chart, picking my levels then enetering those into excel as my alert system. Rather than typing them i was looking for a system that allowed me to say have a horizontal line or lines that correspond to an excel cell. that way when i move the line on the chart it updates the excel cell (or if you update the cell the line on the chart updates).
I guess i am looking for a system that allows me to save a lot of time or lloking, enetering and then changing values. Ideally if the excel values and the visual chart lines are all able to be updated at one hit then it would be fantastic.
thanks for any help in this regard.

 

[abottoml]

Perhaps you will need to get the price action into Excel and then mathematically derive your "levels" from there.

If you're prepared to go down this path, then this suite of Excel functions/macros is extremely powerful:

Portfolio optimization, asset allocation, portfolio analysis and risk management tools by Peter Hoadley

 

[DugDug]

thanks for the reply, i already have used the hoadley options package for a few years.....i highly recomend them, accurate, easy to use and very detailed.
But my probelm is exactly the point you make .....getting the values into excel. thats what i am trying to automate in some way. i want to be able to draw a horizontal line on a chart and have excel pick up the value of that line and am looking for a charting programm that has this feature.
once the values are there i have numerous macros etc that derive all sorts of portfolio functions i require.