wisconsinpat
New Member
- Joined
- Nov 19, 2017
- Messages
- 1
Haven't used excel for years and forgot most everything
Here's what I'm trying to do
Produce line graph
Purchase for example an option ABBV ON 8/25/17 (Nov $15. call FOR 1.50) (THIS WOULD BE THE MEAN LINE ON LINE CHART)
ON THE CHART I WANT TO PLOT DAY BY DAY (5 days a week as market is open and not show closed days)
Then I want to show line daily above/below mean line as option value rises or falls showing $ amt. option price ended at around $13.00 within the next 30 days
this is basically what I want chart to show
If I could get step by step how to do this I's sure appreciate it. I did a 4 min youtube video to further explain below is the link https://youtu.be/xpBB4PSF4O8
Here's what I'm trying to do
Produce line graph
Purchase for example an option ABBV ON 8/25/17 (Nov $15. call FOR 1.50) (THIS WOULD BE THE MEAN LINE ON LINE CHART)
ON THE CHART I WANT TO PLOT DAY BY DAY (5 days a week as market is open and not show closed days)
Then I want to show line daily above/below mean line as option value rises or falls showing $ amt. option price ended at around $13.00 within the next 30 days
this is basically what I want chart to show
If I could get step by step how to do this I's sure appreciate it. I did a 4 min youtube video to further explain below is the link https://youtu.be/xpBB4PSF4O8