Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Incorrect Split Transaction Retrieval from Yahoo Historical

Questions about updating prices or transactions in Fund Manager

Postby LynneB » Sat Jun 15, 2019 10:08 pm

I'm using the Professional edition to retrieve historical data (prices, splits and dividends). For the past few months this process occasionally resulted in improbably large (or small) values for Alpha and other statistics. The problem seems to be how FM is interpreting Yahoo's data, which itself is problematic.

For example, the ETF "JNK" did a reverse split on May 6, 2019. Here's the detailed log of the price retrieval:

*** Returned Data:
Date,Stock Splits
2019-05-06,3/1
*** End of Returned Data:
Updating: "JNK"
Split for JNK with ratio = 3.000000 on 5/6/2019
Retrieving from server: (YAHOO-HISTORICAL)


This "3/1" split is retrieved by FM as "3 for 1", but it should actually be "1 for 3". To verify, here's how the split was described in the press at the time: "... JNK will trade at a post-reverse split price of around $105, following a 1:3 reverse split." Of course, the upside-down split ratio makes it impossible to display split-adjusted historical prices correctly.

I found this problem in all splits for 2019. The workaround is to edit the split, then reload prices.
LynneB
 
Posts: 8
Joined: Mon May 26, 2008 8:15 am

Postby Mark » Sun Jun 16, 2019 9:23 am

Hi LynneB,

Thanks for pointing this out. It appears Yahoo changed the format of how they report splits. We have just now released an update to fix this. Use "Help / FM on the Web / Check for Updates..." to get quote module 542.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby LynneB » Sun Jun 16, 2019 3:58 pm

Thank you for working this Father's Day weekend on this! FM is working correctly now.
LynneB
 
Posts: 8
Joined: Mon May 26, 2008 8:15 am


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 9 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.
cron