Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Etrade interest imports creating dummy investments

Questions about updating prices or transactions in Fund Manager

Postby CGB » Sat Aug 18, 2018 5:19 pm

Hi Mark,

When importing Etrade debit interest, FM creates a redemption (sale) in the default cash account, and FM creates a new investment "()" with negative account fees. A similar thing happens with cash account earned interest, where FM creates a new investment named "earned interest on credit balance", with a number for a symbol.

Please help.

CGB
CGB
 
Posts: 76
Joined: Sat Oct 13, 2012 9:14 am

Postby Mark » Mon Aug 20, 2018 7:53 am

Hi CGB,

Could you email me an example log file from a transaction retrieve where this happens? See "Help / Logs / Transaction Retrieve...". Please send both the "Raw" and "Parsed" versions. To make sure your logs are for that account, just retrieve only that one account, and cover the date range where this issue happens.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby CGB » Mon Aug 20, 2018 1:31 pm

Hi,

I cannot find "Help / Logs / Transaction Retrieve..." in my version.

Really only happened once because I just started importing transactions from Etrade, so don't know if it will always happen.
CGB
 
Posts: 76
Joined: Sat Oct 13, 2012 9:14 am

Postby Mark » Mon Aug 20, 2018 3:13 pm

Hi CGB,

In older versions, these log files are available here:

C:\Users\<username>\AppData\Roaming\Fund Manager

as "ofxretr.txt" and "xmldump.txt"
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby CGB » Sat Aug 25, 2018 4:01 am

Mark,

The files appear to only have stock holdings, and not transactions.

Does the log only include the most recent transaction retrieve because I did a subsequent retrieve?

Also, how does one read the date ranges in the files?

CGB
CGB
 
Posts: 76
Joined: Sat Oct 13, 2012 9:14 am

Postby Mark » Sat Aug 25, 2018 11:18 am

Hi CGB,

Yes, the log files are from the most recent transaction retrieve only.

If you request a date range where there were no transactions you would only see positions, and not any transactions.

The transactions will have a date (not a range), something like:

DTTRADE (20170627160000.000[-5:EST])

where the date is read from the beginning as YYYYMMDD and then the time is after that. So, in the above example it would be June 27, 2017.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby CGB » Sun Aug 26, 2018 9:17 am

Hi Mark,

Thank you.

For an interest distribution on 5/29/18, FM had the pennies come out of a file created by FM in 2016 that currently has no previous transactions, named: "INTEREST ON CREDIT BALANCE 0.00% 02/15/2013", with symbol: "00099A109", and with file name: "00099A109.dat".

Maybe I should delete this odd old file and then FM might use the cash account and reinvest the dividend?

However, on 8/26/18 their were two small debit interest payments that FM made a new file for during the retrieve with file name: "autoname.dat" with no security name or symbol.

I sent you the retrieve files for this date by forum PM, but not sure if that is working because sitting in the outbox.

CGB
CGB
 
Posts: 76
Joined: Sat Oct 13, 2012 9:14 am

Postby Mark » Mon Aug 27, 2018 9:06 am

Hi CGB,

When retrieving transactions, the CUSIP is used. The filename and symbol do not matter. FM looks for investments in the sub-portfolio being retrieved and matches up incoming transactions with any existing investments that have the matching CUSIP. You can see the CUSIP in the "Investment Properties..." dialog, or you can add it to the list view in the Portfolio Editor.

I didn't see a 8/26/18 transaction in your log files. I suspect you meant 7/26/18? Yesterday was 8/26/18, and that was a Sunday. Here is the 7/26/18 transaction:

Code: Select all
- INCOME
   - INVTRAN
      - FITID (180726_INT_0)
      - DTTRADE (20180726170000.000)
      - MEMO (INT - INTEREST ON CASH BALANCE - AT  0.039% 06/26 THRU 07/25)
   - SECID
      - UNIQUEID (B00099A109)
      - UNIQUEIDTYPE (CUSIP)
   - INCOMETYPE (INTEREST)
   - TOTAL (0.02)
   - SUBACCTSEC (MARGIN)
   - SUBACCTFUND (MARGIN)


You can see this has a CUSIP of B00099A109. The log file shows this CUSIP has these properties:

Code: Select all
- SECINFO
   - SECID
      - UNIQUEID (B00099A109)
      - UNIQUEIDTYPE (CUSIP)
   - SECNAME (INTEREST ON CREDIT BALANCE 0.00% 02/15/2013)
   - TICKER (00099A109)
   - UNITPRICE (0.000000)
   - DTASOF (20180824180200.000)
- PARVALUE (100)
- DEBTTYPE (ZERO)


So, if you want this interest to go into your default cash account investment, make sure your default cash account investment has a CUSIP of B00099A109. If no existing investment has this CUSIP, FM will create one for you when it imports the retrieved transactions. You can see this when previewing the importing transactions in the "New Investment" column. If it shows "Yes" for a transaction here, then it is going to create a new investment because it couldn't find a match with an existing investment.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby CGB » Mon Aug 27, 2018 3:21 pm

Hi Mark

So I should give my default cash account that CUSIP number so FM does not make a new investment producing interest income.

What do I do about the two negative debit interest payments from the default cash account on 6/26/18 where FM created a corresponding account named "autoname.dat" without any CUSIP number?

Thank you.
CGB
CGB
 
Posts: 76
Joined: Sat Oct 13, 2012 9:14 am

Postby Mark » Tue Aug 28, 2018 8:09 am

Hi CGB,

Yes, assign that CUSIP to your cash investment.

Fix up the prior transactions. Just record the interest in your cash investment, and close the other investments if they only contained these interest transactions.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby CGB » Sun Sep 02, 2018 5:20 am

Hi Mark,

If FM only uses the CUSIP number for transaction imports, then how does FM match dividends for stock investments without a CUSIP number in the properties box for several of my existing investments?

Thanks.
CGB
CGB
 
Posts: 76
Joined: Sat Oct 13, 2012 9:14 am

Postby Mark » Sun Sep 02, 2018 7:58 am

Hi CGB,

When importing, FM will look for matching investments based off Symbol if the CUSIP is empty. You're better off recording the CUSIP if you're retrieving transactions. Any new investments created by FM from a transaction retrieve will have the CUSIP filled in.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Prices and Transactions

Who is online

Users browsing this forum: Google [Bot] and 8 guests

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