HOLLYWOOD STOCK EXCHANGE
THE ENTERTAINMENT MARKET
THE ENTERTAINMENT MARKET
Thanks but I already worked all those bits out months ago. :)
I've got a few cells where my IF's are three layers deep to account for potential delist, next film not having a release date yet and straight forward "this date". Not to mention automatically handling determining the proper TAG formula (/3, /4 or /5).
At this point I've pretty much finished up polishing and have written the documentation. My biggest issue is the number of web page data calls, it takes too long to update the file, but I don't have access to the feed HSX provides some of the fan sites. And there's no automatic updating of the Starbonds when a movie delists but that's mostly a limitation of doing it with a spreadsheet rather than a web page. 
Dumb question - dROI - how calculated? (I thought it was in the Help section somewhere....) Dec 15, 20:51
I calculate it like this for KaiGee.com Dec 15, 21:16
dROI = (expected value/current value)^(1/# of days) – 1 . See http://www.theampersand.net/?page_id=134#30 {nm} Dec 15, 21:46
The gibberish is simply "-1" {nm} Dec 15, 21:47
That's based on a formula used for ROI of investments with compounding returns, isn't it? {nm} Dec 15, 21:48
What software are you using for tour spreadsheet? {nm} Dec 15, 21:50
Excel {nm} Dec 15, 22:08
Here's a couple of tips for developing your formula. Dec 16, 16:50
Thanks but I already worked all those bits out months ago. :) Dec 16, 18:35
