0

I was able to get ask/bid option prices for a particular option from Fidelity Brokerage's web site using Google Sheets and importXML - but no longer. I think the site changed.

The website to access Option prices is now:

https://researchtools.fidelity.com/ftgw/mloptions/goto/detailedQuote?symbols=-BTI220819P40&type=o-NavBar

where -BTI220819P40 is the particular put option.

When I view the source page, I can see the bid and ask elements I'm interested in. Here's a portion of the source page for the above link:

                                <div>
                                    <p class="bav-header">Bid</p>
                                    <p class="bav-value">
                                                41.86 X 5
                                    </p>
                                </div>
                                <div>
                                    <p class="bav-header ">Ask</p>
                                    <p class="bav-value">
                                                42.08 X 4
                                    </p>
                                </div>

When I attempt to obtain those values with importXML in Google Sheets I get "Error: Imported content is empty".

=importXML("https://researchtools.fidelity.com/ftgw/mloptions/goto/detailedQuote?symbols=-BTI220715P40&type=o-NavBar", "//p[@class='bav-value']")

Can anyone tell me how to get these bid and ask values?

2
  • I think you have to be registered to access that link ... so I wasn't able to try to help you
    – Daniele
    Jun 20 at 0:51
  • Yes, @Daniele I believe that's right - you have to log-in to Fidelity's web site on one of the tabs of your browser.
    – Al Nudo
    Jun 20 at 2:54

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.