3 Messages
Digest #4463
Messages
Fri Jan 18, 2019 3:07 pm (PST) . Posted by:
bobobfd
Hi Randy,
This is one of those "one-offs" that I'm not sure can be fixed, but here goes.
When using {=smfGetOptionExpirations($A$5,,,,,,,"M")} in an array, it returns all the expiration dates for TDOC (A5=TDOC) except for April 2019. The 3rd Friday of April is the 19th which is Good Friday. The market expiration date is actually the 18th. - https://www.marketwatch.com/optionscenter/calendar/2019 https://www.marketwatch.com/optionscenter/calendar/2019 .
Any way you can incorporate the market holidays into the function?
Thanks ~~ Bruce
This is one of those "one-offs" that I'm not sure can be fixed, but here goes.
When using {=smfGetOptionExpirations($A$5,,,,,,,"M")} in an array, it returns all the expiration dates for TDOC (A5=TDOC) except for April 2019. The 3rd Friday of April is the 19th which is Good Friday. The market expiration date is actually the 18th. - https://www.marketwatch.com/optionscenter/calendar/2019 https://www.marketwatch.com/optionscenter/calendar/2019 .
Any way you can incorporate the market holidays into the function?
Thanks ~~ Bruce
Fri Jan 18, 2019 5:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, I think it would take a fair amount of effort to work
holidays into the algorithm...
If I think of something, I'll let you know.
On Fri, Jan 18, 2019 at 4:07 PM bobobfd@... wrote:
>
> This is one of those "one-offs" that I'm not sure can be fixed, but here
> goes.
>
> When using {=smfGetOptionExpirations($A$5,,,,,,,"M")} in an array, it
> returns all the expiration dates for TDOC (A5=TDOC) except for April 2019.
> The 3rd Friday of April is the 19th which is Good Friday. The market
> expiration date is actually the 18th. -
> https://www.marketwatch.com/optionscenter/calendar/2019 .
>
> Any way you can incorporate the market holidays into the function?
>
>
holidays into the algorithm...
If I think of something, I'll let you know.
On Fri, Jan 18, 2019 at 4:07 PM bobobfd@... wrote:
>
> This is one of those "one-offs" that I'm not sure can be fixed, but here
> goes.
>
> When using {=smfGetOptionExpirations($A$5,,,,,,,"M")} in an array, it
> returns all the expiration dates for TDOC (A5=TDOC) except for April 2019.
> The 3rd Friday of April is the 19th which is Good Friday. The market
> expiration date is actually the 18th. -
> https://www.marketwatch.com/optionscenter/calendar/2019 .
>
> Any way you can incorporate the market holidays into the function?
>
>
Sat Jan 19, 2019 12:44 am (PST) . Posted by:
alankc_mok
Randy,
Thanks for your reply.
If I want to get the Market Cap and P/E Ratio from investing.com https://www.investing.com/equities/tencent-holdings-hk https://www.investing.com/equities/tencent-holdings-hk should I use RCHGetTableCell ?
I have used =RCHGetTableCell("https://www.investing.com/equities/tencent-holdings-hk",1,">Market Cap")
but fail.
Regards
Alan
Thanks for your reply.
If I want to get the Market Cap and P/E Ratio from investing.com https://www.investing.com/equities/tencent-holdings-hk https://www.investing.com/equities/tencent-holdings-hk should I use RCHGetTableCell ?
I have used =RCHGetTableCell("https://www.investing.com/equities/tencent-holdings-hk",1,"
but fail.
Regards
Alan
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar