Z PORTFOLIO Message Board

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : Z PORTFOLIO

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next

To: Susan Saline who wrote (5311)	9/24/2000 2:34:53 PM
From: DanZ	Read Replies (2) of 11568

Sue, Here is the formula for calculating average profit %: Average Profit (%) = Average profit ($) / Average cost The calculation only includes closed positions. It would be good to include the open positions as well, but I can't think of an easy way to do it in Excel. I was thinking about writing a database application (Access or FoxPro) or Visual Basic program to provide a nice front end GUI and automate all the functionality of the portfolio. For now, most everything is manual including moving closed positions from the open positions page to the closed positions page and creating the weekly report. The only thing automated is updating the closing prices and basic calculations between cells in the spreadsheet. With the present spreadsheet, it would take a lot of manual calculations to include the open positions in the weekly report. For example, I would have to manually sum the gain/loss on open positions for each person and copy the result to the weekly report. One benefit of writing a program to automate the portfolio is that anyone could use it to keep track of the portfolio when I'm out of town or if someone just wants to do it for some odd ball reason <g>. It would take some time to develop, but should give a good payback in time savings if we continue trading the portfolio. Ron: Since you are our resident tuna guru, I was wondering if you could answer a question. I heard on the news that canned tuna is cheaper than at any time in the last 20 years. A local grocer had Chicken of the Sea tuna on sale 4 cans for $1.00 last week. Based on your fishing reports, one might surmise that the tuna supply is scarce. Why is canned tuna so cheap if there aren't many tunas swimming around? Are they just different types of tuna? I'm sure the answer isn't that you've lost your touch as a Master Tuna Fisherman. lol

Report TOU Violation

Share This Post

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next