LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
Posts: 3
Default Day Trading Spreadsheet

I have created a spreadsheet that captures all the trades that I make
and does a few calculations for profit/loss and stop loss calculations.
While a trade is ACTIVE, I want to monitor just the ACTIVE trades on
another Tab.

On this new Sheet called ACTIVE TRADES I have values for:

Risk, Initial Price, Initial Stop Loss, Current Price, Modified Stop
Loss. I am populating this Active Trades Sheet by determining, if the
Exit Price from my All Trades Sheet is empty. If this value is blank,
then the trade is considered active. This is working just fine for me.

However, the other values for Risk, Initial Price, Initial Stop Loss are
showing in their respective columns, because I have formulas that
populate regardless to the value shown in Exit Price. Is there a more
elegant way to just track my Active trades on another Sheet within the
same Workbook, without doing what I have done above.

I've been doing some research on arrays and vlookup, but I'm not sure if
these are the proper methods to do what I want to do.
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Trading File Carpe Diem Excel Programming 1 July 14th 09 11:08 AM
My first year trading [email protected] Excel Programming 0 July 30th 08 11:32 AM
I need template for day trading Paula K Excel Programming 1 December 19th 07 04:09 PM
When setting up TAL Trading tools what is domain? CBEN Excel Discussion (Misc queries) 0 December 31st 05 02:33 AM
Commodity Trading? Solver maybe.... bonjella Excel Discussion (Misc queries) 3 June 8th 05 05:07 PM

All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright ©2004-2023 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"