This may be somewhat of an advanced question and maybe it better belongs in some other category.
Anyway, let's say that I have a statistical projection for the high and low of the first two hours of the trading day plotted in Excel.
For instance, it may look like this for two entries:
09:30
1947,25
1939
10:30
1945,00
1937,50
Here, we have timings on top and then High/Low respectively below that. I'd like to have thsese price levels drawn on my chart. Of course, I could simply draw this by hand.
But is there a way I could automate the drawing of this projection in Excel? It could be either a horizontal line or dots?
I realize perhaps this is something I need to program as an indicator, but any help towards that or otherwise would be appreciated a lot.
Best,
Johnny
Comment