Extract Options Data from Yahoo

%3CLINGO-SUB%20id%3D%22lingo-sub-2315254%22%20slang%3D%22en-US%22%3EExtract%20Options%20Data%20from%20Yahoo%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2315254%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20wish%20to%20extract%20options%20data%20from%20Yahoo.%3C%2FP%3E%3CP%3EI'm%20under%20the%20impression%20%3CU%3EVBA%3C%2FU%3E%20or%20%3CU%3EPython%3C%2FU%3E%20in%20Excel%20would%20provide%20the%20solution.%3C%2FP%3E%3CP%3EI'm%20willing%20to%20learn%20either%20one%20of%20these%20programs%20(or%20another%20in%20Excel).%3C%2FP%3E%3CP%3ECould%20someone%20tell%20me%20which%20is%20better%2C%20easier%20for%20scraping%20data%20from%20Yahoo%2C%20or%20I'm%20I%20on%20the%20wrong%20path%3F%3C%2FP%3E%3CP%3EMuch%20appreciated.%3C%2FP%3E%3CP%3ERye%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2315254%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2315629%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Options%20Data%20from%20Yahoo%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2315629%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034179%22%20target%3D%22_blank%22%3E%40RyeTo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20extract%20Options%20data%20all%20the%20time%2C%20doing%20so%20from%20Fidelity's%20Active%20Trader%20Pro%20platform.%20The%20data%20I%20get%20falls%2C%20I%20guess%2C%20into%20two%20categories%3A%3C%2FP%3E%3CUL%3E%3CLI%3Ecurrent%20bid%20and%20ask%20prices%20on%20options%20positions%20I%20current%20hold%20(Calls%2C%20Puts%2C%20Spreads...)%3C%2FLI%3E%3CLI%3Eoptions%20chains%20to%20assess%20positions%20I%20might%20be%20contemplating%20in%20a%20given%20underlying%20company%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20don't%20say%20what%20kind%20of%20options%20data%20you%20are%20interested%20in%20getting%2C%20although%20I'd%20assume%20it%20would%20include%20those.%20My%20own%20recommendation%20would%20be%20to%20look%20at%20what%20your%20broker%20(I'm%20assuming%20you%20have%20one)%20already%20makes%20available%20and%20whether%20or%20not%20you%20could%20export%20from%20them%20or%20use%20an%20API%20of%20some%20kind%20to%20extract%20real-time%20data.%20If%20you're%20into%20all%20the%20Greeks%2C%20then%20you're%20involved%20in%20a%20different%20kind%20of%20options%20trading%20than%20I%20am%2C%20and%20I'll%20defer%20to%20others.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

I wish to extract options data from Yahoo.

I'm under the impression VBA or Python in Excel would provide the solution.

I'm willing to learn either one of these programs (or another in Excel).

Could someone tell me which is better, easier for scraping data from Yahoo, or I'm I on the wrong path?

Much appreciated.

Rye 

2 Replies

@RyeTo 

 

I extract Options data all the time, doing so from Fidelity's Active Trader Pro platform. The data I get falls, I guess, into two categories:

  • current bid and ask prices on options positions I current hold (Calls, Puts, Spreads...)
  • options chains to assess positions I might be contemplating in a given underlying company

 

You don't say what kind of options data you are interested in getting, although I'd assume it would include those. My own recommendation would be to look at what your broker (I'm assuming you have one) already makes available and whether or not you could export from them or use an API of some kind to extract real-time data. If you're into all the Greeks, then you're involved in a different kind of options trading than I am, and I'll defer to others.

 

 

Thanks for the reply.
I do get options data from my broker, unfortunately they're not dynamic.
Thanks