HOLLYWOOD STOCK EXCHANGE
THE ENTERTAINMENT MARKET
THE ENTERTAINMENT MARKET
Here's a couple of tips for developing your formula.
Remember that if you already have a date column, you need only refer to the block ie. B4
The dROI result needs to be formatted as general or number to work. I use numbers so I can manage decimal points to 2.
If you want to know the difference in #'s of days between a certain time and today, you enter "B4-Today()" or use Datevalue(date_text) function. You DO NOT have to use datevalue if you already have a date column.
Hope that helps a bit. It's not hard if you know those little tips. When in doubt, press F1.
Â
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
