Wash Sale Formula

R

Rick

I have stock trades in a excel spreadshhet in which I need to look 30 days
previous and 30 days pat to see if that same security was traded - If so
figure the gain or loss of the 90 period of that security.
 
D

Don Guillett

More info on your setup would be needed. Wash sales can?? be subjective.
some wash sale rules and suggestions.http://tinyurl.com/6nhx3
You could use a FINDNEXT looping macro to look at all instance of that
symbol to see if it met the criteria and report findings to you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating the Count of Monthly Gains/Losses 3
Maintain lowest value in an "external connection" cell 0
Estimating Stock Trading Range From Historical Volatility 3
Calculate profits on stock sales on FIFO basis 5
Merge different queries 1
formula to lookup data in cell NEXT to another cell 3
Portfoio modelling formula help 0
Multiple If statements, Calculating quarterly % holding costs 0

Top