Is there any way of importing data of higher resolution than 'Daily' into QuoteManager; other than a feature request?!
Khalid
QuoteManager Data Granularity -- plea for higher time frames
- TJ
- Posts: 7752
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1034 times
- Been thanked: 2228 times
Re: QuoteManager Data Granularity
Is there any way of importing data of higher resolution than 'Daily' into QuoteManager; other than a feature request?!
Khalid
What do you mean by "higher resolution"?
Weekly?
or
tick? Minute? Hour?
- TJ
- Posts: 7752
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1034 times
- Been thanked: 2228 times
Re: QuoteManager Data Granularity
Weekly and Monthly, for instance. I understand, Day, Minute, and Tick granularities are already facilitated.
Khalid
That's what I thought you meant, that's why I asked.
Weekly and monthly are considered "Lower Resolution" than daily.
Not meant to be picky, just want to clarify so that we are on the same page.
-
- Posts: 323
- Joined: 07 Jan 2007
- Location: Lahore, Pakistan
- Has thanked: 64 times
- Been thanked: 57 times
Re: QuoteManager Data Granularity
Understood; thank you.Weekly and monthly are considered "Lower Resolution" than daily.
Apologies for the wrong use. I would have preferred granularity, but since QuoteManager uses Resolution, I opted for it!
Khalid
- TJ
- Posts: 7752
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1034 times
- Been thanked: 2228 times
Re: QuoteManager Data Granularity
Quote are usually sent by dataproviders in 3 formats -- tick, minute, and daily.
MultiCharts builds your desired resolution on-the-fly from these data.
There is no need to save your quotes in other resolutions.
MultiCharts builds your desired resolution on-the-fly from these data.
There is no need to save your quotes in other resolutions.
-
- Posts: 323
- Joined: 07 Jan 2007
- Location: Lahore, Pakistan
- Has thanked: 64 times
- Been thanked: 57 times
Re: QuoteManager Data Granularity
Indeed, TJ; what you say about quotes from data providers is true.Quote are usually sent by dataproviders in 3 formats -- tick, minute, and daily.
MultiCharts builds your desired resolution on-the-fly from these data.
There is no need to save your quotes in other resolutions.
However, what I would like to do is to import weekly/monthly prices to draw long term charts in MultiCharts. For instance, there is a wealth of monthly forex data going back about 60 years available from OECD:Is there any way of importing data of higher resolution than 'Daily' into QuoteManager; other than a feature request?!
http://stats.oecd.org/index.aspx?queryid=169#
Presently, I plot in Excel. But look forward to plotting in MultiCharts:
https://www.multicharts.com/pm/viewissu ... no=MC-1928
Khalid
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2958 times
Re: QuoteManager Data Granularity
Hello khalaad,
You can import weekly/monthly data as daily data and then plot it on a chart.
You can import weekly/monthly data as daily data and then plot it on a chart.
-
- Posts: 323
- Joined: 07 Jan 2007
- Location: Lahore, Pakistan
- Has thanked: 64 times
- Been thanked: 57 times
Re: QuoteManager Data Granularity
Yes, Henry, one could do as you suggest; but doing so would only make sense with a very limited number of data series where the time element -- and hence the time scale on chart -- is of no great consequence. Attached is a converted from Excel monthly chart of Crude Oil starting January 1900; if I violate the time scale, the chart won't tell me what it does! This is probably a very personal belief, but successful trading has a lot to do with a trader's beliefs.Hello khalaad,
You can import weekly/monthly data as daily data and them plot it on a chart.
Khalid
- Attachments
-
- Crude.pdf
- (106.53 KiB) Downloaded 213 times
-
- Posts: 323
- Joined: 07 Jan 2007
- Location: Lahore, Pakistan
- Has thanked: 64 times
- Been thanked: 57 times
Re: QuoteManager Data Granularity -- plea for higher time fr
And attached is a chart of what I consider the mother of all time and price data series: the UK Retail Price Index, going back to 1209; and plotting this without its proper time scale would be a sacrilege. Even though there no data available for much of High Middle Ages, when Europe’s population boomed and lot of growth took place, in my opinion, a properly constructed chart of UK Retail Price Index data graphically encapsulates much of western world’s post-Viking Age history.
Alternating between inflation and deflationary periods, prices remained contained most of the time within a channel until the break of the 4 points 600 years resistance line in the early 1950’s precipitating the parabolic ascent with not a single dip. The First point of the 600 years resistance’s is year 1317, when the Pound collapsed and which was also the last year of the Great Famine of 1315-17 -- first in a series of 14th century catastrophes; followed by:
• 1648, the year of the Peace of Westphalia – brought relative peace to Europe after long and destructive wars;
• 1812, the year of the Battle of Leipzig – Napoleon’s first decisive defeat in a battle; and
• 1920, the peak year of World War I Inflation – the inflationary financing of the Great War ended.
The events mentioned above are for historic references and not necessarily as causative factors – I am a technically oriented and do not get into the global macro game.
I also feel this chart warns us what is probably going to happen in the future. The patterns over the millennium appear nearly complete; and we need to beware of, and prepare for, a massive downturn! However, as a caveat, I must quote Peter L. Brandt, trader extraordinaire and the greatest living chartist:
"REMEMBER! Until a chart pattern is decisively confirmed it is dangerous to one' mental and financial well-being."
The ‘nearly complete’ could take a while yet!
Khalid
Alternating between inflation and deflationary periods, prices remained contained most of the time within a channel until the break of the 4 points 600 years resistance line in the early 1950’s precipitating the parabolic ascent with not a single dip. The First point of the 600 years resistance’s is year 1317, when the Pound collapsed and which was also the last year of the Great Famine of 1315-17 -- first in a series of 14th century catastrophes; followed by:
• 1648, the year of the Peace of Westphalia – brought relative peace to Europe after long and destructive wars;
• 1812, the year of the Battle of Leipzig – Napoleon’s first decisive defeat in a battle; and
• 1920, the peak year of World War I Inflation – the inflationary financing of the Great War ended.
The events mentioned above are for historic references and not necessarily as causative factors – I am a technically oriented and do not get into the global macro game.
I also feel this chart warns us what is probably going to happen in the future. The patterns over the millennium appear nearly complete; and we need to beware of, and prepare for, a massive downturn! However, as a caveat, I must quote Peter L. Brandt, trader extraordinaire and the greatest living chartist:
"REMEMBER! Until a chart pattern is decisively confirmed it is dangerous to one' mental and financial well-being."
The ‘nearly complete’ could take a while yet!
Khalid
- Attachments
-
- UK Retail Price Index_ 1265 to present.png
- (136.48 KiB) Downloaded 971 times
Last edited by khalaad on 26 Sep 2015, edited 1 time in total.
- TJ
- Posts: 7752
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1034 times
- Been thanked: 2228 times
Re: QuoteManager Data Granularity -- plea for higher time fr
I have made similar analysis many years ago.
What I have done is created a dummy symbol, eg. "CrudeMonthy" for the monthly data, and imported my monthly data into it. I imported it as daily data; which is not a problem, because MultiCharts will simply load the data according to the date, and leave the others blank.
The symbol name let me identify that it is a monthly only data series. The monthly chart showed up and all indicators worked the same with no problem.
I ran my back test on it; since I was only testing the long term, I wasn't worry about mating it to the current daily data.
I hope it works for you too.
What I have done is created a dummy symbol, eg. "CrudeMonthy" for the monthly data, and imported my monthly data into it. I imported it as daily data; which is not a problem, because MultiCharts will simply load the data according to the date, and leave the others blank.
The symbol name let me identify that it is a monthly only data series. The monthly chart showed up and all indicators worked the same with no problem.
I ran my back test on it; since I was only testing the long term, I wasn't worry about mating it to the current daily data.
I hope it works for you too.
-
- Posts: 323
- Joined: 07 Jan 2007
- Location: Lahore, Pakistan
- Has thanked: 64 times
- Been thanked: 57 times
Re: QuoteManager Data Granularity -- plea for higher time fr
Thank you, TJ. Appreciate you sharing your experience. Regrettably, I have so far not been able to replicate your success.
Khalid
Khalid
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2958 times
Re: QuoteManager Data Granularity -- plea for higher time fr
Hello khalaad,
TJ's instructions are correct. Please specify the particular difficulty you have with the data.
TJ's instructions are correct. Please specify the particular difficulty you have with the data.
-
- Posts: 323
- Joined: 07 Jan 2007
- Location: Lahore, Pakistan
- Has thanked: 64 times
- Been thanked: 57 times
Re: QuoteManager Data Granularity -- plea for higher time fr
Thank you, Henry.Hello khalaad,
TJ's instructions are correct. Please specify the particular difficulty you have with the data.
What TJ says is really simple enough for one to do; let me try this again on my own, and if I am still not able to do it, I shall gratefully seek help.
Khalid