[smf_addin] Digest Number 4544

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #4544

1a

Option Prices by richardrobbins28

1b

Re: Option Prices by "Randy Harmelink" rharmelink

2

invert table smfGetYahooHistory by wongkayau

Messages

1a

Option Prices

Wed May 22, 2019 12:23 pm (PDT) . Posted by:

richardrobbins28

Do you know of a way I can capture option prices for SPY at varying strike prices throughout the day via a macro or user defined function? I thought you may already have one.


Thanks for the help!
Richard

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

1b

Re: Option Prices

Wed May 22, 2019 12:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

smfGetYahooPortfolioView() retrieves option quotes from Yahoo. Delayed, of
course.

If you wanted to grab them at various times and save the quotes, you'd need
to write a small VBA routine.

On Wed, May 22, 2019 at 12:39 PM richardrobbins28@... wrote:

>
> Do you know of a way I can capture option prices for SPY at varying strike
> prices throughout the day via a macro or user defined function? I thought
> you may already have one.
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2

invert table smfGetYahooHistory

Thu May 23, 2019 4:20 am (PDT) . Posted by:

wongkayau

Hello Randy,


Happy Thursday!



A quick question: how to invert the output array table from smfGetYahooHistory? Now, heading is at the top of the data series. Is it possible to make the headings at the left hand side?


I found a similar question asked, but i could not find the solution.

https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/22220 https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/22220



Thank you so much.


Cheers,
L

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use