6 Messages
Digest #3856
Messages
Wed Nov 30, 2016 7:03 am (PST) . Posted by:
justy_sports
That is helfpul, thank you.
Is there a similar JSON page for the "Statistics" page? I tried using the module "defaultKeyStatistics" but it is missing certain items (like 50 day moving average). Just looking for the URL (if there is one), I can build the formula to extract the data from there.
Is there a similar JSON page for the "Statistics&qu
Wed Nov 30, 2016 7:59 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It appears the JSON code is right in the web page of the Key Statistics.
For example, this:
=RCHGetWebData("http://finance.yahoo.com/quote/MMM/key-statistics
","""fiftyDayAverage"":")
...returns something like:
"fiftyDayAverage":{"raw":170.09029,"fmt":"170.09"},"trailingAnnualDividendRate":{"raw":4.355,"fmt":"4.36"},"open":{"raw":172.2,"fmt":"172.20"},"averageVolume10days":{"raw":1520300,"fmt":"1.52M","longFmt":"1,520,300"}...
For me, anyway. Try it and see what you get?
So you could go after each, one by one, using their field names...
A tool that might help is the SMF-Quick-Webpage-Examination.xls workbook.
Go to the "By cascading value" worksheet and set:
D7: http://finance.yahoo.com/quote/MMM/key-statistics
D8: "raw":
...and it will parse the web page by each of the raw values it has on the
web page. You should be able to do some manipulation from there to get the
field names for each raw or formatted value. The format can vary as some
field names have multiple values.
On Wed, Nov 30, 2016 at 8:03 AM, justy_sports@
...wrote:
>
> Is there a similar JSON page for the "Statistics" page? I tried using the
> module "defaultKeyStatistics" but it is missing certain items (like 50 day
> moving average). Just looking for the URL (if there is one), I can build
> the formula to extract the data from there.
>
For example, this:
=RCHGetWebData("http://finance.yahoo.com/quote/MMM/key-statistics
","""fiftyDayAverage"":")
...returns something like:
"fiftyDayAverage":{"raw":170.09029,"fmt":"170.09"},"trailingAnnualDividendRate":{"raw":4.355,"fmt":"4.36"},"open":{"raw":172.2,"fmt":"172.20"},"averageVolume10days":{"raw":1520300,"fmt":"1.52M","longFmt":"1,520,300"}...
For me, anyway. Try it and see what you get?
So you could go after each, one by one, using their field names...
A tool that might help is the SMF-Quick-Webpage-Examination.xls workbook.
Go to the "By cascading value" worksheet and set:
D7: http://finance.yahoo.com/quote/MMM/key-statistics
D8: "raw"
...and it will parse the web page by each of the raw values it has on the
web page. You should be able to do some manipulation from there to get the
field names for each raw or formatted value. The format can vary as some
field names have multiple values.
On Wed, Nov 30, 2016 at 8:03 AM, justy_sports@
...wrote:
>
> Is there a similar JSON page for the "Statistics&qu
> module "defaultKeySta
> moving average). Just looking for the URL (if there is one), I can build
> the formula to extract the data from there.
>
Wed Nov 30, 2016 9:41 am (PST) . Posted by:
justy_sports
This is perfect, thank you. Was able to parse everything I need using these strategies.
Of course, Yahoo data is very incomplete at the moment so it all might be for naught (ex. PEG Ratio is missing for over 200 companies).
Of course, Yahoo data is very incomplete at the moment so it all might be for naught (ex. PEG Ratio is missing for over 200 companies).
Wed Nov 30, 2016 12:30 pm (PST) . Posted by:
jdsboston
I'm entering functions into Excel using smfGetGoogleOptionQuote and as I enter them I get a VB error saying that smfStrExtr is not found. In fact I can't find it in any of the smf_addin. How do I get that routine installed properly?
Many thanks!
Many thanks!
Wed Nov 30, 2016 12:37 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It was added to the add-in in 2012. Do you have a current version of the
add-in?
It's in the "modUtilities" module.
On Wed, Nov 30, 2016 at 1:30 PM, jschantz@
...wrote:
> I'm entering functions into Excel using smfGetGoogleOptionQuote and as I
> enter them I get a VB error saying that
>
> smfStrExtr is not found. In fact I can't find it in any of the smf_addin.
> How do I get that routine installed properly?
>
>
>
add-in?
It's in the "modUtilities&
On Wed, Nov 30, 2016 at 1:30 PM, jschantz@
...wrote:
> I'm entering functions into Excel using smfGetGoogleOptionQ
> enter them I get a VB error saying that
>
> smfStrExtr is not found. In fact I can't find it in any of the smf_addin.
> How do I get that routine installed properly?
>
>
>
Wed Nov 30, 2016 1:37 pm (PST) . Posted by:
jdsboston
Randy -
Updating to the latest version solved it.
Many thanks,
Jim
Updating to the latest version solved it.
Many thanks,
Jim
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar