Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
formula on how to dynamically copy a cell
i have a question on excel if you can help me in the right direction. i have those 1 and 0 trigger. if the trigger is on (as 1), then i sell half of the stock (convert into cash and hold it until trigger is off) and leave half of stock invested. So as my excel goes, i need to copy the cash value as ...
i have a question on excel if you can help me in the right direction. i have those 1 and 0 trigger. if the trigger is on (as 1), then i sell half of the stock (convert into cash and hold it until trigger is off) and leave half of stock invested. So as my excel goes, i need to copy the cash value as constant for a period (until the trigger is off) and the invested stock i have to compound with the daily stock price movement. how would you do it? and when the trigger is off, i have to invest the cash back to stock and compound again. (i took the advance data course already, but still don't know how i can do this task.) thanks in advance.
Read More
Show All 1 Replies
Login to Reply
0
by Mandy L.
added 8 years ago
