Off-topic MT4/mql4 questions. - page 27

 
leonid553:

Hello, everyone. The question is this.

There are several graphs. For example:

You need to use these graphs to draw their arithmetic mean curve! Apart from the graphs, there is nothing initially. No formulas, no numerical coordinates. Nothing. Just a scale on the side. And a time axis with equal time intervals.

If there is a program that can draw the arithmetic mean curve over several (up to 10) charts? If so, please give me a link or a name.

The first thing that came to mind. Is to take some circular time scale values (X axis). I transferred their values manually to the excel table. Then you can plot the resulting curve.

In essence, the X axis will be the same for all, i.e. the time period is the same. The Y-axis will have different values at a selected (circular) point in time.

Further summarize the values of these graphs from the Y-axis for 10 years - there will be 10 graphs and already build a summary table (through this formula). Next, use this table to draw the final graph.

This is a time-consuming and rough (depending on the step of the time scale) solution, which allows estimating the character of changes of spread instrument returns for a certain period of time.

 

Yes, manually is time-consuming.

In the end, I (for example) want to get a graph of averaged multiyear seasonal trends in a certain area (which I can construct myself on a special website), something like this:

- Here the arithmetic mean of the 5 and 15 year lines is plotted.

 
leonid553:

Yes, manually is labour-intensive.

In the end, I (for example) want to get a so-called multi-annual seasonal trend graph at a certain site, something like this:

I understood it at once, Leonid. Besides being time-consuming by hand, it is also coarse (by the step of the time scale when transferring manually)...

We need a program or something...

So the question remains open.

 

=======

As a start, you could (optionally) find at least a scanning program to translate each line graph into coordinates. And then sum up these coordinates in Excel and draw an averaged line!

- The contract of the pigs is a 20 year average graph:


 

If we talk specifically about this site, all the necessary data are already contained in the code of the HTML page itself (of course, those coders wrote there :))

Open the code of the page in any editor (you can directly in your browser)

We see such lines :

<area shape="poly" coords="45,282,50,268,55,262,55,272,50,278,45,292"onmousemove="showTooltip(event, '<b>[Apr 21, 2011]</b>: -17.70')"

These respectively describe the positions and values of the tooltip for each date on the chart. I think I don't need to explain what to do next - Excel rules.

 
FAQ:

If we talk specifically about this site, all the necessary data are already contained in the code of the HTML page itself (of course, those coders wrote there :))

Open the code of the page in any editor (you can directly in your browser)

We see such lines :

<area shape="poly" coords="45,282,50,268,55,262,55,272,50,278,45,292"onmousemove="showTooltip(event, '<b>[Apr 21, 2011]</b>: -17.70')"

These respectively describe the positions and values of the tooltip for each date on the chart. I think I don't need to explain what to do next - Excel rules.


I.e. it turns out that in the "source code" of the page (e.g. CLZ10 oil Tf=D in the link above) - the graph coordinates are already there:

All that's left to do is to somehow transfer them to excel?

 
Aug 30 2010 77.17
Aug 31 2010 75.1
Sep 1 2010 76.86
Sep 2 2010 77.49
Sep 3 2010 77.29
Sep 7 2010 77.47
Sep 8 2010 77.91
Sep 9 2010 77.23
Sep 10 2010 78.26
Sep 13 2010 78.87
Sep 14 2010 78.83
Sep 15 2010 78.4
Sep 16 2010 77.19
Sep 17 2010 76.67
Sep 20 2010 77.8
Sep 21 2010 76.65
Sep 22 2010 76.3
Sep 23 2010 76.54
Sep 24 2010 77.65
Sep 27 2010 77.5
Sep 28 2010 77.41
Sep 29 2010 79.09
Sep 30 2010 80.95
Oct 1 2010 82.5
Oct 4 2010 82.2
Oct 5 2010 83.64
Oct 6 2010 83.99
Oct 7 2010 82.38
Oct 8 2010 83.35
Oct 11 2010 83.01
Oct 12 2010 82.45
Oct 13 2010 83.74
Oct 14 2010 83.36
Oct 15 2010 81.93
Oct 18 2010 83.8
Oct 19 2010 80.16
Oct 20 2010 82.54
Oct 21 2010 80.56
Oct 22 2010 81.69
Oct 25 2010 82.52
Oct 26 2010 82.55
Oct 27 2010 81.94
Oct 28 2010 82.18
Oct 29 2010 81.43
Nov 1 2010 82.95
Nov 2 2010 83.9
Nov 3 2010 84.69
Nov 4 2010 86.49
Nov 5 2010 86.85
Nov 8 2010 87.06
Nov 9 2010 86.72
Nov 10 2010 87.81
Nov 11 2010 87.81
Nov 12 2010 84.88
Nov 15 2010 84.86
Nov 16 2010 82.34
Nov 17 2010 80.44
Nov 18 2010 81.85
 

From the whole coordinate map we are interested only in "[Apr 21, 2011]</b>: -17.70 ", copy the map to a test document, save it, and open it in excel. in excel we cut out all unnecessary columns, leaving only dates and prices. We save it as a text document. The rest of the markup as "[", "]</b>:" will be removed with any text editor and only the date and price will remain:

Aug30201077.17

save it, open it in excel, graph it, or process it further
 
FAQ:
Aug 30 2010 77.17
Aug 31 2010 75.1
Sep 1 2010 76.86
Sep 2 2010 77.49
Sep 3 2010 77.29
Sep 7 2010 77.47
Sep 8 2010 77.91
Sep 9 2010 77.23
Sep 10 2010 78.26
Sep 13 2010 78.87
Sep 14 2010 78.83
Sep 15 2010 78.4
Sep 16 2010 77.19
Sep 17 2010 76.67
Sep 20 2010 77.8
Sep 21 2010 76.65
Sep 22 2010 76.3
Sep 23 2010 76.54
Sep 24 2010 77.65
Sep 27 2010 77.5
Sep 28 2010 77.41
Sep 29 2010 79.09
Sep 30 2010 80.95
Oct 1 2010 82.5
Oct 4 2010 82.2
Oct 5 2010 83.64
Oct 6 2010 83.99
Oct 7 2010 82.38
Oct 8 2010 83.35
Oct 11 2010 83.01
Oct 12 2010 82.45
Oct 13 2010 83.74
Oct 14 2010 83.36
Oct 15 2010 81.93
Oct 18 2010 83.8
Oct 19 2010 80.16
Oct 20 2010 82.54
Oct 21 2010 80.56
Oct 22 2010 81.69
Oct 25 2010 82.52
Oct 26 2010 82.55
Oct 27 2010 81.94
Oct 28 2010 82.18
Oct 29 2010 81.43
Nov 1 2010 82.95
Nov 2 2010 83.9
Nov 3 2010 84.69
Nov 4 2010 86.49
Nov 5 2010 86.85
Nov 8 2010 87.06
Nov 9 2010 86.72
Nov 10 2010 87.81
Nov 11 2010 87.81
Nov 12 2010 84.88
Nov 15 2010 84.86
Nov 16 2010 82.34
Nov 17 2010 80.44
Nov 18 2010 81.85

Could you elaborate a bit more...,

because it's not so easy to understand for inexperienced (like me) comrades... :-)

How do you get a picture like this from a picture like this?

Thank you.