Any function to adjust price for stock splits, dividends ...  [SOLVED]

Questions about MultiCharts and user contributed studies.
benho
Posts: 48
Joined: 27 Dec 2015
Has thanked: 12 times
Been thanked: 2 times

Any function to adjust price for stock splits, dividends ...

Postby benho » 30 Dec 2015

Hi there,

Are there any Multicharts internal built-in functions or public domain contributions to adjust stock historical price data to remove gaps caused by stock splits, dividends and distributions ? Or we must export the historical data first => make the price adjustment => import the adjusted price again ? Any better approach ?

Alternatively, it will be helpful if we are allowed to manipulate the multicharts stock price database directly such that the export/import process can be eliminated, possible ?

Thanks.

User avatar
JoshM
Posts: 2195
Joined: 20 May 2011
Location: The Netherlands
Has thanked: 1544 times
Been thanked: 1565 times
Contact:

Re: Any function to adjust price for stock splits, dividends

Postby JoshM » 02 Jan 2016

Are there any Multicharts internal built-in functions or public domain contributions to adjust stock historical price data to remove gaps caused by stock splits, dividends and distributions ?
There are no built-in functions for this, and I'm not aware of any public domain ones. But even if there were, it wouldn't help much; 99% of the functions are computed on the OHLC data from the data series. That means that, if your function adjusts the OHLC data, then all other functions are still calculated on the wrong data. And to solve that, you'll need to rewrite *every* function so that they are calculated on the data that's returned by the 'adjustment function'.
Or we must export the historical data first => make the price adjustment => import the adjusted price again ? Any better approach ?
I'm afraid that's not only the best approach but also the only approach.
Alternatively, it will be helpful if we are allowed to manipulate the multicharts stock price database directly such that the export/import process can be eliminated, possible ?
Another alternative would be to solve this problem on the data feed level, so that the adjusted data is imported into MultiCharts. You might want to look into the different data feeds to see if there's one that solves this problem. This thread suggests that CSI can do such a thing.

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

Re: Any function to adjust price for stock splits, dividends  [SOLVED]

Postby TJ » 02 Jan 2016

Hi there,

Are there any Multicharts internal built-in functions or public domain contributions to adjust stock historical price data to remove gaps caused by stock splits, dividends and distributions ? Or we must export the historical data first => make the price adjustment => import the adjusted price again ? Any better approach ?

Alternatively, it will be helpful if we are allowed to manipulate the multicharts stock price database directly such that the export/import process can be eliminated, possible ?

Thanks.
Yahoo used to provide adjusted prices on North American stocks (Daily only).
Not sure if they still do.

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

Re: Any function to adjust price for stock splits, dividends

Postby Henry MultiСharts » 08 Jan 2016

Hello benho,

If the data provider has adjusted the historical data on his end – you need to reload the chart in MultiCharts to receive the adjusted data.


Return to “MultiCharts”