Selasa, 14 November 2017

[smf_addin] Digest Number 4237

9 Messages

Digest #4237
1.2
Re: Help with smfGetYahooPortfolioView by "Randy Harmelink" rharmelink
2a
2b
Re: Stockscores errors by "Randy Harmelink" rharmelink
2c
3a
Re: Problem With "Prices Between" by gfoster07k@sbcglobal.net
3b
Re: Problem With "Prices Between" by "Randy Harmelink" rharmelink
4a
Re: number codes by chinathunder
5.1
Re: Option Quotes by "Ron Spruell" hashky

Messages

Tue Nov 14, 2017 8:31 am (PST) . Posted by:

lexstar

I get the following for those 3 functions:

Stock Market Functions add-in, Version 2.1.2017.11.02 (C:\Program Files\SMF Add-In; Windows (64-bit) NT 10.00; 16.0; ; ; 1)

229.78


regularMarketPrice":229.78,"regularMarketTime":1510676928,"symbol":"MMM"}],"error":null}}




Tue Nov 14, 2017 8:33 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You should install the latest version. It addresses the issues you
mentioned.

On Tue, Nov 14, 2017 at 9:31 AM, lexstar@
​...
wrote:

>
> I get the following for those 3 functions:
>
> Stock Market Functions add-in, Version 2.1.2017.11.02 (C:\Program
> Files\SMF Add-In; Windows (64-bit) NT 10.00; 16.0; ; ; 1)
>
>
> 229.78
>
> regularMarketPrice":229.78,"regularMarketTime":1510676928,
> "symbol":"MMM"}],"error":null}}
>

Tue Nov 14, 2017 8:31 am (PST) . Posted by:

antoine61

Hello,


I'm getting an error response when trying to retrieve information from from Stockscores through the RCHGetElementNumber() function. Elements 824 and 826 (Signal, Sentiment). Am I the only one?


Thanks

Tue Nov 14, 2017 8:56 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. All of the StockScores elements needed to be
updated. See:

https://smf-add-in.blogspot.com/2017/11/alert-all-stockscorescom-element.html

On Tue, Nov 14, 2017 at 9:28 AM, antoine@
​...
wrote:

> I'm getting an error response when trying to retrieve information from
> from Stockscores through the RCHGetElementNumber() function. Elements 824
> and 826 (Signal, Sentiment). Am I the only one?
>
>
>

Tue Nov 14, 2017 9:02 am (PST) . Posted by:

antoine61

Thanks Randy, amazing work!

Tue Nov 14, 2017 8:46 am (PST) . Posted by:

gfoster07k@sbcglobal.net

I have included a picture of part of the spreadsheet. The formula in I13/14 is: =smfPricesBetween(B3,I$2,C$1,"1008")


As you can see, the add-in returns zeros in some cells. There are several more in various cells in the spreadsheet.


I hope this helps.
Greg Foster

Tue Nov 14, 2017 9:01 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You're not the only one seeing some days with zero values for historical
data. See:

https://yahoo.uservoice.com/forums/382977-finance/suggestions/32245879-historical-price-issues

On Tue, Nov 14, 2017 at 9:46 AM, gfoster07k@
​...
wrote:

>
> I have included a picture of part of the spreadsheet. The formula in
> I13/14 is:
> =smfPricesBetween(B3,I$2,C$1,"1008")
>
> As you can see, the add-in returns zeros in some cells. There are several
> more in various cells in the spreadsheet.
>
> I hope this helps.
>
>

Tue Nov 14, 2017 10:54 am (PST) . Posted by:

"Ron Spruell" hashky

Here is a file I use for Calls and Puts.  It still does most of what I need.

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, November 14, 2017 9:32 AM
Subject: Re: [smf_addin] Option Quotes

  I use smfGetYahooPortfolioView(), using Yahoo option ticker symbols.
On Tue, Nov 14, 2017 at 8:25 AM, codyklein@​... wrote:

Looking for a formula to grab option prices. Any help would be appreciated.

