Got a credit card? use our Credit Card & Finance Calculators
Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site
Gaier software
-
- 2 Lemon pips
- Posts: 236
- Joined: November 4th, 2016, 7:03 pm
- Has thanked: 631 times
- Been thanked: 48 times
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: 159
- Joined: November 13th, 2016, 5:07 pm
- Has thanked: 33 times
- Been thanked: 2 times
Re: Gaier software
Recently I have found that running this program results in nearly all the share prices being quoted in pence, not pounds.
Yes for me too - I hope it gets resolved!
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: 766
- Joined: November 4th, 2016, 4:27 pm
- Has thanked: 149 times
- Been thanked: 237 times
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: 159
- Joined: November 13th, 2016, 5:07 pm
- Has thanked: 33 times
- Been thanked: 2 times
Re: Gaier software
Until then, the tool is useless
Not entirely as the FT portfolo download still seems to work
-
- 2 Lemon pips
- Posts: 236
- Joined: November 4th, 2016, 7:03 pm
- Has thanked: 631 times
- Been thanked: 48 times
-
- Posts: 41
- Joined: January 22nd, 2018, 10:55 am
- Has thanked: 5 times
- Been thanked: 10 times
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 Quarter
- Posts: 1103
- Joined: November 4th, 2016, 1:12 pm
- Has thanked: 179 times
- Been thanked: 378 times
Re: Gaier software
TurboukToo2 wrote: Just about usable but clearly needs fixing.
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.
-
- Lemon Slice
- Posts: 582
- Joined: November 4th, 2016, 1:17 pm
- Has thanked: 192 times
- Been thanked: 126 times
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.
-
- 2 Lemon pips
- Posts: 159
- Joined: November 13th, 2016, 5:07 pm
- Has thanked: 33 times
- Been thanked: 2 times
Re: Gaier software
Dan released ver 2.3 today, all working OK for me now.
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 security
-
- Lemon Quarter
- Posts: 1103
- Joined: November 4th, 2016, 1:12 pm
- Has thanked: 179 times
- Been thanked: 378 times
Re: Gaier software
ivahunch wrote:Dan released ver 2.3 today, all working OK for me now.
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 security
e.g.
APAX,151.1.APAX.LON,GBX
-
- 2 Lemon pips
- Posts: 159
- Joined: November 13th, 2016, 5:07 pm
- Has thanked: 33 times
- Been thanked: 2 times
Re: Gaier software
e.g.
APAX,151.1.APAX.LON,GBX
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?
-
- Lemon Quarter
- Posts: 1103
- Joined: November 4th, 2016, 1:12 pm
- Has thanked: 179 times
- Been thanked: 378 times
Re: Gaier software
ivahunch wrote:e.g.
APAX,151.1.APAX.LON,GBX
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?
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.
-
- 2 Lemon pips
- Posts: 159
- Joined: November 13th, 2016, 5:07 pm
- Has thanked: 33 times
- Been thanked: 2 times
Re: Gaier software
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.
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!
-
- Posts: 41
- Joined: January 22nd, 2018, 10:55 am
- Has thanked: 5 times
- Been thanked: 10 times
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: 159
- Joined: November 13th, 2016, 5:07 pm
- Has thanked: 33 times
- Been thanked: 2 times
Re: Gaier software
Data source fixed maybe?
If so - that's good news. But I haven't removed any of my "GBX workarounds" yet - so I can't confirm.
-
- 2 Lemon pips
- Posts: 159
- Joined: November 13th, 2016, 5:07 pm
- Has thanked: 33 times
- Been thanked: 2 times
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?
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 24 guests