Gaier software
-
- 2 Lemon pips
- Posts: 229
- Joined: November 4th, 2016, 7:03 pm
Gaier software
In the days of Motley Fool an application (Gaier software) to update the prices of shares within MS Money was made available. Recently I have found that running this program results in nearly all the share prices being quoted in pence, not pounds. Just a warning in case a user found that their wealth had suddenly increased
-
- 2 Lemon pips
- Posts: 136
- Joined: November 13th, 2016, 5:07 pm
Re: Gaier software
Yes for me too - I hope it gets resolved!Recently I have found that running this program results in nearly all the share prices being quoted in pence, not pounds.
-
- Posts: 18
- Joined: December 28th, 2017, 7:39 pm
Re: Gaier software
Apparent Gaier gets the prices from MSN which in turn uses MorningStar. Dan Gaier has been suggesting users report the issue to Morningstar to encourage them to fix it.
Theres a thread on the social.microsoft.com site.
“Random incorrect [UK]price quotes when using Gaier MS Quotes”
Theres a thread on the social.microsoft.com site.
“Random incorrect [UK]price quotes when using Gaier MS Quotes”
-
- Lemon Slice
- Posts: 755
- Joined: November 4th, 2016, 4:27 pm
Re: Gaier software
The problem is Morning star quoting prices incorrectly in GBP (pounds) rather than GBX (pence). The tool then picks those up via MSN.
You can check if they have fixed it by looking at this URL. When you see 'Currency in GBX', we're back to normal.
Until then, the tool is useless.
Thread on Microsoft discussion the issue here
You can check if they have fixed it by looking at this URL. When you see 'Currency in GBX', we're back to normal.
Until then, the tool is useless.
Thread on Microsoft discussion the issue here
-
- 2 Lemon pips
- Posts: 136
- Joined: November 13th, 2016, 5:07 pm
Re: Gaier software
Not entirely as the FT portfolo download still seems to workUntil then, the tool is useless
-
- 2 Lemon pips
- Posts: 136
- Joined: November 13th, 2016, 5:07 pm
Re: Gaier software
It would seem to be ok now
-
- 2 Lemon pips
- Posts: 229
- Joined: November 4th, 2016, 7:03 pm
Re: Gaier software
Tried it this afternoon, some prices were still out by 100
-
- Posts: 35
- Joined: January 22nd, 2018, 10:55 am
Re: Gaier software
I've noticed this issue seems to be dependent on time and day you update prices. I don't update on a weekend as they are always out by a factor of 100. I did it just now and only two of 40ish tickers were out. Will check later but I think afternoons before market close is when they all update normally without the 100 times out. Just about usable but clearly needs fixing.
-
- Lemon Slice
- Posts: 881
- Joined: November 4th, 2016, 1:12 pm
Re: Gaier software
It might be worth pointing out that the error is not in MSMoneyquotes - it is in the data supplied to it via MSN. There have been changes on price reporting after MIFID2, I believe, and the errors are linked to this.TurboukToo2 wrote: Just about usable but clearly needs fixing.
-
- Lemon Slice
- Posts: 601
- Joined: November 4th, 2016, 1:17 pm
Re: Gaier software
Been noted, the problem comes from morningstar that has obviously cocked something up in their update over the new year to support MIFID.
https://social.microsoft.com/Forums/en- ... orum=money
Dan has put a workaround into the quote lookup symbol map, so you can force a currency to be used.
https://social.microsoft.com/Forums/en- ... orum=money
Dan has put a workaround into the quote lookup symbol map, so you can force a currency to be used.
-
- Posts: 18
- Joined: December 28th, 2017, 7:39 pm
Re: Gaier software
Dan released ver 2.3 today, all working OK for me now.
-
- 2 Lemon pips
- Posts: 136
- Joined: November 13th, 2016, 5:07 pm
Re: Gaier software
I have tried adding GBX in SymbolMap. So please could someone confirm that Dan means the "extra column" in SymbolMap (for GBX) is the next column to the right in the same row as the securityDan released ver 2.3 today, all working OK for me now.
-
- Lemon Slice
- Posts: 881
- Joined: November 4th, 2016, 1:12 pm
Re: Gaier software
e.g.ivahunch wrote:I have tried adding GBX in SymbolMap. So please could someone confirm that Dan means the "extra column" in SymbolMap (for GBX) is the next column to the right in the same row as the securityDan released ver 2.3 today, all working OK for me now.
APAX,151.1.APAX.LON,GBX
-
- 2 Lemon pips
- Posts: 136
- Joined: November 13th, 2016, 5:07 pm
Re: Gaier software
I have inserted "GBX" into the adjacent column in the same row as the mispriced security and then saved the file as SymbolMap.csv. But MoneyQuotes is showing SymbolMap is still resolving the prices as GPB. Any ideas where I'm going wrong please?e.g.
APAX,151.1.APAX.LON,GBX
-
- Lemon Slice
- Posts: 881
- Joined: November 4th, 2016, 1:12 pm
Re: Gaier software
Check where Excel is saving the edited file for you - the CSV needs to be in the same folder as the EXE. If it is, open the CSV with a simple text editor like Notepad and see if Excel is doing something you didn't ask/expect it to do.ivahunch wrote:I have inserted "GBX" into the adjacent column in the same row as the mispriced security and then saved the file as SymbolMap.csv. But MoneyQuotes is showing SymbolMap is still resolving the prices as GPB. Any ideas where I'm going wrong please?e.g.
APAX,151.1.APAX.LON,GBX
-
- 2 Lemon pips
- Posts: 136
- Joined: November 13th, 2016, 5:07 pm
Re: Gaier software
Yes - indeed - it was putting 2 commas at the end of the 2nd column. So all I need now is for the prices to increase just a bit!If it is, open the CSV with a simple text editor like Notepad and see if Excel is doing something you didn't ask/expect it to do.
-
- Posts: 35
- Joined: January 22nd, 2018, 10:55 am
Re: Gaier software
I've persevered with Gaiersoft for MS Money and as of the last couple of weeks its pulling in prices correctly in MS Money during both trading hours and closed hours. No corrections on my part required. I have approx 40 positions across single shares and ETFs. Data source fixed maybe?
-
- 2 Lemon pips
- Posts: 136
- Joined: November 13th, 2016, 5:07 pm
Re: Gaier software
If so - that's good news. But I haven't removed any of my "GBX workarounds" yet - so I can't confirm.Data source fixed maybe?
-
- Lemon Slice
- Posts: 601
- Joined: November 4th, 2016, 1:17 pm
Re: Gaier software
I have, and it is working fine. Morningstar got there eventually.
-
- 2 Lemon pips
- Posts: 136
- Joined: November 13th, 2016, 5:07 pm
Re: Gaier software
Is anyone else unable to retrieve prices for an increasing number of funds via MSN?
Prices for stocks are retrieving ok and "symbolmap" is also resolving symbols ok for funds - but I am now increasingly getting "invalid quote data" error for most funds.
But fund prices do still seem to be mostly available on MSNmoney
And prices are retrieving fine for all via FT.com
So does anyone have any ideas how to resolve this issue?
Prices for stocks are retrieving ok and "symbolmap" is also resolving symbols ok for funds - but I am now increasingly getting "invalid quote data" error for most funds.
But fund prices do still seem to be mostly available on MSNmoney
And prices are retrieving fine for all via FT.com
So does anyone have any ideas how to resolve this issue?