The only time I see the situation you are describing is when the same security is held in more than one investment account. If the Security Detail window displayed is for the investment account with the later buy date then the graph will extend back to a date before the first buy in the chart. In fact, back to the date in of the first buy in the other account. The History window for the security is common to all accounts. Have you any other investment account with the same security, even if they are inactive and removed from the side bar?
This is all to do with historic currency price points.
If you go into a currency history you will see on the data set I sent that the history goes back to 18/2/2011 – magically the date to which dollar stocks chart back to irrespective of when bought.
If you then delete the price points for say the whole of 2011 for $ the chart now starts at 1/1/2012 instead of the date of acquisition of the stock. If the stock has no earlier price history than its buy date it assumes the price on the purchase date and takes that back to 2011!!!!
Over to you guys to sort that one out but that’s the problem
I did a test and your analyses seems to be correct.
MD 2020(1914) with a Security with a foreign currency there can be an issue with its Security Detail Graph.
In a test data set I have a security in a foreign currency whose data in its currency/security history window goes back to 1/7/2018 (dd/mm/yyyy) and the graph starts on the same date. However, if I go into the relevant Currency exchange rate window and say add an exchange for 1/1/2016 then the graph is extended back from the 1/7/2018 back to 1/1/2016 as a flat line.
Certainly, one for Sean to fix.
It looks like you are obtaining data for a large of securities.
Can I ask you to follow the process below and post the resulting file.
I can then import this into a test data set and see first-hand what is happening.
Obtaining Security Symbols from Moneydance CSV Format
The following approach uses the Portfolio report to export a CSV to a spread sheet that includes Security name and Ticker symbol. Note all securities will be included except those that have never been purchased. Securities that were purchased but now have zero shares will be included.
In Moneydance in the side bar click on the report “Portfolio”.
1. Click Edit, Reset, tick “Include zero Balance Account”, OK and then Copy to Clipboard.
2. Open your spread sheet program. The following is based on windows excel; however hopefully other spread sheets have the same capability.
3. In the spread sheet top left-hand cell click paste.
4. Delete all columns except the columns containing Security Names and Symbols.
5. Delete all rows that do not contain Symbols, including the row containing the word “Ticker”.
6. You should now be left with a list of Security Names and their associated Symbols.
7. Save as a CSV file.
I will thing about your charting issue. Can you provide a link to that discussion?
Includes all codes including some which no longer exist. The ones that seem to be a problem are the GB unit trust indicators as well as Nestle which is quoted on the LSE but only picks up now from SIX in Zurich.
Ill send you a separate email trail although you were actually involved in it and I have email from you on the subject!
The charting went back to 2011 regardless but it transpired to be partly due to some old base currency price points which were deleted via the last release. That however didn’t sort it completely as stock in non base currencies were still afflicted.
I have not had time to do more than import all your securities into a test data set, which takes some time.
I have not set up any Exch Mods yet, just clicked GET PRICES.
All prices were returned as you can see from screen shots, but I appreciate they may be for the wrong securities as I have not set an exchange.
To do this I need to know your setting. For any securities not using LSE just provide a list of tickers and there Exch Mod and I will test further this evening and also take look at your other issue.
The issue is with the unit trust codes starting GB followed by a series on numbers. You can see these are all grouped together.
The first two in the list of nulls as shown on the attached highlighted in red do return prices via yahoo but from 2 weeks ago!
The rest ar null and on attest return a pass with a zero price or a null on a fail.
Using FT (as I have always done) returns null as per the screenshot. Using Yahoo returns correct prices for the first two in the list and null or zero for the rest. Vie checked that the cdses are correct (they were last week so why not now) and also used the codes to look up a price on yahoo which returned a live correct price. All use LSE as source and again that is unchanged from last week when it worked perfectly for these stocks all of which are unit trusts BTW
The only stocks using overseas exchanges are Nestle (SIXT but was using LSE until yesterday) Crowdstrike CRWD Nasdaq, McDonalds MCD NYSE and Microsoft MSFT NASDAQ
As you can see all your GB tickers in my screen shot return price.
I will set up the ticker that need a non LSE exchange this evening and see if that has a impact. If not and I can’t reproduce your problem then I will post a process to obtain an error log and let Mike comment on it.
By the way this is a list of tickers I could not trace using FT that were in your file, so are not in the screen shots. Can you confirm these are the tickers that no longer exist or are they among the ones needing an exchange to be set or do they simply not appear in the Quote Loader list as you have no holding in them and have not ticked INCLUDE ZERO ACCOUNTS.
From Quote Loader build 3025 an exchange code of :LSE was added to each ticker symbol when Exch Mod is set to LSE.
Ticker symbols are unique within an exchange, but are not unique across all exchanges. In these cases you need to set a exchange for the correct security/currency to be returned. The exception to this rule is ISIN codes such as your GB securities. This is why they ceased to work when Quote Loader was updated to build 3025 and 3026.
Are you expecting NESN to be traded in Swiss Francs? If not what is its trade currency and what is a resent price?