7 Messages
Digest #4073
Messages
Tue Jun 27, 2017 9:12 pm (PDT) . Posted by:
bleushin19
Hi Randy,
Thank you so much for the experience and learnings I have from your works and examples. I am very very thankful for it.
I have one question though,if there is a way to get data on Yahoo Finance for the Upgrades and Downgrades? It was working before the update and I can't seem to find the right link/source on where to get it.
I used this link before as an example https://finance.yahoo.com/q/ao?s=cara and run a query on the tables 12 & 13.
Example output:
Date Research Firm Action From To
3-Feb-17 JP Morgan Downgrade Overweight Neutral
Right now, it doesn't show any data.
are there any other sites like google finance or msn to provide such data?
I hope you could walk me through on these parts as well.
Thanks,
Archie
Thank you so much for the experience and learnings I have from your works and examples. I am very very thankful for it.
I have one question though,if there is a way to get data on Yahoo Finance for the Upgrades and Downgrades? It was working before the update and I can't seem to find the right link/source on where to get it.
I used this link before as an example https://finance.yahoo.com/q/ao?s=cara and run a query on the tables 12 & 13.
Example output:
Date Research Firm Action From To
3-Feb-17 JP Morgan Downgrade Overweight Neutral
Right now, it doesn't show any data.
are there any other sites like google finance or msn to provide such data?
I hope you could walk me through on these parts as well.
Thanks,
Archie
Wed Jun 28, 2017 3:19 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Another set of data moved to a JSON module.
See: https://groups.yahoo.com/neo/groups/smf_addin/
conversations/messages/32589
For example, the first upgrade/downgrade entry would be something like:
Ticker Module Fully qualified field name Value Formula
CARA upgradeDowngradeHistory
quoteSummary.result.0.upgradeDowngradeHistory.history.0.epochGradeDate
2016-10-13 =smfUnix2Date(smfGetYahooJSONField(C7,D7,E7))
CARA upgradeDowngradeHistory
quoteSummary.result.0.upgradeDowngradeHistory.history.0.action init
=smfGetYahooJSONField(C8,D8,E8)
CARA upgradeDowngradeHistory
quoteSummary.result.0.upgradeDowngradeHistory.history.0.firm H.C. Wainwright
=smfGetYahooJSONField(C9,D9,E9)
CARA upgradeDowngradeHistory
quoteSummary.result.0.upgradeDowngradeHistory.history.0.fromGrade Not Found
=smfGetYahooJSONField(C10,D10,E10)
CARA upgradeDowngradeHistory
quoteSummary.result.0.upgradeDowngradeHistory.history.0.toGrade Buy
=smfGetYahooJSONField(C11,D11,E11)
On Tue, Jun 27, 2017 at 9:12 PM, bleushin19@
...
wrote:
> Thank you so much for the experience and learnings I have from your works
> and examples. I am very very thankful for it.
>
> I have one question though,if there is a way to get data on Yahoo Finance
> for the Upgrades and Downgrades? It was working before the update and I
> can't seem to find the right link/source on where to get it.
>
> I used this link before as an example https://finance.yahoo.com/q/ao
> ?s=cara and run a query on the tables 12 & 13.
>
> Example output:
>
> Date Research Firm Action From To
>
> 3-Feb-17 JP Morgan Downgrade Overweight Neutral
>
> Right now, it doesn't show any data.
>
> are there any other sites like google finance or msn to provide such data?
>
> I hope you could walk me through on these parts as well.
>
>
>
See: https://groups.yahoo.com/neo/groups/smf_addin/
conversations/messages/32589
For example, the first upgrade/downgrade entry would be something like:
Ticker Module Fully qualified field name Value Formula
CARA upgradeDowngradeHistory
quoteSummary.result.0.upgradeDowngradeHistory.history.0.epochGradeDate
2016-10-13 =smfUnix2Date(smfGetYahooJSONField(C7,D7,E7))
CARA upgradeDowngradeHistory
quoteSummary.result.0.upgradeDowngradeHistory.history.0.action init
=smfGetYahooJSONField(C8,D8,E8)
CARA upgradeDowngradeHistory
quoteSummary.result.0.upgradeDowngradeHistory.history.0.firm H.C. Wainwright
=smfGetYahooJSONField(C9,D9,E9)
CARA upgradeDowngradeHistory
quoteSummary.result.0.upgradeDowngradeHistory.history.0.fromGrade Not Found
=smfGetYahooJSONField(C10,D10,E10)
CARA upgradeDowngradeHistory
quoteSummary.result.0.upgradeDowngradeHistory.history.0.toGrade Buy
=smfGetYahooJSONField(C11,D11,E11)
On Tue, Jun 27, 2017 at 9:12 PM, bleushin19@
...
wrote:
> Thank you so much for the experience and learnings I have from your works
> and examples. I am very very thankful for it.
>
> I have one question though,if there is a way to get data on Yahoo Finance
> for the Upgrades and Downgrades? It was working before the update and I
> can't seem to find the right link/source on where to get it.
>
> I used this link before as an example https://finance.yahoo.com/q/ao
> ?s=cara and run a query on the tables 12 & 13.
>
> Example output:
>
> Date Research Firm Action From To
>
> 3-Feb-17 JP Morgan Downgrade Overweight Neutral
>
> Right now, it doesn't show any data.
>
> are there any other sites like google finance or msn to provide such data?
>
> I hope you could walk me through on these parts as well.
>
>
>
Wed Jun 28, 2017 6:41 pm (PDT) . Posted by:
"Archie Roa" bleushin19
Thank you so much Randy. It's such a big help.
On Wednesday, June 28, 2017 6:19 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Another set of data moved to a JSON module.
See: https://groups.yahoo.com/ neo/groups/smf_addin/ conversations/messages/32589
For example, the first upgrade/downgrade entry would be something like:
| Ticker | Module | Fully qualified field name | Value | Formula |
| CARA | upgradeDowngradeHistory | quoteSummary.result.0.upgradeDowngradeHistory.history.0.epochGradeDate | 2016-10-13 | =smfUnix2Date(smfGetYahooJSONField(C7,D7,E7)) |
| CARA | upgradeDowngradeHistory | quoteSummary.result.0.upgradeDowngradeHistory.history.0.action | init | =smfGetYahooJSONField(C8,D8,E8) |
| CARA | upgradeDowngradeHistory | quoteSummary.result.0.upgradeDowngradeHistory.history.0.firm | H.C. Wainwright | =smfGetYahooJSONField(C9,D9,E9) |
| CARA | upgradeDowngradeHistory | quoteSummary.result.0.upgradeDowngradeHistory.history.0.fromGrade | Not Found | =smfGetYahooJSONField(C10,D10,E10) |
| CARA | upgradeDowngradeHistory | quoteSummary.result.0.upgradeDowngradeHistory.history.0.toGrade | Buy | =smfGetYahooJSONField(C11,D11,E11) |
On Tue, Jun 27, 2017 at 9:12 PM, bleushin19@...wrote:
Thank you so much for the experience and learnings I have from your works and examples. I am very very thankful for it.
I have one question though,if there is a way to get data on Yahoo Finance for the Upgrades and Downgrades? It was working before the update and I can't seem to find the right link/source on where to get it.
I used this link before as an example https://finance.yahoo.com/q/ao ?s=cara and run a query on the tables 12 & 13.
Example output:
Date Research Firm Action FromTo3-Feb-17 JP Morgan Downgrade Overweight Ne utralRight now, it doesn't show any data.
are there any other sites like google finance or msn to provide such data?
I hope you could walk me through on these parts as well.
#yiv0376630295 #yiv0376630295 -- #yiv0376630295ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0376630295 #yiv0376630295ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0376630295 #yiv0376630295ygrp-mkp #yiv0376630295hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0376630295 #yiv0376630295ygrp-mkp #yiv0376630295ads {margin-bottom:10px;}#yiv0376630295 #yiv0376630295ygrp-mkp .yiv0376630295ad {padding:0 0;}#yiv0376630295 #yiv0376630295ygrp-mkp .yiv0376630295ad p {margin:0;}#yiv0376630295 #yiv0376630295ygrp-mkp .yiv0376630295ad a {color:#0000ff;text-decoration:none;}#yiv0376630295 #yiv0376630295ygrp-sponsor #yiv0376630295ygrp-lc {font-family:Arial;}#yiv0376630295 #yiv0376630295ygrp-sponsor #yiv0376630295ygrp-lc #yiv0376630295hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0376630295 #yiv0376630295ygrp-sponsor #yiv0376630295ygrp-lc .yiv0376630295ad {margin-bottom:10px;padding:0 0;}#yiv0376630295 #yiv0376630295actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0376630295 #yiv0376630295activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0376630295 #yiv0376630295activity span {font-weight:700;}#yiv0376630295 #yiv0376630295activity span:first-child {text-transform:uppercase;}#yiv0376630295 #yiv0376630295activity span a {color:#5085b6;text-decoration:none;}#yiv0376630295 #yiv0376630295activity span span {color:#ff7900;}#yiv0376630295 #yiv0376630295activity span .yiv0376630295underline {text-decoration:underline;}#yiv0376630295 .yiv0376630295attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0376630295 .yiv0376630295attach div a {text-decoration:none;}#yiv0376630295 .yiv0376630295attach img {border:none;padding-right:5px;}#yiv0376630295 .yiv0376630295attach label {display:block;margin-bottom:5px;}#yiv0376630295 .yiv0376630295attach label a {text-decoration:none;}#yiv0376630295 blockquote {margin:0 0 0 4px;}#yiv0376630295 .yiv0376630295bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0376630295 .yiv0376630295bold a {text-decoration:none;}#yiv0376630295 dd.yiv0376630295last p a {font-family:Verdana;font-weight:700;}#yiv0376630295 dd.yiv0376630295last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0376630295 dd.yiv0376630295last p span.yiv0376630295yshortcuts {margin-right:0;}#yiv0376630295 div.yiv0376630295attach-table div div a {text-decoration:none;}#yiv0376630295 div.yiv0376630295attach-table {width:400px;}#yiv0376630295 div.yiv0376630295file-title a, #yiv0376630295 div.yiv0376630295file-title a:active, #yiv0376630295 div.yiv0376630295file-title a:hover, #yiv0376630295 div.yiv0376630295file-title a:visited {text-decoration:none;}#yiv0376630295 div.yiv0376630295photo-title a, #yiv0376630295 div.yiv0376630295photo-title a:active, #yiv0376630295 div.yiv0376630295photo-title a:hover, #yiv0376630295 div.yiv0376630295photo-title a:visited {text-decoration:none;}#yiv0376630295 div#yiv0376630295ygrp-mlmsg #yiv0376630295ygrp-msg p a span.yiv0376630295yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0376630295 .yiv0376630295green {color:#628c2a;}#yiv0376630295 .yiv0376630295MsoNormal {margin:0 0 0 0;}#yiv0376630295 o {font-size:0;}#yiv0376630295 #yiv0376630295photos div {float:left;width:72px;}#yiv0376630295 #yiv0376630295photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0376630295 #yiv0376630295photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0376630295 #yiv0376630295reco-category {font-size:77%;}#yiv0376630295 #yiv0376630295reco-desc {font-size:77%;}#yiv0376630295 .yiv0376630295replbq {margin:4px;}#yiv0376630295 #yiv0376630295ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0376630295 #yiv0376630295ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0376630295 #yiv0376630295ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0376630295 #yiv0376630295ygrp-mlmsg select, #yiv0376630295 input, #yiv0376630295 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0376630295 #yiv0376630295ygrp-mlmsg pre, #yiv0376630295 code {font:115% monospace;}#yiv0376630295 #yiv0376630295ygrp-mlmsg * {line-height:1.22em;}#yiv0376630295 #yiv0376630295ygrp-mlmsg #yiv0376630295logo {padding-bottom:10px;}#yiv0376630295 #yiv0376630295ygrp-msg p a {font-family:Verdana;}#yiv0376630295 #yiv0376630295ygrp-msg p#yiv0376630295attach-count span {color:#1E66AE;font-weight:700;}#yiv0376630295 #yiv0376630295ygrp-reco #yiv0376630295reco-head {color:#ff7900;font-weight:700;}#yiv0376630295 #yiv0376630295ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0376630295 #yiv0376630295ygrp-sponsor #yiv0376630295ov li a {font-size:130%;text-decoration:none;}#yiv0376630295 #yiv0376630295ygrp-sponsor #yiv0376630295ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0376630295 #yiv0376630295ygrp-sponsor #yiv0376630295ov ul {margin:0;padding:0 0 0 8px;}#yiv0376630295 #yiv0376630295ygrp-text {font-family:Georgia;}#yiv0376630295 #yiv0376630295ygrp-text p {margin:0 0 1em 0;}#yiv0376630295 #yiv0376630295ygrp-text tt {font-size:120%;}#yiv0376630295 #yiv0376630295ygrp-vital ul li:last-child {border-right:none !important;}#yiv0376630295
On Wednesday, June 28, 2017 6:19 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Another set of data moved to a JSON module.
See: https://groups.yahoo.com/ neo/groups/smf_addin/ conversations/messages/32589
For example, the first upgrade/downgrade entry would be something like:
| Ticker | Module | Fully qualified field name | Value | Formula |
| CARA | upgradeDowngradeHistory | quoteSummary.result.0.upgradeDowngradeHistory.history.0.epochGradeDate | 2016-10-13 | =smfUnix2Date(smfGetYahooJSONField(C7,D7,E7)) |
| CARA | upgradeDowngradeHistory | quoteSummary.result.0.upgradeDowngradeHistory.history.0.action | init | =smfGetYahooJSONField(C8,D8,E8) |
| CARA | upgradeDowngradeHistory | quoteSummary.result.0.upgradeDowngradeHistory.history.0.firm | H.C. Wainwright | =smfGetYahooJSONField(C9,D9,E9) |
| CARA | upgradeDowngradeHistory | quoteSummary.result.0.upgradeDowngradeHistory.history.0.fromGrade | Not Found | =smfGetYahooJSONField(C10,D10,E10) |
| CARA | upgradeDowngradeHistory | quoteSummary.result.0.upgradeDowngradeHistory.history.0.toGrade | Buy | =smfGetYahooJSONField(C11,D11,E11) |
On Tue, Jun 27, 2017 at 9:12 PM, bleushin19@...wrote:
Thank you so much for the experience and learnings I have from your works and examples. I am very very thankful for it.
I have one question though,if there is a way to get data on Yahoo Finance for the Upgrades and Downgrades? It was working before the update and I can't seem to find the right link/source on where to get it.
I used this link before as an example https://finance.yahoo.com/q/ao ?s=cara and run a query on the tables 12 & 13.
Example output:
Date Research Firm Action From
are there any other sites like google finance or msn to provide such data?
I hope you could walk me through on these parts as well.
#yiv0376630295 #yiv0376630295 -- #yiv0376630295ygrp-
Wed Jun 28, 2017 11:31 am (PDT) . Posted by:
g3m1n1980
I've searched the conversations I couldnt locate a fix for Yahoo option data.
Can someone advise if there is a fix to this old way of extracting option data?
=RCHGetTableCell("http://finance.yahoo.com/q/op?s="&$A3&"&k="&$B3,8,">Expires";,,,,1)
It used to pull OI volume for a specific strike reference but now its just an error
Jason
Can someone advise if there is a fix to this old way of extracting option data?
=RCHGetTableCell("http://finance.yahoo.com/q/op?s="&$A3&"
It used to pull OI volume for a specific strike reference but now its just an error
Jason
Wed Jun 28, 2017 12:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Why not just use the smfGetOptionQuotes() function? For example, something
like:
=smfGetOptionQuotes("MMM 6/30 2017 $200 Call","b",,"Y")
That actually parses that first string and does this call:
=smfGetYahooOptionQuote("MMM","Call","6/30/2017",200,"b")
There are also some other option functions I use regularly (array-entered
down a column), to get option expirations and option strikes, and they can
generate the ticker symbols for smfGetOptionQuotes(). Some examples:
=smfGetOptionExpirations("MMM")
=smfGetOptionExpirations("MMM","Y","Call",200)
=smfGetOptionStrikes("MMM","6/30/2017",,"Y")
=smfGetOptionStrikes("MMM","6/30/2017","Call","Y",1)
On Wed, Jun 28, 2017 at 11:31 AM, xxjaysonxx@
...
wrote:
> I've searched the conversations I couldnt locate a fix for Yahoo option
> data.
>
> Can someone advise if there is a fix to this old way of extracting option
> data?
>
> =RCHGetTableCell("http://finance.yahoo.com/q/op?s="&$
> A3&"&k="&$B3,8,">Expires",,,,1)
>
> It used to pull OI volume for a specific strike reference but now its just
> an error
>
>
>
like:
=smfGetOptionQuotes("MMM 6/30 2017 $200 Call","b",,"Y")
That actually parses that first string and does this call:
=smfGetYahooOptionQuote("MMM","Call","6/30/2017",200,"b")
There are also some other option functions I use regularly (array-entered
down a column), to get option expirations and option strikes, and they can
generate the ticker symbols for smfGetOptionQuotes(). Some examples:
=smfGetOptionExpirations("MMM")
=smfGetOptionExpirations("MMM","Y","Call",200)
=smfGetOptionStrikes("MMM","6/30/2017",,"Y")
=smfGetOptionStrikes("MMM","6/30/2017","Call","Y",1)
On Wed, Jun 28, 2017 at 11:31 AM, xxjaysonxx@
...
wrote:
> I've searched the conversations I couldnt locate a fix for Yahoo option
> data.
>
> Can someone advise if there is a fix to this old way of extracting option
> data?
>
> =RCHGetTableCell("http://finance.yahoo.com/q/op?s="&$
> A3&"&k=
>
> It used to pull OI volume for a specific strike reference but now its just
> an error
>
>
>
Wed Jun 28, 2017 11:46 am (PDT) . Posted by:
g3m1n1980
Can someone provide advice to pull the high med and low share price forecast from this site?
https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM:NSQ https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM:NSQ
Ive toyed with a few layouts and I only get errors
=RCHGetTableCell("https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM:NSQ"",1,">high,,,,-1,"</table",,"--")
https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM:NSQ https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM:NSQ
Ive toyed with a few layouts and I only get errors
=RCHGetTableCell("https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM:NSQ""
Wed Jun 28, 2017 12:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You were close. But the one you posted has mismatched quotes. Try something
like:
=RCHGetTableCell("
https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM:NSQ
",2,">high",,,,,"</table",,"--")
What I would go with:
=RCHGetTableCell("
https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM",2,">Share
price forecast",">High")
=RCHGetTableCell("
https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM",2,">Share
price forecast",">Med")
=RCHGetTableCell("
https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM",2,">Share
price forecast",">Low")
...because ">Med" was not a unique string. It appears earlier on the web
page as ">Media".
On Wed, Jun 28, 2017 at 11:46 AM, xxjaysonxx@
...
wrote:
> Can someone provide advice to pull the high med and low share price
> forecast from this site?
>
> https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM:NSQ
>
> Ive toyed with a few layouts and I only get errors
>
> =RCHGetTableCell("https://markets.ft.com/data/equities/
> tearsheet/forecasts?s=QCOM:NSQ";",1,">high,,,,-1,"</table",,"--")
>
>
>
like:
=RCHGetTableCell("
https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM:NSQ
",2,">high",,,,,"</table",,"--")
What I would go with:
=RCHGetTableCell("
https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM",2,">Share
price forecast",">High")
=RCHGetTableCell("
https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM",2,">Share
price forecast",">Med")
=RCHGetTableCell("
https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM",2,">Share
price forecast",">Low")
...because ">Med" was not a unique string. It appears earlier on the web
page as ">Media".
On Wed, Jun 28, 2017 at 11:46 AM, xxjaysonxx@
...
wrote:
> Can someone provide advice to pull the high med and low share price
> forecast from this site?
>
> https://markets.ft.com/data/equities/tearsheet/forecasts?s=QCOM:NSQ
>
> Ive toyed with a few layouts and I only get errors
>
> =RCHGetTableCell("https://markets.ft.com/data/equities/
> tearsheet/forecasts
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar