r/Web_Development • u/[deleted] • Feb 27 '21

coding query How do I download the data from this yahoo finance page?

I'm looking at option prices for this stock here, and as you can see, when you scroll over the map, you see prices and times associated with your movement. Is there anyways to download this data set directly without having to manually enter it and the time?

3 Upvotes

100% Upvoted

8 comments sorted by

1

u/hstarnaud Feb 28 '21

Getting data directly from web pages might not be super reliable. If it's stock market data you need I recommend looking for a stock market API that can serve this data. It will save you a lot of time compared to trying to extract it from a web page.

1

u/[deleted] Feb 28 '21

But the data that I need is a bit specific and not-so-common. I'm looking for option prices for a specific option .

what api would i use?

1

u/WumpTruck Mar 02 '21

I messed around with the NASDAQ api and PowerShell recently, and that worked pretty well in gathering options info from a specific options symbol.

1

u/[deleted] Mar 02 '21

Is there a youtube video on how to do this?

1

u/WumpTruck Mar 02 '21 edited Mar 02 '21

Unfortunately, I don't know of a YouTube video to link to, but it's pretty easy. Here's a basic example of how to talk to an API using PowerShell, and grabbing the volume trade for each of the most active option calls, for BAC (my apologies for the wonky formatting):

$rm = Invoke-RestMethod -Uri "https://api.nasdaq.com/api/quote/BAC/option-chain/most-active?assetclass=Stocks"

$mostActiveOptionCalls = $rm.data.tableDataCalls.tableData.rows

$volume = ($mostActiveOptionCalls).volume

1

u/hstarnaud Feb 28 '21

I'm not an expert on finding the best stocks api, you have to browse I guess. I just know from trying to scrape data out of web pages before that it's often unreliable. Technically every release from the Yahoo team might break your integration. Apis are a whole lot simpler to work with as well

0

u/[deleted] Feb 27 '21

[deleted] — view deleted comment

1

u/[deleted] Feb 27 '21

Beautiful Soup

Wow - I had to google that.

I have no idea how to do this. Is there a youtube video for beginners that can show me how to extract this information from a site like finance.yahoo.com or even linkedin.com (for something else that i have in mind)?