10 Messages
Digest #3997
Messages
Fri May 5, 2017 10:30 pm (PDT) . Posted by:
cyy001
Hi Randy,
What is the yahoo query that returns the JSON data for the portfolio view?
If I use
https://finance.yahoo.com/quotes/IBM,IBM170519C00155000/view/view_8 https://finance.yahoo.com/quotes/IBM,IBM170519C00155000/view/view_8
it returns the HTML page.
Thanks
Charles
What is the yahoo query that returns the JSON data for the portfolio view?
If I use
https://finance.yahoo.com/quotes/IBM,IBM170519C00155000/view/view_8 https://finance.yahoo.com/quotes/IBM,IBM170519C00155000/view/view_8
it returns the HTML page.
Thanks
Charles
Fri May 5, 2017 11:10 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The field names would vary for your "view 8", but it might look something
like:
https://query1.finance.yahoo.com/v7/finance/quote?formatted=false&fields=symbol,shortName,regularMarketPrice,regularMarketTime,regularMarketChange,regularMarketDayHigh,regularMarketDayLow,regularMarketVolume,bid,ask,dividendYield,dividendsPerShare,exDividendDate&symbols=IBM,IBM170519C00155000
Using that as your URL, you could extract the two security prices with:
=smfJSONExtractField(RCHGetWebData($D$7),
"quoteResponse.result.0.regularMarketPrice")
=smfJSONExtractField(RCHGetWebData($D$7),
"quoteResponse.result.1.regularMarketPrice")
If you have the new FIreFox, it has an option to enumerate all of the
fields and their values. But you need to use a fully qualified name (i.e.
all levels) for the extraction. That function only has the two parameters
-- JSON data and fully qualified field name.
On Fri, May 5, 2017 at 10:30 PM, cyy001@ wrote:
>
> What is the yahoo query that returns the JSON data for the portfolio view?
>
> If I use
> https://finance.yahoo.com/quotes/IBM,IBM170519C00155000/view/view_8
>
> it returns the HTML page.
>
>
>
like:
https://query1.finance.yahoo.com/v7/finance/quote?formatted=false&fields=symbol,shortName,regularMarketPrice,regularMarketTime,regularMarketChange,regularMarketDayHigh,regularMarketDayLow,regularMarketVolume,bid,ask,dividendYield,dividendsPerShare,exDividendDate&symbols=IBM,IBM170519C00155000
Using that as your URL, you could extract the two security prices with:
=smfJSONExtractField(RCHGetWebData($D$7),
"quoteResponse.result.0.regularMarketPrice")
=smfJSONExtractField(RCHGetWebData($D$7),
"quoteResponse.result.1.regularMarketPrice")
If you have the new FIreFox, it has an option to enumerate all of the
fields and their values. But you need to use a fully qualified name (i.e.
all levels) for the extraction. That function only has the two parameters
-- JSON data and fully qualified field name.
On Fri, May 5, 2017 at 10:30 PM, cyy001@ wrote:
>
> What is the yahoo query that returns the JSON data for the portfolio view?
>
> If I use
> https://finance.yahoo.com/quotes/IBM,IBM170519C00155000/view/view_8
>
> it returns the HTML page.
>
>
>
Sat May 6, 2017 12:00 am (PDT) . Posted by:
alberto.ratti
RCHGetYahooQuotes("TEF.MC","l1") returns "N/A".
How to grab the PRICE from:
https://finance.yahoo.com/quote/tef.mc https://finance.yahoo.com/quote/tef.mc
?
(thanks a lot)
How to grab the PRICE from:
https://finance.yahoo.com/quote/tef.mc https://finance.yahoo.com/quote/tef.mc
?
(thanks a lot)
Sat May 6, 2017 12:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
This works right now, but I'm not sure how reliable it will be:
=smfGetTagContent("https://finance.yahoo.com/quote/TEF.MC","span",3,"Currency
in",,,,1)
The code on Yahoo web pages is so convoluted these days, it's difficult to
come up with reliable extraction code.
On Sat, May 6, 2017 at 12:00 AM, alberto.ratti@
...wrote:
> RCHGetYahooQuotes("TEF.MC","l1") returns "N/A".
>
> How to grab the PRICE from:
>
> https://finance.yahoo.com/quote/tef.mc
>
> ?
>
>
=smfGetTagContent("https://finance.yahoo.com/quote/TEF.MC","span",3,"Currency
in",,,,1)
The code on Yahoo web pages is so convoluted these days, it's difficult to
come up with reliable extraction code.
On Sat, May 6, 2017 at 12:00 AM, alberto.ratti@
...wrote:
> RCHGetYahooQuotes("TEF.MC","l1") returns "N/A".
>
> How to grab the PRICE from:
>
> https://finance.yahoo.com/quote/tef.mc
>
> ?
>
>
Sat May 6, 2017 2:19 am (PDT) . Posted by:
alberto.ratti
I tried to relate your solution with the scanning of the web source page, unsuccessfully.
Might you explain the deployment of the strings?
A lot of thanks.
A.R.
Might you explain the deployment of the strings?
A lot of thanks.
A.R.
Sat May 6, 2017 9:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Basically, I looked at the source code of the web page and manually
searched for the current price, and then looked for something prior to it
that I could use as a search string.
I then used the SMF-Quick-Webpage-Examination.xls and plugged in the
relevant information to the "By HTML Tag" worksheet:
Web Page: "https://finance.yahoo.com/quote/tef.mc"
HTML Tag: "span"
Start String: "Currency in"
On Sat, May 6, 2017 at 2:19 AM, alberto.ratti@
...wrote:
>
> I tried to relate your solution with the scanning of the web source page,
> unsuccessfully.
> Might you explain the deployment of the strings?
> A lot of thanks.
> A.R.
>
searched for the current price, and then looked for something prior to it
that I could use as a search string.
I then used the SMF-Quick-Webpage-Examination.xls and plugged in the
relevant information to the "By HTML Tag" worksheet:
Web Page: "https://finance.yahoo.com/quote/tef.mc"
HTML Tag: "span"
Start String: "Currency in"
On Sat, May 6, 2017 at 2:19 AM, alberto.ratti@
...wrote:
>
> I tried to relate your solution with the scanning of the web source page,
> unsuccessfully.
> Might you explain the deployment of the strings?
> A lot of thanks.
> A.R.
>
Sat May 6, 2017 3:30 am (PDT) . Posted by:
gareneau
Hi Randy,
First time post - I'm using a customized Excel spreadsheet to track DeMark signals that integrates the smf add in. Two things: Yahoo provides commodity quotes, but when I enter those in my spreadsheet I get an error message. Why, if I can get a price quote in Yahoo Finance, does it not carry over into the smf add in function?
Also, I would like the spreadsheet to take a whole list of tickers and run the DeMark analytics against each every day (as opposed to my inputting each ticker symbol). What would also be great is to program the sheet to alert me when pertinent DeMark exhaustion points are reached, but that may not be possible.
Any ideas?
Thanks -
First time post - I'm using a customized Excel spreadsheet to track DeMark signals that integrates the smf add in. Two things: Yahoo provides commodity quotes, but when I enter those in my spreadsheet I get an error message. Why, if I can get a price quote in Yahoo Finance, does it not carry over into the smf add in function?
Also, I would like the spreadsheet to take a whole list of tickers and run the DeMark analytics against each every day (as opposed to my inputting each ticker symbol). What would also be great is to program the sheet to alert me when pertinent DeMark exhaustion points are reached, but that may not be possible.
Any ideas?
Thanks -
Sat May 6, 2017 9:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'd need more details on the actual functions you're using. I don't do
anything with commodities. It looks to me like these work:
=RCHGetYahooQuotes("GC=F","l1")
=RCHGetYahooQuotes("GCZ22.CMX","l1")
On Sat, May 6, 2017 at 3:30 AM, gareneau@
...wrote:
>
> First time post - I'm using a customized Excel spreadsheet to track DeMark
> signals that integrates the smf add in. Two things: Yahoo provides
> commodity quotes, but when I enter those in my spreadsheet I get an error
> message. Why, if I can get a price quote in Yahoo Finance, does it not
> carry over into the smf add in function?
>
> Also, I would like the spreadsheet to take a whole list of tickers and run
> the DeMark analytics against each every day (as opposed to my inputting
> each ticker symbol). What would also be great is to program the sheet to
> alert me when pertinent DeMark exhaustion points are reached, but that may
> not be possible.
>
> Any ideas?
>
> Thanks -
>
>
>
>
anything with commodities. It looks to me like these work:
=RCHGetYahooQuotes(
=RCHGetYahooQuotes(
On Sat, May 6, 2017 at 3:30 AM, gareneau@
...wrote:
>
> First time post - I'm using a customized Excel spreadsheet to track DeMark
> signals that integrates the smf add in. Two things: Yahoo provides
> commodity quotes, but when I enter those in my spreadsheet I get an error
> message. Why, if I can get a price quote in Yahoo Finance, does it not
> carry over into the smf add in function?
>
> Also, I would like the spreadsheet to take a whole list of tickers and run
> the DeMark analytics against each every day (as opposed to my inputting
> each ticker symbol). What would also be great is to program the sheet to
> alert me when pertinent DeMark exhaustion points are reached, but that may
> not be possible.
>
> Any ideas?
>
> Thanks -
>
>
>
>
Sat May 6, 2017 1:15 pm (PDT) . Posted by:
mff2805
Hi,
i've used the addin for years, getting data from IBD. i'm used to regularly having to re-login via the web query, but today am getting nowhere. the ibd login screen just freezes. i seem to recall a link that would get directly to the login screen, but cannot find it. any ideas?
thanks much,
Mike
i've used the addin for years, getting data from IBD. i'm used to regularly having to re-login via the web query, but today am getting nowhere. the ibd login screen just freezes. i seem to recall a link that would get directly to the login screen, but cannot find it. any ideas?
thanks much,
Mike
Sat May 6, 2017 4:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Wow. I hadn't tried it yet with Office365 on my new computer. What a chore.
The old link no longer works:
https://www.investors.com/Services/SiteAjaxService.asmx/MemberSingIn?strEmail=xxxxx&strPassword=yyyyy&blnRemember=true
Logging in with IE didn't help at all. But I did manage to get logged in
using the EXCEL Web Query object (alt+d+d+w). Here's what I did:
1. Navigated to the login page:
https://myibd.investors.com/secure/signin.aspx
2. I hit ESC every time a dialog box came up.
3. When it's done, I needed to hit the STOP icon (the one with a red "x" on
it) several times before I could enter email address and password.
4. Click on the "Sign in" button.
They're back to allowing only a single browser access. So if you go and log
in with IE or Chrome or FireFox, it will log you out of the EXCEL session.
Or, when you get to the screen that freezes, just trying hitting that STOP
icon several times before continuing.
On Sat, May 6, 2017 at 1:15 PM, mff3429@
...wrote:
>
> i've used the addin for years, getting data from IBD. i'm used to
> regularly having to re-login via the web query, but today am getting
> nowhere. the ibd login screen just freezes. i seem to recall a link that
> would get directly to the login screen, but cannot find it. any ideas?
>
The old link no longer works:
https://www.investors.com/Services/SiteAjaxService.asmx/MemberSingIn?strEmail=xxxxx&strPassword=yyyyy&blnRemember=true
Logging in with IE didn't help at all. But I did manage to get logged in
using the EXCEL Web Query object (alt+d+d+w). Here's what I did:
1. Navigated to the login page:
https://myibd.investors.com/secure/signin.aspx
2. I hit ESC every time a dialog box came up.
3. When it's done, I needed to hit the STOP icon (the one with a red "x" on
it) several times before I could enter email address and password.
4. Click on the "Sign in" button.
They're back to allowing only a single browser access. So if you go and log
in with IE or Chrome or FireFox, it will log you out of the EXCEL session.
Or, when you get to the screen that freezes, just trying hitting that STOP
icon several times before continuing.
On Sat, May 6, 2017 at 1:15 PM, mff3429@
...wrote:
>
> i've used the addin for years, getting data from IBD. i'm used to
> regularly having to re-login via the web query, but today am getting
> nowhere. the ibd login screen just freezes. i seem to recall a link that
> would get directly to the login screen, but cannot find it. any ideas?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar