Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare cells using real time streaming data
I am a trader and I currently use Excel to help me determine when I should
enter and exit trades. I would like to find a way to compare my Profit and Loss on a real-time basis so that I know how much I have been up and how much I have been down. With this, I will use P-n-L management to help me exit all my positions when the P-n-L on these trades falls a certain percentage. Is it possible to create a graph that will show the high and low of a cell's value, even if it has changed quite frequently? What I want to do is have the high value and the low value both printed in a separate and then plotted on a graph with the current pnl value. I have tried to get the value using 'IF' statements, but it isn't working. Such as: =IF(K24J24,CELL("contents",K24),CELL("contents",J 24)) Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capturing Real Time Data | Excel Worksheet Functions | |||
creating dataseries from real time data | Excel Worksheet Functions | |||
storing real time data | Excel Discussion (Misc queries) | |||
How freeze streaming data at specific point in time? | Excel Discussion (Misc queries) |