Quote Loader Version 2
.
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
.
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by dtd on 12 Mar, 2023 12:41 AM
Thanks to Mike Bray for this new release!
Just some comments for those wondering about this large upgrade.
Your parameters are not lost, just you may see them in different places. There will also be a few new parameters, if you don't like the default, just change them.
And a question from myself - I must have missed it when testing it.
Where is the option to hide "Do Not Load" items? [I do not see an Exclude Do Not Load when I click the select source choices]
2 Posted by dwg on 12 Mar, 2023 01:55 AM
I see "Do Not Load" at the top of the source elections.
3 Posted by dtd on 12 Mar, 2023 02:13 AM
Exactly. But I don't see "EXCLUDE Do Not Load" - based on this (and I do see it mentioned in Derek's PDF, but I don't see what is shown in the documentation)
Option to hide “Do Not Load” source selection lines.
4 Posted by dwg on 12 Mar, 2023 02:27 AM
I see what you mean in the PDF but I have not seen any reference to this anywhere else or recall any discussions about it. I'm not sure what the point would be,
5 Posted by -Kevin N. on 12 Mar, 2023 02:41 AM
Hi dtd,
QL 3200.19 Right-click on the 'Source' header > Exclude 'do not load'.
Selecting it removes those securities marked 'do not load' from the list of securities in QL.
Once removed 'Exclude' changes to 'Include' so as to restore them.
-Kevin N.
6 Posted by dwg on 12 Mar, 2023 02:47 AM
In that case I expected it was omitted in the final build.
7 Posted by -Kevin N. on 12 Mar, 2023 02:53 AM
Hi des,
I'm seeing it in 3200.20 as well. It's also documented in Mike's Wiki.
-Kevin N.
8 Posted by dtd on 12 Mar, 2023 02:55 AM
@Kevin - got it. Source HEADING, not right clicking on the item itself.
@Derek does say that in the documentation, but I guess I didn't find it very intuitive, or realize it was a "heading only" option.
@dwg - I think Stuart requested it, but I was not aware it had been done, the premise is just to leave all the "Do Not Loads" out of the table.
Whenever I heard about it, I thought it would be a line by line choice, not global (i.e. you might want to leave some do not loads (like active items you still want visibility to - like I have a couple bonds I update occasionally by hand) and remove others not as active (money market funds)... at least that's what I wrongly thought.
9 Posted by dwg on 12 Mar, 2023 03:11 AM
Well I'll be I didn't look there.
10 Posted by Stuart Beesley ... on 12 Mar, 2023 07:14 AM
I looked yesterday but couldn’t find the option so I assumed it did not make it into the build. I’ll have to look again. Thx.
11 Posted by derekkent23 on 12 Mar, 2023 07:53 AM
Guy’s, see page 6 of the main PDF section INITIAL SET UP …… Step 1 ….. You can also hide “Do not Load” lines. Also includes a screen shot.
Hope this helps.
12 Posted by Mike on 13 Mar, 2023 05:31 PM
Thanks to Mike Bray, and for Derek's assistance! I love this extension, it has finally made MD useful for me tracking various investments.
It all works great, apart from one thing. (This also affected QL1, it is not new for me i QL2).
The British Pound/GBP currency gets "future values" entered in the Currency history. It's 13/03/2023 today but I just got a 15/03/2023. Earlier today there were a few other future ones which I deleted (e.g. 31/03/2023, 16/03/2023).
This would be great for some trading if real :). A bunch of funds, plus other currencies all update fine ... with correct dates.
Base Currency of my MD used to be British Pounds, but is now something else.
Any thoughts?
13 Posted by derekkent23 on 13 Mar, 2023 06:01 PM
I am not support staff, just a user.
Hi Mike
On the Quote Loader Parameter tab set Console Message to Detailed. Close and reopen Moneydance, run Quote Loader and clicked Get Prices. Post a screen shot of the Quite Loader window showing these future dated quotes so we can see the securities affected and the source used. Then go to Moneydance HELP – CONSOLE WINDOW and click save to save a text file to post. If it not repeatable list the securities full name and ticker symbol and source. We will take a look.
14 Posted by derekkent23 on 13 Mar, 2023 06:06 PM
I am not support staff, just a user.
Hi Mike
On reading your post again you state
Base Currency of my MD used to be British Pounds, but is now something else.
Can you explain.
What’s your computer operating system. Moneydance version and build e.g. 2022.6(4097).
15 Posted by Mike on 14 Mar, 2023 08:13 AM
Hi Derek
Thanks! Logs and screenshots attached. Seems easily repeatable. Years ago when I first started using MD, my base currency was GBP. I changed this a year or so ago to CHF. OS=macOS 13.2.1 (Ventura, latest). MD version 2022.6(4097), latest. Computer date/time is set automatically (time.apple.com); and current values are correct.
I do see "2023-03-14" in the logs, but not the erroneous date seen in the screenshot ("2023-03-15").
Thanks for your help!
Mike
16 Posted by derekkent23 on 14 Mar, 2023 09:14 AM
I am not support staff, just a user.
Hi Mike
All the Trade Dates in your screen shot are correct at 14/03/2023. The incorrect date is a Price Date Quote Loader retrieves from Moneydance’s Currency/Security History window for British Pound.
We need a log showing a Trade Date being retrieved incorrectly when you click Get Prices. Can you try again.
Also can you post a screen shot of the Parameters tab.
The Moneydance’s Currency/Security History window for British Pound looks strange in that the Current rate is the rate for the 14/03/2023, but as you say there is a Dated Rate for the 15/03/2023.
On the Parameter tab was the Update Moneydance Current Price box ticked?
Normally the Current and Last Dated rate are the same. Its as if the last Dated Rate (15/03/2023) had been added using another method. A manual edit at some point?
Did after taking the Quote Loader screen shot and saving the log did you go on to save and then take a screen shot of the Moneydance’s Currency/Security History window for British Pound?
I will take a look at the log to see if is shows anything strange and also ask Mike Bray to take a look.
17 Posted by Mike Bray (Quot... on 14 Mar, 2023 10:51 AM
Hi Mike, the log.txt you provided has a couple of interesting things in it. First the request to get the quote for CHF GBP has a last date of 20230315 so it is starting with the date already set to 15/3/23. Secondly the reply back from ft.com has a date of 20230314 which is correct. QL will not override this as the trade date is less than the latest date.
It looks like you have somehow entered a date for rate of 3/15/23. Don't know how. Please try deleting the entry in the rate history for 15/3/2023 (just click on it and click on remove) and rerun. On the parameters tab please make sure you have 'Update Moneydance Current Price' selected.
18 Posted by Mike Bray (Quot... on 14 Mar, 2023 10:54 AM
There is a possibility that the date retrieval for ft.com has a bug. If it reoccurs please can you post the log before closing MD down.
19 Posted by Mike Bray (Quot... on 14 Mar, 2023 11:07 AM
The parsing of the trade date is open to error. It relies on the text 'as of ' in the date and the date having the disclaimer about being 15 minutes late. I have not run this when the markets are closed so there is a chance that the text changes depending on what time of day it is run. Do you run this in the evenings or early before the market opens?
20 Posted by Mike on 14 Mar, 2023 11:16 AM
Hi Derek & Mike
I found two more future dated values in GBP, see screenshot mdcurr1.png. I REMOVED these three (where they appeared from ???), switched on detailed logging, switched on "Update Moneydance Current Price" (it was unchecked) and then restarted MD.
No manual edits in currency. Up until I started using QL 4-5 months back, I was using another ext to update currencies. But that was removed then ... I have only Extra Investment Reports, Extract Data, QL, Security Price Entry (never used this), Toolbox.
I can't reproduce it AND find the incorrect date in the logs. So far repeated "Get Exchange Rates" in QL are done, but the currency is staying OK (no future dates).
See log3.txt & the log3-sc.png. Something doesn't look 100% there but it may be OK. There are a few instances like that.
Re order of screenshot question, can't remember at this stage ... have been doing so many tests...
Usually when I open MD, I also remove any of the future dated currency values. I.e. each time I open MD. So when I exit MD each time, it should be only historical dates.
When I run QL? Sometimes evenings/weekends, sometimes during market open (as today's posts). So no pattern.
21 Posted by Mike on 14 Mar, 2023 11:19 AM
Just to highlight ... previously it was easy to reproduce and get a future date in GBP currency. Since switching on "Update Moneydance Current Price", it seems to be behaving ... it has not added a future date in 7 or 8 restarts/re-runs.
22 Posted by skyrider.nl on 14 Mar, 2023 01:16 PM
Hello all,
Just updated to 3200.20, restarted MD and now I'm getting nothing but an empty screen.
Uninstalled QuoteLoader, re-installed, restarted MD but to no avail...
Any ideas anybody?
Cheers,
Rick
23 Posted by derekkent23 on 14 Mar, 2023 02:17 PM
I am not support staff, just a user.
Hi Rick
What’s your computer operating system. What version build of Moneydance e.g. 2022.6(4097).
Post a screen shot of what you see.
At the top of the Quote Loader screen do you see tabs, including a Parameter tab. If so post a screen shot.
24 Posted by derekkent23 on 14 Mar, 2023 02:47 PM
I am not support staff, just a user.
Hi Mike
If you get any further future dated Trade dates appearing in the Quote Loader Window take a screen shot and post along with a log.
Thanks
25 Posted by derekkent23 on 14 Mar, 2023 03:03 PM
I am not support staff, just a user.
Hi Mike
If you get any further future dated Trade dates appearing in the Quote Loader then it would also be useful if you could Go to https://markets.ft.com/data/currencies/tearsheet/summary?s=CHFGBP and take screen shot as attached.
Thanks
26 Posted by derekkent23 on 14 Mar, 2023 03:06 PM
I am not support staff, just a user.
Hi Mike
Sorry screen shot should have included date as this.
27 Posted by skyrider.nl on 15 Mar, 2023 08:18 AM
Hi Derek,
My MD version is 2022.6 (4097) running on MacOS Ventura 13.2.1 (MacBook Pro).
Attached is a screenshot of QuoteLoader in MD:
Cheers,
Rick
28 Posted by derekkent23 on 15 Mar, 2023 08:47 AM
I am not support staff, just a user.
Hi Rick
This may be a issue of Mac not playing well with Quote Loader.
I don’t have a Mac so cant explore the issue you see so will draw Mike Brays attention to your post. My testing was on Windows and Linux.
One member of the team testing has a Mac and he did have an issue resizing the Quote Loader window, so data appeared as well as headings not being visible. I included the following comments in the PDF on Mikes advise which it was reported fixed the issue.
Mac users should ensure in System Preferences/General Show Scroll Bars is set to 'Always'.
There should be a scroll bar on the left vertical edge of the window that allow you to bring data into view. You should also be able to resize the window using mouse grab on window edges so the data is permanently visible and is remembered the next time you open Quote Loader.
I cant see a scroll bar in your screen shot but that may be due to the dark theme,
Try changing the Theme to high contrast whilst setting up the window.
I can see the horizontal bar that divides the security and exchange rate sections which can be move up and down to respace the two sections.
Try the above whilst we wait for Mike Bray to comment.
29 Posted by dwg on 15 Mar, 2023 09:19 AM
That looks like it might be theme related.
I'd be inclined, as a test, to try a different theme and see if the behaviour is different. That may help to narrow the problem down.
30 Posted by skyrider.nl on 15 Mar, 2023 09:55 AM
Hi Derek,
Just made some pref changes as you suggested, both system- as MD-wide.
Slight improvement but not solved yet:
Rick