T
TAlgo
All,
Sorry but need some quick help in this project. I was told to create a
quartile chart for last one year of closing price of Soybean
Commodity. I am going to paste small data set here. Can someone please
guide how to show quartiles as vertical lines in a chart?
Also someone please suggest what should be X axis and Y axis values
here?
Date Close Price
1/1/2009 38.36 Quartile 1 60.7825
1/2/2009 43.4 Quartile 2 67.27
1/3/2009 45.34 Quartile 3 76.9675
1/4/2009 46.49
1/5/2009 49.12
1/6/2009 49.5
1/7/2009 50.5
1/8/2009 51.13
1/9/2009 51.8
1/10/2009 51.86
1/11/2009 51.91
1/12/2009 51.97
1/13/2009 52.44
1/14/2009 52.76
1/15/2009 53.06
1/16/2009 53.36
1/17/2009 53.47
1/18/2009 53.6
1/19/2009 53.63
1/20/2009 53.67
1/21/2009 53.7
Sorry but need some quick help in this project. I was told to create a
quartile chart for last one year of closing price of Soybean
Commodity. I am going to paste small data set here. Can someone please
guide how to show quartiles as vertical lines in a chart?
Also someone please suggest what should be X axis and Y axis values
here?
Date Close Price
1/1/2009 38.36 Quartile 1 60.7825
1/2/2009 43.4 Quartile 2 67.27
1/3/2009 45.34 Quartile 3 76.9675
1/4/2009 46.49
1/5/2009 49.12
1/6/2009 49.5
1/7/2009 50.5
1/8/2009 51.13
1/9/2009 51.8
1/10/2009 51.86
1/11/2009 51.91
1/12/2009 51.97
1/13/2009 52.44
1/14/2009 52.76
1/15/2009 53.06
1/16/2009 53.36
1/17/2009 53.47
1/18/2009 53.6
1/19/2009 53.63
1/20/2009 53.67
1/21/2009 53.7