Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Stock Basis

Questions on using, creating, or understanding data in Fund Manager graphs.

Postby 4Profits » Mon Sep 09, 2019 11:57 am

Mark,
I have the following calculations on my legend text for the Cost | Price graph

Legend Text is as follows

Graph : CST-PRICE(NAV)-[[COSTFLAG]]
Symbol/Shares : [[INVSYMB]] - [[EINVSHARES]]
Basis : [[CURRENCY]] [[EINVCOST]] = [[EINVCOSTNAV]] per/share
Value : [[CURRENCY]] [[EINVVAL]]
Close : [[CURRENCY]] [[EGRAPHVAL]] ([[EGRAPHVALCHANGE]])
Desc : [[INVDESC]]
--------------------------------
Type: [[INVTYPE]] / - Rec :[[INVGOAL]]
Asset Type: [[INVASSET]] - Sector: [[INVSECTOR]]
File: [[INVLOCATION]]--[[INVFILENAME]]


I have the following transactions
Date Price shares Invest
10/12/2018 38.452 100 $3,845.2
10/11/2018 47.75 88 $4,202
5/7/2018 57.455 188 $10,801.54
3/5/2018 54.82 -188 $-10,306.16

Totals 188 $8,542.58

Calculated Basis = $8,542.58 / 188 = $45.439 per share

Why does the legend calculations show:
Basis:$10,806.57 = $57.642 per share instead of
The Total Cost= $8,542.58 = $45.44


Jim
4Profits
 
Posts: 80
Joined: Sat Feb 09, 2008 1:02 pm

Postby Mark » Mon Sep 09, 2019 3:58 pm

Hi Jim,

Which exact graph legend field are you asking about? What is your graph end date? Can you either email the *.dat investment file or post a screenshot of your transactions in the Data Register?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 8858
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby 4Profits » Tue Sep 10, 2019 5:28 am

Mark,
Here is the DAT File. I have the trend set to TRN Since I wrote this yesterday I sold another 88 shares.
Attachments
Sheila E-IRA OKTA_173427756.dat
(19.86 KiB) Downloaded 38 times
4Profits
 
Posts: 80
Joined: Sat Feb 09, 2008 1:02 pm

Postby Mark » Tue Sep 10, 2019 6:02 am

Hi 4Profits,

Thanks. If you look at the bottom right corner of the graph, what is the end date? Also, what specific legend field are you asking about? I am out of the office this week, but will look at it on Monday.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 8858
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby 4Profits » Tue Sep 10, 2019 1:58 pm

The end date is 9/10/19. I am looking at the legend text field starting with Basis which should show the total cost basis for the shares I own and the basis per share.
4Profits
 
Posts: 80
Joined: Sat Feb 09, 2008 1:02 pm

Postby Mark » Tue Sep 10, 2019 8:34 pm

Hi 4Profits,

Okay thanks. I will take a look when I return on Monday.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 8858
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Graphs

Who is online

Users browsing this forum: No registered users and 1 guest

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