Pricing Extension Error

Tsengyue Lung's Avatar

Tsengyue Lung

02 Jan, 2022 11:37 AM

Hi

Trying to get year end price and cannot get any.
use
Extension
Quote and Exchange Rate
Select one security just to test
Click Update Now
And receive following error message:
"Unable to get rate from 143658300 to USD"

Not sure what this means and how to fix it.

Please help, thanks

  1. 1 Posted by derekkent23 on 02 Jan, 2022 11:56 AM

    derekkent23's Avatar

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

    Lots of users are reporting problems with Quote and Exchange Rate updater.

    Instead try the extension Quote Loader under EXTENSIONS – MANAGE EXTENSION

    For information on the features of this extension and how to use see post 200 at
    https://infinitekind.tenderapp.com/discussions/investments/4914-the...

    Download the PDF’s attached to post 200 and have a read.

    To get an overview take a look at the YouTube videos by using the links on page 1 and 2 of the PDF.

    Let us know how you get on or if you need help just post.

    Hope this helps.

  2. 2 Posted by TY Lung on 06 Jan, 2022 01:03 AM

    TY Lung's Avatar

    Hi Derek,
    Thanks for the email, we are still running the 2017 version of the Moneydance, I believe the reason we didnot do the upgrade that time in that we only use it for Investment accounts tracking and the new upgrade seems to be for Bank and Credit cards.However in order to use Quote Loader I think we will have to upgrade to newer version, the questions is which version should we upgrade to?Are there any instructions on the upgrade? I think last time when we upgrade to 2017 there are step by step intructions on how to convert.
    Grateful any suggestions you can give!
    Thanks, Best Wishes!
    Tsengyue

        On Sunday, January 2, 2022, 07:56:54 PM GMT+8, derekkent23 <[email blocked]> wrote:
     
       
    |

  3. 3 Posted by dwg on 06 Jan, 2022 04:31 AM

    dwg's Avatar

    I'm a fellow user.

    The base data format in Moneydance 2017 and the latest Moneydance 2022 is the same so upgrading presents no real challenges, obvious you do a data backup before you start the upgrade as a precaution.

  4. 4 Posted by TY Lung on 06 Jan, 2022 05:06 AM

    TY Lung's Avatar

    Thanks

    Sent from Yahoo Mail on Android
     
      On Thu, Jan 6, 2022 at 12:31, dwg<[email blocked]> wrote: #yiv6303862032 pre {width:92%;margin:10px 2%;padding:5px 2%;background:#efefef;border:1px solid #d6d6d6;}#yiv6303862032 blockquote {margin-left:0;padding-left:1em;border-left:5px solid #ccc;}
    |

  5. 5 Posted by derekkent23 on 06 Jan, 2022 07:54 AM

    derekkent23's Avatar

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

    If you want to upgrade to 2022.3(4063) you can use your existing key to get a 50% discount by using upgrading box at https://infinitekind.com/purchase

    Backup you data first then download 2022.3(4063) from https://infinitekind.com/preview and install. Your existing data will open in 2022,

    Have Fun, Stay Safe.

  6. 6 Posted by TY Lung on 07 Jan, 2022 08:18 AM

    TY Lung's Avatar

    Upgrade to 2022 Moneydance and install Quoteloader and able to pull year end price without problem.The manual price update on donot load item seems not working, double click on the new price field, able to enter price but cannot get out of the field, only way is to close the Extension, not sure where I did wrong.But it is not a show stopper the main function of downloading price works beautifully and way faster than the old function that use to take hours.
    Thanks for all the help.Best wishes to all.
    Tsengyue

    Sent from Yahoo Mail on Android
     
      On Sun, Jan 2, 2022 at 19:56, derekkent23<[email blocked]> wrote: #yiv1833652976 pre {width:92%;margin:10px 2%;padding:5px 2%;background:#efefef;border:1px solid #d6d6d6;}#yiv1833652976 blockquote {margin-left:0;padding-left:1em;border-left:5px solid #ccc;}
    |

  7. 7 Posted by derekkent23 on 07 Jan, 2022 10:41 AM

    derekkent23's Avatar

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

    The purpose of the Source Setting ‘Do not load’ is to prevent QL from trying to return a price, say in the case when neither source supports that security. In these cases, you can manually enter a ‘New Price’ and ‘Trade Date’. Take a look at page 7 of the PDF point 2 under the heading RETURNED PRICE IS ZERO to see the steps required. Once you have entered the required data simply click on another field, say the name of the security. If after trying this you still have issues post again with your computer operating system and detail the process you are following.

    Hope this helps.

  8. 8 Posted by TY Lung on 08 Jan, 2022 04:51 AM

    TY Lung's Avatar

    Windows 10 HomeVersion 20H2
    Follow the instructions in the PDF, double click the New Price field, type in the price then the cursor stuck, unable to click other fields like the trade date, the cursor stay in the Price field, can only get out by clicking the CLOSE button.
    Tsengyue
    Hope 
        On Friday, January 7, 2022, 06:41:44 PM GMT+8, derekkent23 <[email blocked]> wrote:
     
       
    |

  9. 9 Posted by Stuart Beesley ... on 08 Jan, 2022 08:04 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Check help/console window for errors?

  10. 10 Posted by derekkent23 on 08 Jan, 2022 09:44 AM

    derekkent23's Avatar

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

    The attached video shows how a manual edit works for me on Windows 10.

    As Stuart suggests post the Moneydance errlog.txt file, it may reveal something.
    In Quote Loader click HELP – TURN DEBUG ON/OFF and set to DETAILED.
    Close Moneydance and restart and run Quote Loader then edit a price and trade date. When you hit the problem close Moneydance and then post the errlog.txt file to be found at
    C:\Users\user name.moneydance

  11. 11 Posted by TY Lung on 13 Jan, 2022 02:51 AM

    TY Lung's Avatar

    I did exactly as shown in the vedio, however once enter the new price when click the Trade Date column nothing happen, the cursor stay in price field; and was not able to move to any other column except clicking the CLOSE button.Attach please find the "err.log" as requested.
    Thanks for all the help
    Tsengyue
        On Saturday, January 8, 2022, 05:46:11 PM GMT+8, derekkent23 <[email blocked]> wrote:
     
      
    |

  12. 12 Posted by kionysus on 13 Jan, 2022 04:34 AM

    kionysus's Avatar

    There was an update made to the Quote Loader extension just recently that brings the version to v3045 and seems to restore the functionality. My guess is yahoo changed their API and some code changes were required.

  13. 13 Posted by derekkent23 on 13 Jan, 2022 08:09 AM

    derekkent23's Avatar

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

    I am not aware of any changes between Quote Loader build 3042 and 3045 that would change manual edit. The video was shot using 3042. I have asked Mike the developer to take a look at the errlog file.

  14. 14 Posted by derekkent23 on 13 Jan, 2022 09:58 AM

    derekkent23's Avatar

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

    Mike has taken a look at the error log and thinks he can see the issue. Until a new build is available I would suggest in Quote Loader you set the Decimal Digits to no greater than 6 and see if that allows you to edit and report back.

    Hope this helps.

  15. 15 Posted by TY Lung on 14 Jan, 2022 01:44 AM

    TY Lung's Avatar

    Thanks, will do.
    Tsengyue

    Sent from Yahoo Mail on Android

      On Thu, Jan 13, 2022 at 17:58, derekkent23<[email blocked]> wrote: #yiv8019211370 pre {width:92%;margin:10px 2%;padding:5px 2%;background:#efefef;border:1px solid #d6d6d6;}#yiv8019211370 blockquote {margin-left:0;padding-left:1em;border-left:5px solid #ccc;}
    |

  16. 16 Posted by TY Lung on 16 Jan, 2022 05:20 AM

    TY Lung's Avatar

    Change to 6 Decimal and was able to manually edit the prices without problem, thanks for all the help.
    Tsengyue
        On Thursday, January 13, 2022, 05:58:46 PM GMT+8, derekkent23 <[email blocked]> wrote:

    |

  17. 17 Posted by derekkent23 on 16 Jan, 2022 08:08 AM

    derekkent23's Avatar

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

    Thanks for taking time to report back.

    Have Fun, Stay Safe.

  18. System closed this discussion on 17 Apr, 2022 08:10 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? 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