7 Messages
Digest #4097
Messages
Wed Jul 19, 2017 10:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
With all the changes Yahoo made a few months ago, one of the things on the
"to do" list is to redefine all of the mutual fund elements so they can
come from Yahoo's new JSON feeds. For example, something like this would be
the new element definition for the annual expense ratio:
=smfGetYahooJSONField("VWEAX","defaultKeyStatistics";,"quoteSummary.result.0.defaultKeyStatistics.annualReportExpenseRatio.raw")
BTW, if you're getting "Error" returned, you have old element definitions.
The current definitions for element #5079 should return "TBD"...
On Wed, Jul 19, 2017 at 9:39 PM, tarakayan@
...
wrote:
> can we get ETF expense ratio from RCH getelements? I tried and get error
> msg
>
"to do" list is to redefine all of the mutual fund elements so they can
come from Yahoo's new JSON feeds. For example, something like this would be
the new element definition for the annual expense ratio:
=smfGetYahooJSONFie
BTW, if you're getting "Error" returned, you have old element definitions.
The current definitions for element #5079 should return "TBD"
On Wed, Jul 19, 2017 at 9:39 PM, tarakayan@
...
wrote:
> can we get ETF expense ratio from RCH getelements? I tried and get error
> msg
>
Thu Jul 20, 2017 3:22 am (PDT) . Posted by:
"V. Shankar" tarakayan
Thank you...Yes I am using the old definition file...just saw TBD in the definitions.
On Thursday, July 20, 2017, 11:22:16 AM GMT+5:30, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
With all the changes Yahoo made a few months ago, one of the things on the "to do" list is to redefine all of the mutual fund elements so they can come from Yahoo's new JSON feeds. For example, something like this would be the new element definition for the annual expense ratio:
=smfGetYahooJSONField("VWEAX","defaultKeyStatistics";,"quoteSummary.result.0.defaultKeyStatistics.annualReportExpenseRatio.raw")
BTW, if you're getting "Error" returned, you have old element definitions. The current definitions for element #5079 should return "TBD"...
On Wed, Jul 19, 2017 at 9:39 PM, tarakayan@... wrote:
can we get ETF expense ratio from RCH getelements? I tried and get error msg
On Thursday, July 20, 2017, 11:22:16 AM GMT+5:30, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
With all the changes Yahoo made a few months ago, one of the things on the "to do" list is to redefine all of the mutual fund elements so they can come from Yahoo's new JSON feeds. For example, something like this would be the new element definition for the annual expense ratio:
=smfGetYahooJSONFie
BTW, if you're getting "Error" returned, you have old element definitions. The current definitions for element #5079 should return "TBD"
On Wed, Jul 19, 2017 at 9:39 PM, tarakayan@... wrote:
can we get ETF expense ratio from RCH getelements? I tried and get error msg
Thu Jul 20, 2017 5:00 am (PDT) . Posted by:
bob_15861586
Randy,
Thanks for the response. Are you sure about barchar.com updating their option quotes only once an hour? It does not sound good to me. Can you point me to some place on the web where it says that?
Thanks,
Bob
Thanks for the response. Are you sure about barchar.com updating their option quotes only once an hour? It does not sound good to me. Can you point me to some place on the web where it says that?
Thanks,
Bob
Thu Jul 20, 2017 8:41 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you go to an options quotes page:
https://www.barchart.com/stocks/quotes/MMM/options
...you'll see a "?" icon in the upper right. Click on it and one of the
items of info is:
"Options information is delayed a minimum of 30 minutes, and is updated
once an hour, with the first update at 10:30am ET."
I was disappointed when I found that the other day.
On Thu, Jul 20, 2017 at 5:00 AM, bob_15861586@
...
wrote:
>
> Thanks for the response. Are you sure about barchar.com updating their
> option quotes only once an hour? It does not sound good to me. Can you
> point me to some place on the web where it says that?
>
>
>
https://www.barchart.com/stocks/quotes/MMM/options
...you'll see a "?" icon in the upper right. Click on it and one of the
items of info is:
"Options information is delayed a minimum of 30 minutes, and is updated
once an hour, with the first update at 10:30am ET."
I was disappointed when I found that the other day.
On Thu, Jul 20, 2017 at 5:00 AM, bob_15861586@
...
wrote:
>
> Thanks for the response. Are you sure about barchar.com updating their
> option quotes only once an hour? It does not sound good to me. Can you
> point me to some place on the web where it says that?
>
>
>
Thu Jul 20, 2017 9:44 am (PDT) . Posted by:
bob_15861586
Randy,
Thanks for the information. They way I read that, the values that I get at 4:30 should be the very near the closing values if not the closing values. Do I have that right?
In any case, I can always get the end of day pricing at 5:30.
Thanks,
Bob
Thanks for the information. They way I read that, the values that I get at 4:30 should be the very near the closing values if not the closing values. Do I have that right?
In any case, I can always get the end of day pricing at 5:30.
Thanks,
Bob
Thu Jul 20, 2017 10:00 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That seems to be the way to interpret what they say. But if you are seeing
changes between 4:30 and 5:30...
On Thu, Jul 20, 2017 at 9:44 AM, bob_15861586@
...
wrote:
>
> Thanks for the information. They way I read that, the values that I get at
> 4:30 should be the very near the closing values if not the closing values.
> Do I have that right?
>
> In any case, I can always get the end of day pricing at 5:30.
>
>
>
changes between 4:30 and 5:30...
On Thu, Jul 20, 2017 at 9:44 AM, bob_15861586@
...
wrote:
>
> Thanks for the information. They way I read that, the values that I get at
> 4:30 should be the very near the closing values if not the closing values.
> Do I have that right?
>
> In any case, I can always get the end of day pricing at 5:30.
>
>
>
Thu Jul 20, 2017 7:47 am (PDT) . Posted by:
ssztaba
Randy,
The re-install of the Add-in did the trick -- options pricing come through fine.
Thank you.
Stan
The re-install of the Add-in did the trick -- options pricing come through fine.
Thank you.
Stan
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar