Dear Marina,
I have discovered that MC when import data from yahoo doesn't adjust the quotes for dividends or stock splits, if you give a look to the ETF FXI on the 23-Jul-08 the was a 3:1 stock split, in MC for this date is shown a big gap that doesn't make sanse. TS Support should add an option to adjust the data when are imported from the Free quotes.
The logic is the following: every time that the Close is different from AdjClose MC should adjust the data i.e.:
Open = Open * (AdjClose/Close)
High = High * (AdjClose/Close)
Low = Low * (AdjClose/Close)
Close = Close * (AdjClose/Close) = AdjClose
I hope that this fix will be available for the next release.
Regards,
Danilo
Free Quotes request
- TJ
- Posts: 7740
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1033 times
- Been thanked: 2221 times
- Marina Pashkova
- Posts: 2758
- Joined: 27 Jul 2007
- Marina Pashkova
- Posts: 2758
- Joined: 27 Jul 2007
Hi Danilo,
Not being able to perform stock split adjustments in MC is not a bug. We are talking about bugs if a functionality's behavior is different from the intended one. What you are talking about is classified as a feature request.
As for Free Quotes, the sources where the data is pulled up from are limited in so many ways that it doesn't make much sense for us to add functionalities to work with those free sources, especially since real data feeds already provide adjusted stock split data. We regard Free Quotes as a secondary source of data.
Not being able to perform stock split adjustments in MC is not a bug. We are talking about bugs if a functionality's behavior is different from the intended one. What you are talking about is classified as a feature request.
As for Free Quotes, the sources where the data is pulled up from are limited in so many ways that it doesn't make much sense for us to add functionalities to work with those free sources, especially since real data feeds already provide adjusted stock split data. We regard Free Quotes as a secondary source of data.
Dear Marina,
The new feature could be implemented just inside the FreeQuotes plugin, and to adapt MC to perform the adjustement for Yahoo's quotes, should be necessary to add the folowing 4 lines of code (2 minutes of programming resources):
Open = Open * (AdjClose/Close)
High = High * (AdjClose/Close)
Low = Low * (AdjClose/Close)
Close = AdjClose
Regards,
Danilo
P.S.: IB provides only 1 year of historical quotes, Yahoo much more
The new feature could be implemented just inside the FreeQuotes plugin, and to adapt MC to perform the adjustement for Yahoo's quotes, should be necessary to add the folowing 4 lines of code (2 minutes of programming resources):
Open = Open * (AdjClose/Close)
High = High * (AdjClose/Close)
Low = Low * (AdjClose/Close)
Close = AdjClose
Regards,
Danilo
P.S.: IB provides only 1 year of historical quotes, Yahoo much more
- Marina Pashkova
- Posts: 2758
- Joined: 27 Jul 2007