How to get Monthly ROC Value on certain Month & Year

[edi]

Hi All.

Please help me with this one



I can get This month Close Price using this 
m0 = TimeFrameGetPrice( "fc", inmonthly, 0 );


and previous month using
m1 = TimeFrameGetPrice( "fc", inmonthly, -1 );


then calculate the ROC
ROC0 = 
 ((m0-m1)/m1)*100 ;


How can I produce this kind of table 

XYZ sample random data

today March 10th,2018
Monthly Price Rate of Change ROC (%)

	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
2016	1.9	2.7	-3.1	1.2	4.1	2.2	-0.1	-1.2	0.8	2.0	0.3	0.1
2017	-0.1	0.3	1.5	0.4	2.1	-1.6	-0.9	2.3	-0.2	-1.3	0.5	4.1
2018	2.3	-0.8	-0.3

1. Is there a better solution to get i.e  2016 February Monthly ROC or certain month & in certain year?
2. and how to get certain date ROC,i.e   February 3rd, 2016

Thank you very much

[Admin]

Output on chart?
Take a look at Gfx Profit table example of Report Charts folder.

2. and how to get certain date ROC,i.e February 3rd, 2016

See Lookup function

[edi]

Thank you very much Admin,








and Thank you for fast response and pointing out straight to the answer. 

Still working on it,but already gave me the result that I want.