Assignment
1. For each of the investments shown, calculate the percent gain or loss based on the difference between the purchase and current price. Format as percent with one decimal.
2. Use a nested IF to calculate the investment action. The chart at the right shows the strategy that will be used by this investment firm.
|
Nick Herd Investments
|
|
Symbol
|
Name
|
Purchase Price
|
Current Price
|
Percent Gain/Loss
|
Investment Action
|
|
ABC
|
Abacus Ltd.
|
$16.50
|
$15.30
|
|
|
|
DIG
|
Diamond Imports
|
$53.50
|
$33.39
|
|
|
|
III
|
Indy Ink Inc.
|
$12.25
|
$11.75
|
|
|
|
EEK
|
Erie Knives
|
$9.75
|
$10.50
|
|
|
|
CAP
|
Canadian Petrol
|
$12.50
|
$11.50
|
|
|
|
GGG
|
Good Eggs
|
$35.20
|
$36.00
|
|
|
|
HAT
|
Hatfield Oil
|
$22.00
|
$18.00
|
|
|
|
Nick Herd Strategy
|
|
Percent Gain/Loss
|
Action
|
|
Gain greater than 5%
|
Buy
|
|
Between 5% and -5%
|
Hold
|
|
Loss greater than 5%
|
Sell
|