#yiv2256631841 #yiv2256631841 -- #yiv2256631841ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2256631841 #yiv2256631841ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2256631841 #yiv2256631841ygrp-mkp #yiv2256631841hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2256631841 #yiv2256631841ygrp-mkp #yiv2256631841ads {margin-bottom:10px;}#yiv2256631841 #yiv2256631841ygrp-mkp .yiv2256631841ad {padding:0 0;}#yiv2256631841 #yiv2256631841ygrp-mkp .yiv2256631841ad p {margin:0;}#yiv2256631841 #yiv2256631841ygrp-mkp .yiv2256631841ad a {color:#0000ff;text-decoration:none;}#yiv2256631841 #yiv2256631841ygrp-sponsor #yiv2256631841ygrp-lc {font-family:Arial;}#yiv2256631841 #yiv2256631841ygrp-sponsor #yiv2256631841ygrp-lc #yiv2256631841hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2256631841 #yiv2256631841ygrp-sponsor #yiv2256631841ygrp-lc .yiv2256631841ad {margin-bottom:10px;padding:0 0;}#yiv2256631841 #yiv2256631841actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2256631841 #yiv2256631841activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2256631841 #yiv2256631841activity span {font-weight:700;}#yiv2256631841 #yiv2256631841activity span:first-child {text-transform:uppercase;}#yiv2256631841 #yiv2256631841activity span a {color:#5085b6;text-decoration:none;}#yiv2256631841 #yiv2256631841activity span span {color:#ff7900;}#yiv2256631841 #yiv2256631841activity span .yiv2256631841underline {text-decoration:underline;}#yiv2256631841 .yiv2256631841attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2256631841 .yiv2256631841attach div a {text-decoration:none;}#yiv2256631841 .yiv2256631841attach img {border:none;padding-right:5px;}#yiv2256631841 .yiv2256631841attach label {display:block;margin-bottom:5px;}#yiv2256631841 .yiv2256631841attach label a {text-decoration:none;}#yiv2256631841 blockquote {margin:0 0 0 4px;}#yiv2256631841 .yiv2256631841bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2256631841 .yiv2256631841bold a {text-decoration:none;}#yiv2256631841 dd.yiv2256631841last p a {font-family:Verdana;font-weight:700;}#yiv2256631841 dd.yiv2256631841last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2256631841 dd.yiv2256631841last p span.yiv2256631841yshortcuts {margin-right:0;}#yiv2256631841 div.yiv2256631841attach-table div div a {text-decoration:none;}#yiv2256631841 div.yiv2256631841attach-table {width:400px;}#yiv2256631841 div.yiv2256631841file-title a, #yiv2256631841 div.yiv2256631841file-title a:active, #yiv2256631841 div.yiv2256631841file-title a:hover, #yiv2256631841 div.yiv2256631841file-title a:visited {text-decoration:none;}#yiv2256631841 div.yiv2256631841photo-title a, #yiv2256631841 div.yiv2256631841photo-title a:active, #yiv2256631841 div.yiv2256631841photo-title a:hover, #yiv2256631841 div.yiv2256631841photo-title a:visited {text-decoration:none;}#yiv2256631841 div#yiv2256631841ygrp-mlmsg #yiv2256631841ygrp-msg p a span.yiv2256631841yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2256631841 .yiv2256631841green {color:#628c2a;}#yiv2256631841 .yiv2256631841MsoNormal {margin:0 0 0 0;}#yiv2256631841 o {font-size:0;}#yiv2256631841 #yiv2256631841photos div {float:left;width:72px;}#yiv2256631841 #yiv2256631841photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2256631841 #yiv2256631841photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2256631841 #yiv2256631841reco-category {font-size:77%;}#yiv2256631841 #yiv2256631841reco-desc {font-size:77%;}#yiv2256631841 .yiv2256631841replbq {margin:4px;}#yiv2256631841 #yiv2256631841ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2256631841 #yiv2256631841ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2256631841 #yiv2256631841ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2256631841 #yiv2256631841ygrp-mlmsg select, #yiv2256631841 input, #yiv2256631841 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2256631841 #yiv2256631841ygrp-mlmsg pre, #yiv2256631841 code {font:115% monospace;}#yiv2256631841 #yiv2256631841ygrp-mlmsg * {line-height:1.22em;}#yiv2256631841 #yiv2256631841ygrp-mlmsg #yiv2256631841logo {padding-bottom:10px;}#yiv2256631841 #yiv2256631841ygrp-msg p a {font-family:Verdana;}#yiv2256631841 #yiv2256631841ygrp-msg p#yiv2256631841attach-count span {color:#1E66AE;font-weight:700;}#yiv2256631841 #yiv2256631841ygrp-reco #yiv2256631841reco-head {color:#ff7900;font-weight:700;}#yiv2256631841 #yiv2256631841ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2256631841 #yiv2256631841ygrp-sponsor #yiv2256631841ov li a {font-size:130%;text-decoration:none;}#yiv2256631841 #yiv2256631841ygrp-sponsor #yiv2256631841ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2256631841 #yiv2256631841ygrp-sponsor #yiv2256631841ov ul {margin:0;padding:0 0 0 8px;}#yiv2256631841 #yiv2256631841ygrp-text {font-family:Georgia;}#yiv2256631841 #yiv2256631841ygrp-text p {margin:0 0 1em 0;}#yiv2256631841 #yiv2256631841ygrp-text tt {font-size:120%;}#yiv2256631841 #yiv2256631841ygrp-vital ul li:last-child {border-right:none !important;}#yiv2256631841

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.35

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)