Was working with volume and short data. Elements: 979 980 981 982 985 988
I wasn't getting consistent conversion of the K/M/B and numbers with no indicator. It was correct on the web (with the correct indicator shown) but the spreadsheet was occasionally making an error in terms of conversion consistency. Is there a work around?

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

2b

Re: Yahoo - potential issues with k/m/b (thousand/million/billion)

Thu Apr 27, 2017 9:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Most of that will go away on Yahoo when data is grabbed from their JSON
data files, because they have "raw" values. For example, the workaround for
#982 right now would be:

=smfConvertData(smfStrExtr(smfWord(RCHGetWebData("
https://query1.finance.yahoo.com/v10/finance/quoteSummary/
"&D7&"?modules=defaultKeyStatistics"),2,"""sharesOutstanding"":"),"""raw"":",","))

When I get the new function(s) done, the element definitions will be based
on something like:

=smfGetYahooJSONField(D7,"defaultKeyStatistics","quoteSummary.result.0.defaultKeyStatistics.sharesOutstanding.raw")

In the most recent version of the add-in, I think this still works:

=smfGetYahooJSONData(D7,"defaultKeyStatistics","sharesOutstanding")

...but it's all positional extraction and not as reliable as the fully
qualified field name.

Just ticker, module, and fully qualified variable name on the JSON file.

I'm trying to create a database of qualified data names for the modules I'm
aware of. There are a number of them.

On Thu, Apr 27, 2017 at 8:33 PM, labsrj@
...wrote:

>
> Was working with volume and short data. Elements: 979 980 981
> 982 985 988
> I wasn't getting consistent conversion of the K/M/B and numbers with no
> indicator. It was correct on the web (with the correct indicator shown) but
> the spreadsheet was occasionally making an error in terms of conversion
> consistency. Is there a work around?
>

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

3a

Re: How to Extract Financial Information from Morningstar

Fri Apr 28, 2017 2:44 am (PDT) . Posted by:

who1012000

If I am not able to accomplish all within and using code then it is not useful to me.

Thanks for your time and efforts.

David

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

3b

Re: How to Extract Financial Information from Morningstar

Fri Apr 28, 2017 9:41 am (PDT) . Posted by:

who1012000

This is really not for my consumption, but for a 3rd party. It appears that none of my previous queries from with in VBA are going to work. At this point I may give up trying to accomplish it with VBA.

Thank you all for your time and efforts.

Thanks, David

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

4 MS and Yahoo data

Fri Apr 28, 2017 8:20 am (PDT) . Posted by:

joelfp2000

Randy,

Thank you so much for keeping all the elements up to date and for all of your help over the many years! I use your elements and formulas daily and it has been very profitable.

I just wanted to say "thanks" and I look forward to the new updated files, especially the Yahoo and Morningstar mutual fund changes.

Thanks again.

Joel