QuoteManager Data Granularity -- plea for higher time frames

Questions about MultiCharts and user contributed studies.
khalaad
Posts: 323
Joined: 07 Jan 2007
Location: Lahore, Pakistan
Has thanked: 64 times
Been thanked: 57 times

QuoteManager Data Granularity -- plea for higher time frames

Postby khalaad » 21 Sep 2015

Is there any way of importing data of higher resolution than 'Daily' into QuoteManager; other than a feature request?!

Khalid
Last edited by khalaad on 26 Sep 2015, edited 1 time in total.

User avatar
TJ
Posts: 7739
Joined: 29 Aug 2006
Location: Global Citizen
Has thanked: 1032 times
Been thanked: 2221 times

Re: QuoteManager Data Granularity

Postby TJ » 21 Sep 2015

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?

khalaad
Posts: 323
Joined: 07 Jan 2007
Location: Lahore, Pakistan
Has thanked: 64 times
Been thanked: 57 times

Re: QuoteManager Data Granularity

Postby khalaad » 21 Sep 2015

Weekly and Monthly, for instance. I understand, Day, Minute, and Tick granularities are already facilitated.

Khalid

User avatar
TJ
Posts: 7739
Joined: 29 Aug 2006
Location: Global Citizen
Has thanked: 1032 times
Been thanked: 2221 times

Re: QuoteManager Data Granularity

Postby TJ » 21 Sep 2015

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.

khalaad
Posts: 323
Joined: 07 Jan 2007
Location: Lahore, Pakistan
Has thanked: 64 times
Been thanked: 57 times

Re: QuoteManager Data Granularity

Postby khalaad » 21 Sep 2015

Weekly and monthly are considered "Lower Resolution" than daily.
Understood; thank you.

Apologies for the wrong use. I would have preferred granularity, but since QuoteManager uses Resolution, I opted for it!

Khalid

User avatar
TJ
Posts: 7739
Joined: 29 Aug 2006
Location: Global Citizen
Has thanked: 1032 times
Been thanked: 2221 times

Re: QuoteManager Data Granularity

Postby TJ » 21 Sep 2015

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.

khalaad
Posts: 323
Joined: 07 Jan 2007
Location: Lahore, Pakistan
Has thanked: 64 times
Been thanked: 57 times

Re: QuoteManager Data Granularity

Postby khalaad » 22 Sep 2015

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.
Indeed, TJ; what you say about quotes from data providers is true.
Is there any way of importing data of higher resolution than 'Daily' into QuoteManager; other than a feature request?!
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:

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

User avatar
Henry MultiСharts
Posts: 9165
Joined: 25 Aug 2011
Has thanked: 1264 times
Been thanked: 2957 times

Re: QuoteManager Data Granularity

Postby Henry MultiСharts » 22 Sep 2015

Hello khalaad,

You can import weekly/monthly data as daily data and then plot it on a chart.

khalaad
Posts: 323
Joined: 07 Jan 2007
Location: Lahore, Pakistan
Has thanked: 64 times
Been thanked: 57 times

Re: QuoteManager Data Granularity

Postby khalaad » 24 Sep 2015

Hello khalaad,

You can import weekly/monthly data as daily data and them plot it on a chart.
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.

Khalid
Attachments
Crude.pdf
(106.53 KiB) Downloaded 200 times

khalaad
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

Postby khalaad » 26 Sep 2015

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
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.

User avatar
TJ
Posts: 7739
Joined: 29 Aug 2006
Location: Global Citizen
Has thanked: 1032 times
Been thanked: 2221 times

Re: QuoteManager Data Granularity -- plea for higher time fr

Postby TJ » 26 Sep 2015

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.

khalaad
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

Postby khalaad » 26 Sep 2015

Thank you, TJ. Appreciate you sharing your experience. Regrettably, I have so far not been able to replicate your success.

Khalid

User avatar
Henry MultiСharts
Posts: 9165
Joined: 25 Aug 2011
Has thanked: 1264 times
Been thanked: 2957 times

Re: QuoteManager Data Granularity -- plea for higher time fr

Postby Henry MultiСharts » 30 Sep 2015

Hello khalaad,

TJ's instructions are correct. Please specify the particular difficulty you have with the data.

khalaad
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

Postby khalaad » 01 Oct 2015

Hello khalaad,

TJ's instructions are correct. Please specify the particular difficulty you have with the data.
Thank you, Henry.

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


Return to “MultiCharts”