Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Monthly Dividend Report

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

Postby larryw » Thu Mar 29, 2018 11:03 am

Is there an easy way to create a report that will show monthly dividends paid for the last 12 months. All dividends have been rolled over and not paid out.

I know I can create one by manually entering date range but there is a limit on how many columns can be created and I'm hoping there is an easier/faster way to do this.
larryw
 
Posts: 60
Joined: Tue Feb 02, 2016 5:15 pm

Postby Mark » Thu Mar 29, 2018 2:30 pm

Hi larryw,

Sorry, no there isn't an easy way to get this. You could create a Custom report and write user-defined fields for the 12 different months. Otherwise, you could use up to 6 dates and the built in field for dividends to get 6 in a single report.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby divinest » Fri Mar 30, 2018 6:26 am

Interesting way to get the custom fields to show monthly allowing to overcome the 6 date range limitation. So is the idea to create 12 custom fields, one for each month? Would that be dynamic based on the report date? say if i select the report range is current year, then it would show current year monthly dividends.
divinest
 
Posts: 149
Joined: Tue Sep 05, 2017 7:07 pm

Postby Mark » Fri Mar 30, 2018 9:34 am

Hi divinest,

Yes, that is the idea. You could do it with either explicit date settings using the DATE2DAYS() function, or make them relative to the current report date using the DELTADAYS() function. It is easier to just define them with explicit dates. For example, you could create a user-defined field "January '18 Dividends" with the equation:

EVAL(DATE2DAYS(1/1/2018), DATE2DAYS(1/31/2018), Divdist_btw)
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby divinest » Fri Mar 30, 2018 11:51 am

Thanks Mark, that works very nicely. Amazing how FM allows you to customize and get insights.
divinest
 
Posts: 149
Joined: Tue Sep 05, 2017 7:07 pm

Postby divinest » Fri Mar 30, 2018 3:06 pm

Did something like this to get 12 months, dynamically assuming the end date is 12/31/XXXX,
Question, is there an option to mask the zero, i.e. if zero just display blank?

EVAL(DELTADAYS(ENDDAYS(), 0 , -12, 0) + 1, DELTADAYS(ENDDAYS(), 0 , -11, 0), Divdist_btw)
EVAL(DELTADAYS(ENDDAYS(), 0 , -11, 0) + 1, DELTADAYS(ENDDAYS(), 0 , -10, 0), Divdist_btw)
EVAL(DELTADAYS(ENDDAYS(), 0 , -10, 0) + 1, DELTADAYS(ENDDAYS(), 0 , -9 , 0), Divdist_btw)
EVAL(DELTADAYS(ENDDAYS(), 0 , -9 , 0) + 1, DELTADAYS(ENDDAYS(), 0 , -8 , 0), Divdist_btw)
EVAL(DELTADAYS(ENDDAYS(), 0 , -8 , 0) + 1, DELTADAYS(ENDDAYS(), 0 , -7 , 0), Divdist_btw)
EVAL(DELTADAYS(ENDDAYS(), 0 , -7 , 0) + 1, DELTADAYS(ENDDAYS(), 0 , -6 , 0), Divdist_btw)
EVAL(DELTADAYS(ENDDAYS(), 0 , -6 , 0) + 1, DELTADAYS(ENDDAYS(), 0 , -5 , 0), Divdist_btw)
EVAL(DELTADAYS(ENDDAYS(), 0 , -5 , 0) + 1, DELTADAYS(ENDDAYS(), 0 , -4 , 0), Divdist_btw)
EVAL(DELTADAYS(ENDDAYS(), 0 , -4 , 0) + 1, DELTADAYS(ENDDAYS(), 0 , -3 , 0), Divdist_btw)
EVAL(DELTADAYS(ENDDAYS(), 0 , -3 , 0) + 1, DELTADAYS(ENDDAYS(), 0 , -2 , 0), Divdist_btw)
EVAL(DELTADAYS(ENDDAYS(), 0 , -2 , 0) + 1, DELTADAYS(ENDDAYS(), 0 , -1 , 0), Divdist_btw)
EVAL(DELTADAYS(ENDDAYS(), 0 , -1 , 0) + 1, ENDDAYS(), Divdist_btw)
Attachments
2018-03-30 Fund Manager Professional 2018 mm4 [Report_ Monthly Dividends_ 01_01_201.jpg
Example report with zero values
2018-03-30 Fund Manager Professional 2018 mm4 [Report_ Monthly Dividends_ 01_01_201.jpg (21.81 KiB) Viewed 3811 times
Last edited by divinest on Fri Mar 30, 2018 3:36 pm, edited 1 time in total.
divinest
 
Posts: 149
Joined: Tue Sep 05, 2017 7:07 pm

Postby Mark » Fri Mar 30, 2018 3:36 pm

Hi divinest,

Very good. Sorry, no, there is no option to show blank instead of 0.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby divinest » Fri Mar 30, 2018 3:38 pm

Okay thanks Mark, was thinking if there was a way using the IF function, but i guess it may not work for this option. In any case the report does provide the details needed, masking zero is more of a cosmetic item. Thanks again.
divinest
 
Posts: 149
Joined: Tue Sep 05, 2017 7:07 pm

Postby larryw » Fri May 04, 2018 6:14 pm

Just getting around to digging deeper into this but it appears custom fields are not available in the personal version and only the 6 month option is available. Correct?
larryw
 
Posts: 60
Joined: Tue Feb 02, 2016 5:15 pm

Postby Mark » Sat May 05, 2018 9:19 am

Hi larryw,

Correct. In the Custom report, only the "built-in" fields are available in the Personal version. There are hundreds to choose from. You are correct that the "user-defined" field feature, where you write your own equations, is only available in the Professional/Advisor versions.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Reports

Who is online

Users browsing this forum: No registered users and 12 guests

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