You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
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.
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.
And single (non-simultaneous) graphs - I can plot here: (oil 2010 September-November)
http://www.cowsandcrops-market.com/markets/spreadchart.php?spread=CLZ10&indicator=&type=LINE&volume=&grid=1&logscale=0&density=M&period=D&size=S&indicators=
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?
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:
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.