Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Divicalc works again...
Old 06-09-2018, 05:25 PM   #1
Recycles dryer sheets
 
Join Date: Jun 2014
Posts: 439
Divicalc works again...

Hi All.

For those of you that used the divicalc.com tool that I put together a few years back, I spend a couple of days and got it working again.

It's not battle tested, so if you find bugs, please let me know.

For those of you who are interested what happened was that when Verizon bought Yahoo they aggressively closed all non-ad generating stuff. This pissed off a lot of developers who were making little financial apps.

There are not a lot of options for reliable, historical stock data that aren't insanely expensive but I managed to finally find one.

Also, most of the data sources tend to be geared to day traders or people who want to back test a few years... I really need a decade or more of information (preferably to the start of time ); so thank goodness I found that.

Anyway, feel free to comment if you find bugs or have requests. I'm not quite FIRE'd yet and have 2 young kids at home so time is at a premium but I really enjoy building tools like this!

Cheers.
__________________

petershk is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 06-09-2018, 05:32 PM   #2
Thinks s/he gets paid by the post
 
Join Date: Nov 2015
Posts: 1,075
Ummm.. what is divicalc?
__________________

bobandsherry is offline   Reply With Quote
Old 06-09-2018, 10:31 PM   #3
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 20,086
Quote:
Originally Posted by bobandsherry View Post
Ummm.. what is divicalc?
And did it ever work?

When it worked, what did it do?

I'm in the dark on this. Op is talking like we all are intimately familiar this.

edit - ok, I see now that divicalc is a link (but not indicated as such). OK, it shows historical divs. Isn't that easy to find on the web?

-ERD50
ERD50 is offline   Reply With Quote
Old 06-09-2018, 11:11 PM   #4
Thinks s/he gets paid by the post
zinger1457's Avatar
 
Join Date: Jul 2007
Posts: 1,766
I think the intent of the tool is to just show how much yearly income (distributions) one could have generated from a given investment over a period of time. The tool doesn't reinvest the distributions like most of us would do with our investments.
zinger1457 is offline   Reply With Quote
Old 06-10-2018, 06:13 AM   #5
Thinks s/he gets paid by the post
FIRE'd@51's Avatar
 
Join Date: Aug 2006
Posts: 2,385
The tool clearly isn't handling splits correctly. As a quick tryout, I entered Citigroup (C) for the default dates, and it didn't properly handle the 1 for 10 reverse split in March 2011. The program appears to be picking up the adjusted prices, but isn't adjusting the shares held.
__________________
I'd rather be governed by the first one hundred names in the telephone book than the Harvard faculty - William F. Buckley
FIRE'd@51 is offline   Reply With Quote
Old 06-10-2018, 08:35 AM   #6
Recycles dryer sheets
 
Join Date: Jun 2014
Posts: 439
Let me look into the splits thing. I tried splits but not reverse.

As for the other questions. I didn't want to over promote. There was an old thread when I first introduced the program but it's too old to reply to.

The idea was to have a simple way to claculate the earnings from dividends as well as the growth of the investment.

It was so I could answer my own questions about how a dividend portfolio might have returned annual and monthly income in the past.

I know there are lots of programs that calculate returns but I wanted something more simple and focused.

It was also fun and a way to keep my brain active and programming skills somewhat in shape.

Thanks!
petershk is offline   Reply With Quote
Old 06-10-2018, 09:04 AM   #7
Recycles dryer sheets
 
Join Date: Jun 2014
Posts: 439
Took a quick look at the splits problem with C. It turns out that I had splits working correctly in the dev version but a difference in configuration made that part of the data gathering not function for the live version. Should be working now.

That said, it created a very suspicious spike in 2002 when C looks like they did a special dividend in August. My app showed 24.15 which seemed impossible, so I looked at it should be 2.41. I looked at the underlying data source and it seems like it's an error in their data which is frustrating . I checked all the other dividends for Citibank and they look like they match official records so I'm not sure why this one is wrong.

If anyone sees any other problems, especially with special dividends, let me know.
petershk is offline   Reply With Quote
Old 06-10-2018, 09:30 AM   #8
Thinks s/he gets paid by the post
FIRE'd@51's Avatar
 
Join Date: Aug 2006
Posts: 2,385
Quote:
Originally Posted by petershk View Post
Took a quick look at the splits problem with C. It turns out that I had splits working correctly in the dev version but a difference in configuration made that part of the data gathering not function for the live version. Should be working now.

That said, it created a very suspicious spike in 2002 when C looks like they did a special dividend in August. My app showed 24.15 which seemed impossible, so I looked at it should be 2.41. I looked at the underlying data source and it seems like it's an error in their data which is frustrating . I checked all the other dividends for Citibank and they look like they match official records so I'm not sure why this one is wrong.

If anyone sees any other problems, especially with special dividends, let me know.
There are still errors in your Summary Data for Total Return and CAGR
__________________
I'd rather be governed by the first one hundred names in the telephone book than the Harvard faculty - William F. Buckley
FIRE'd@51 is offline   Reply With Quote
Old 06-10-2018, 02:44 PM   #9
Thinks s/he gets paid by the post
 
Join Date: Mar 2011
Posts: 4,954
Quote:
Originally Posted by ERD50 View Post
And did it ever work?

When it worked, what did it do?

I'm in the dark on this. Op is talking like we all are intimately familiar this.

edit - ok, I see now that divicalc is a link (but not indicated as such). OK, it shows historical divs. Isn't that easy to find on the web?

-ERD50
Quote:
Originally Posted by FIRE'd@51 View Post
There are still errors in your Summary Data for Total Return and CAGR
Thanks petershk! I found this tool useful in the past and remember a few folks here asking what had happened to it. (ERD, OP brought this out a few years ago and there was a fair amount of discussion and trial at the time)

As far as the discrepancies, I see this tool as a 'close enough but not dead-on' thing.

I also use Google Finance and find that their numbers do not hit my actual numbers 100% accurately, but close enough for planning purposes; if divicalc is using similar source(s) that might explain it.
__________________
Living well is the best revenge!
Retired @ 52 in 2005
marko is offline   Reply With Quote
Old 06-12-2018, 09:27 AM   #10
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 20,086
Quote:
Originally Posted by zinger1457 View Post
I think the intent of the tool is to just show how much yearly income (distributions) one could have generated from a given investment over a period of time. The tool doesn't reinvest the distributions like most of us would do with our investments.
Doesn't this tool provide that option to not reinvest divs? It looks like if you create a free account, you can export the data to excel to sum up those annual divs.

www.portfoliovisualizer.com

https://goo.gl/JmA7Xt < I loaded with some examples


-ERD50
__________________

ERD50 is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
FSB or KGB~ It still works the same mickeyd Other topics 1 11-27-2006 04:33 PM
Social Security Again Again??? greg Other topics 60 11-13-2006 05:06 PM
It really works! shelly Other topics 27 11-02-2005 09:26 PM
A remote control that works on humans. Nords Other topics 0 10-30-2005 10:17 AM
Dory's Cold Brewed Works! unclemick Other topics 5 05-16-2005 04:12 PM

» Quick Links

 
All times are GMT -6. The time now is 02:10 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2018, vBulletin Solutions, Inc.