Fixed Price: Not Sure
| Posted: 5h, 16m ago | Ends: 2d, 18h |
I need help developing a way to predict the behavior of an investment. It follows simples rules: 1. It updates once a day. 2. Each day it can either gain or lose value. Let's say it goes either $+1 or $-1 each day. Randomly. 3. In the course of a indefinite timeframe, it always tends to zero. (In 100 days, it will roughly gain value 50 days and lose 50 days) 4. Every day its value rises, it will rise "X" more than before (for example, for a 3 day gain streak, I want it to rise $1 on day 1, $2 on day 2 and $3 on day 3. If it is a 10 day streak, I should gain $10 on the last day). 5. Every day its value decreases, it will always decrease the same amount, say $-1 day 1, $-1 day 2, $-1 day 3), regardless of the streak. 6. HOWEVER, when going from a winning streak to a losing streak, the first losing day will always decrease as the winning progression does. (Example, rise $1 on day 1, $2 on day 2 and $3 on day 3. If the fourth is a fall, I lose $-4 on day 4, then $-1 day 5, $-1 ...
Category: Investment Analysis
Fixed Price: Less than $500
| Posted: Feb 20, 2015 | Ends: 22d, 15h |
In need of a formula to apply to a cell that contains a string of text, and be able to then extract certain words from that string of text and apply a number to that word,e.g., "house was recently renovated." Text "renovated" would be given a number, say, 1. This number assignment would come from a table. This is similar to LOOKUP and VLOOKUP formula but applied to a string of text in a row of Excel 2013. NOTE: if not possible in Excel, can you do it in Access?
Category: Other - Finance & Mgmt