1 Message
Digest #3916
Message
Thu Feb 9, 2017 6:14 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. This pulls in a P&F chart for me:
=RCHCreateComment("MMM",2)
Or, for a customized version, use the image URL, such as:
=RCHCreateComment("
http://stockcharts.com/def/servlet/SharpChartv05.ServletDriver?c=MMM,PWPADANRNO[PA][D][F1!3!1.0!!2!20]&r=4551&pnf=y
",99)
For a Y/N dividend on COMPANIES, you could try:
=IF(ISERR(RCHGetElementNumber(E6,4925)/1),"N","Y")
These days, I get all my option info from Barchart. For their implied
volatility:
=smfGetOptionQuotes("MMM 2/10 2017 $175 Call","6",,"b")
On Thu, Feb 9, 2017 at 4:22 PM, lutherkinchen@
...wrote:
>
> Men, you have opened my eyes to something I never even considered; WOW,
> pulling charts into excel.
> Thank you, Thank you, Thank you. That is a blessing.
>
> OK, I am now pulling in regular charts, but unable to pull in Point and
> Figure charts.
>
> I have a stockchart account, but those P&F will not come into excel? Is
> there something unique about P&F that prevents them from pulling into excel?
>
> While I'm here, I've got a couple other questions you may can help with:
> 1) Does a company pays dividends? "Yes" or "No" is there a standalone
> formula for Y/N answer only?
> 2) Do you have a favorite way/formula/site for pulling in Implied
> volatility information? When we already know the Date and Strike we need
> to IV number for? That would be helpful.
>
>
>
=RCHCreateComment("MMM",2)
Or, for a customized version, use the image URL, such as:
=RCHCreateComment("
http://stockcharts.com/def/servlet/SharpChartv05.ServletDriver?c=MMM,PWPADANRNO[PA][D][F1!3!
",99)
For a Y/N dividend on COMPANIES, you could try:
=IF(ISERR(RCHGetEle
These days, I get all my option info from Barchart. For their implied
volatility:
=smfGetOptionQuotes
On Thu, Feb 9, 2017 at 4:22 PM, lutherkinchen@
...wrote:
>
> Men, you have opened my eyes to something I never even considered; WOW,
> pulling charts into excel.
> Thank you, Thank you, Thank you. That is a blessing.
>
> OK, I am now pulling in regular charts, but unable to pull in Point and
> Figure charts.
>
> I have a stockchart account, but those P&F will not come into excel? Is
> there something unique about P&F that prevents them from pulling into excel?
>
> While I'm here, I've got a couple other questions you may can help with:
> 1) Does a company pays dividends? "Yes" or "No" is there a standalone
> formula for Y/N answer only?
> 2) Do you have a favorite way/formula/
> volatility information? When we already know the Date and Strike we need
> to IV number for? That would be helpful.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar