AApple just added support to pull stock prices from Yahoo Finance into a numbers sheet. But I cannot pull Options prices on my iPad. is it possible to pull option prices in a numbers sheet?
iPad (4th gen) Wi-Fi, iOS 10.2
I followed the example, but get error messages that say either it's not a valid symbol, or there is no bid price for this security. Any pointers on what I could be doing wrong?
Thanks,
Brian
Hi Brian,
Are you using a valid symbol?
SG
Hi SG,
I think so. I am trying to use the CBOE Jan 18 $47.5 Call and am entering it as CBOE180119C00047500 I also tried NVDA190118C00005500
Any suggestion?
Thanks much,
Brian
Not sure those are valid for Yahoo! Finance. Maybe too long-dated? For example, I don't see NVDA190118C00005500 here. The other symbols there do work.
SG
Could be. I can get some prices and not others so I'll see if I can find a pattern to it. Either way, it puts me miles ahead of where I was with Excel for Mac.
Thanks again,
Brian
What I have noticed is that if the option does not trade for some time, you will get an error for retrieving prices. For illiquid securities it can be an issue. For most tickets it works.
VS
Can you test your method again? After the most recent update I can't seem to get this to work anymore.
Thanks.
If you haven't done so already you can give feedback to Apple via Numbers > Provide Numbers Feedback.
SG
Looks like the newest update just removed the Bid and Ask prices but before that tracking options worked great.
You're still able to retrieve option prices? I have yet to get any to work since the update. Can you give a sample formula/symbol that you've had luck with? Thanks in advance
Can I track Options prices in numbers
