Quote Loader and "Accounting for spin-offs"

Bob Crocker's Avatar

Bob Crocker

13 Jan, 2023 11:26 AM

I have 2 “simple” questions and a more procedural one.
Quote loader has stopped downloading “GC=F” from Yahoo. Don’t know why?
Also it’s pulling down the wrong prices for BHP, WDS & S32, all of which have Trade Currency marked as AUD. Any ideas?
And can someone tell me how one should account for “spin offs” (not sure what they should be called). BHP has recently “spawned” WDS and GSK “spawned” HLN. I have no Cost price so they are not being accounted for properly in Money Dance Investment Reports. I just entered them as a Buy at zero cost. What should I have done?

  1. 1 Posted by dwg on 14 Jan, 2023 03:26 AM

    dwg's Avatar

    How the transaction should be constructed In Moneydance really depends on how the transaction is structured in real life. Typically the funds come from the parent in some way but there are a variety of ways it can be done, with very different consequences for the parent. Once you have the funds the buy in the spun off company is performed at the spin off price.

  2. 2 Posted by derekkent23 on 14 Jan, 2023 04:09 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Bob

    Are you running Quote Loader build 3058?
    If not update under Extensions.
    If yes post a screen shot of Your Quote loader window so I can see if I can see any setting issues.

    For your example post the full security name, ticker, Exch Mod, Source and last correct price you have, your base currency and the currency the securities are traded in.

    Hope this helps

  3. 3 Posted by Bob Crocker on 18 Jan, 2023 03:20 PM

    Bob Crocker's Avatar

    Thank you Derek,

    Update to build 3058 solved GC=F, but not discrepancy for BHP, S32, WDS
    with Trade Currency of AUD.

    Attached screenshots taken today.



  4. 4 Posted by Bob Crocker on 18 Jan, 2023 03:33 PM

    Bob Crocker's Avatar

    Sadly that doesn't really solve my problem. It tells me there are various
    ways it can be done without telling me what they are.
    Thanks for replying though

  5. 5 Posted by Mike Bray (Quot... on 18 Jan, 2023 03:50 PM

    Mike Bray (Quote Loader Author)'s Avatar

    There are several exchanges for BCH, S32 and WDS, selecting ASX from the Exch Mod list will give you an AUD price.

  6. 6 Posted by derekkent23 on 18 Jan, 2023 03:51 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Bob

    Your three problem securities are traded on a number of exchanges in different counties in local currencies. Without knowing which exchange FT is defaulting to an Australian exchange where the trade currency is AUD. By setting the Exch Mod to LSE London Stock Exchange FT then know that the exchange you want quotes retuned from. See Screen shot.

    Hope this helps.

  7. 7 Posted by Bob Crocker on 18 Jan, 2023 04:50 PM

    Bob Crocker's Avatar

    Excellent, thanks Derek

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac