15 Messages
Digest #4240
Messages
Fri Nov 17, 2017 4:53 am (PST) . Posted by:
"Higrm" higrm
Hi ccoup300,
I'm curious, what is the need for duplicate tickers in the call list? The data pulled would be identical to the previous entry of that ticker. Just reuse the data from the first call. The only purpose I can see is if you have multiple lots of the same symbol and want to keep them separate for tax purposes, (that's how my table is set up). But this doesn't require duplicates in the call for the data. Just reference the price of the symbol from the one call as many times as you have lots, (I have a tab with all the tickers I need in one call and reference the particular fields in my other tabs based on row and column references to that one source table). Is there another need that I don't see? Please clarify for me.
Thanks,Higrm
On Friday, November 17, 2017, 8:54:58 AM GMT+1, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Still pondering on it. So many other things that could be done... :(
On Thu, Nov 16, 2017 at 8:51 AM, ccoupe300@... wrote:
smfGetBarchartPortfolioView and smfGetYahooPortfolioView are both working great.
I believe someone already asked about second pass if duplicate tickers exist in a smfGetYahooPortfolioView array.
Have you given this any further consideration? I would find this useful in both smfGetBarchartPortfolioView and smfGetYahooPortfolioView.
I'm curious, what is the need for duplicate tickers in the call list? The data pulled would be identical to the previous entry of that ticker. Just reuse the data from the first call. The only purpose I can see is if you have multiple lots of the same symbol and want to keep them separate for tax purposes, (that's how my table is set up). But this doesn't require duplicates in the call for the data. Just reference the price of the symbol from the one call as many times as you have lots, (I have a tab with all the tickers I need in one call and reference the particular fields in my other tabs based on row and column references to that one source table). Is there another need that I don't see? Please clarify for me.
Thanks,Higrm
On Friday, November 17, 2017, 8:54:58 AM GMT+1, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Still pondering on it. So many other things that could be done... :(
On Thu, Nov 16, 2017 at 8:51 AM, ccoupe300@... wrote:
smfGetBarchartPortf
I believe someone already asked about second pass if duplicate tickers exist in a smfGetYahooPortfoli
Have you given this any further consideration? I would find this useful in both smfGetBarchartPortf
Fri Nov 17, 2017 5:10 am (PST) . Posted by:
"Higrm" higrm
@ tmallen2,Randy's solution is probably more robust, but simply preceding your formula with "Value( your formula)" would have converted the text to a number which you can then format as a currency. The unrobust part is the Right(x,6) portion as the currency symbol may not always be the same length.
Cheers,Higrm
On Friday, November 17, 2017, 8:52:52 AM GMT+1, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Try:
=smfStrExtr(RCHGetTableCell("http://quotes.morningstar.com/stock/c-dividends?&t="&$D14,1,"<tbody","Latest Indicated Dividend Amount",,,,,,"")," ","~",1)
The RCHGetTableCell() extracts "USD 1.1750" from the web page, then the smfStrExtr() extracts everything after the first blank to the end of the string (i.e. "~"), and the final "1" parameter says to strip off any HTML coding and convert to a number if possible.
Otherwise, you could have just put n smfConvertData() function around your result.
On Thu, Nov 16, 2017 at 11:19 AM, tmallen2@... wrote:
It looks like Morningstar changed the format on the way they present upcoming dividends.
See: http://quotes.morningstar.com/ stock/c-dividends?&t=vcit
They added USD in the front and of course that will mess up the lookup formatting.
I have played around trying to get it to format in the correct $ format. No luck so far.
Any ideas? I tried to use: RIGHT(RCHGetTableCell("http:// quotes.morningstar.com/stock/ c-dividends?&t="&$D14,1,"< tbody","Latest Indicated Dividend Amount",,,,,,""),6)
That removes the USD part but does not treat it as an actual number. Still text based. Formatting the result does not help.
Cheers,Higrm
On Friday, November 17, 2017, 8:52:52 AM GMT+1, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Try:
=smfStrExtr(RCHGetTableCell("http://quotes.morningstar.com/stock/c-dividends?&t="&$D14,1,"<tbody","Latest Indicated Dividend Amount",,,,,,"")," ","~",1)
The RCHGetTableCell() extracts "USD 1.1750" from the web page, then the smfStrExtr() extracts everything after the first blank to the end of the string (i.e. "~"), and the final "1" parameter says to strip off any HTML coding and convert to a number if possible.
Otherwise, you could have just put n smfConvertData() function around your result.
On Thu, Nov 16, 2017 at 11:19 AM, tmallen2@... wrote:
It looks like Morningstar changed the format on the way they present upcoming dividends.
See: http://quotes.morningstar.com/ stock/c-dividends?
They added USD in the front and of course that will mess up the lookup formatting.
I have played around trying to get it to format in the correct $ format. No luck so far.
Any ideas? I tried to use: RIGHT(RCHGetTableCe
That removes the USD part but does not treat it as an actual number. Still text based. Formatting the result does not help.
Fri Nov 17, 2017 7:46 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The advantage of smfConvertData() over Value() is that if the data isn't
numeric, smfConvertData() would return the text that isn't convertible,
while Value() would generate a #VALUE! error and not show what the error
might be caused by. An easy conversion is just using the result in a
mathematical operation, either adding 0 to it, or multiplying it by 1, but
both of those also cause a #VALUE! error if the returned text data is not
numbeice.
On Fri, Nov 17, 2017 at 6:10 AM, Higrm higrm@
...
wrote:
>
> Randy's solution is probably more robust, but simply preceding your
> formula with "Value( your formula)" would have converted the text to a
> number which you can then format as a currency. The unrobust part is the
> Right(x,6) portion as the currency symbol may not always be the same length.
>
>
>
numeric, smfConvertData(
while Value() would generate a #VALUE! error and not show what the error
might be caused by. An easy conversion is just using the result in a
mathematical operation, either adding 0 to it, or multiplying it by 1, but
both of those also cause a #VALUE! error if the returned text data is not
numbeice.
On Fri, Nov 17, 2017 at 6:10 AM, Higrm higrm@
...
wrote:
>
> Randy's solution is probably more robust, but simply preceding your
> formula with "Value( your formula)" would have converted the text to a
> number which you can then format as a currency. The unrobust part is the
> Right(x,6) portion as the currency symbol may not always be the same length.
>
>
>
Fri Nov 17, 2017 7:40 am (PST) . Posted by:
tony9bb
Randy,
I have used your add-in for a few years now and have kept up as best I can with all the changes. I haven''t needed to ask your help because I typically find answers here or I find alternative ways. But now I'm stuck.
I have used the Reuters Valuation Ratios (P/E High and P/E Low) in the past, even yesterday it worked. Today, not so much. And I can't figure out why.
I then downloaded the Reuters template (SMF-Template-Reuters-Ratios-Comparison) and none of the elements work.
My info is this:
RCH version:
Stock Market Functions add-in, Version 2.1.2017.11.08 (C:\SMF Add-in; Windows (64-bit) NT 6.01; 15.0; www; Local; 1)
Formula:
=RCHGetElementNumber(ticker,13630) Where $A$2=ticker
Please help.
Thank you for all you do to keep this add-in functioning with all the website changes being made throughout. You're a very patient trooper.
Tony M
I have used your add-in for a few years now and have kept up as best I can with all the changes. I haven'&#
I have used the Reuters Valuation Ratios (P/E High and P/E Low) in the past, even yesterday it worked. Today, not so much. And I can't figure out why.
I then downloaded the Reuters template (SMF-Template-
My info is this:
RCH version:
Stock Market Functions add-in, Version 2.1.2017.11.
Formula:
=RCHGetElementNumbe
Please help.
Thank you for all you do to keep this add-in functioning with all the website changes being made throughout. You're a very patient trooper.
Tony M
Fri Nov 17, 2017 9:02 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Thanks for the heads up. They changed the URL on their web pages, so I
needed to update all element definitions. See:
https://smf-add-in.blogspot.com/2017/11/alert-all-reuterscom-element.html
On Fri, Nov 17, 2017 at 8:31 AM, tony9bb@
...
wrote:
> I have used your add-in for a few years now and have kept up as best I can
> with all the changes. I haven''t needed to ask your help because I
> typically find answers here or I find alternative ways. But now I'm stuck.
>
> I have used the Reuters Valuation Ratios (P/E High and P/E Low) in the
> past, even yesterday it worked. Today, not so much. And I can't figure out
> why.
>
> I then downloaded the Reuters template (SMF-Template-Reuters-Ratios-Comparison)
> and none of the elements work.
>
> My info is this:
>
> RCH version:
>
> Stock Market Functions add-in, Version 2.1.2017.11.08 (C:\SMF Add-in;
> Windows (64-bit) NT 6.01; 15.0; www; Local; 1)
>
> Formula:
>
> =RCHGetElementNumber(ticker,13630) Where $A$2=ticker
>
> Please help.
>
> Thank you for all you do to keep this add-in functioning with all the
> website changes being made throughout. You're a very patient trooper.
>
>
>
needed to update all element definitions. See:
https://smf-add-in.blogspot.com/2017/11/alert-all-reuterscom-element.html
On Fri, Nov 17, 2017 at 8:31 AM, tony9bb@
...
wrote:
> I have used your add-in for a few years now and have kept up as best I can
> with all the changes. I haven'&#
> typically find answers here or I find alternative ways. But now I'm stuck.
>
> I have used the Reuters Valuation Ratios (P/E High and P/E Low) in the
> past, even yesterday it worked. Today, not so much. And I can't figure out
> why.
>
> I then downloaded the Reuters template (SMF-Template-
> and none of the elements work.
>
> My info is this:
>
> RCH version:
>
> Stock Market Functions add-in, Version 2.1.2017.11.
> Windows (64-bit) NT 6.01; 15.0; www; Local; 1)
>
> Formula:
>
> =RCHGetElementNumbe
>
> Please help.
>
> Thank you for all you do to keep this add-in functioning with all the
> website changes being made throughout. You're a very patient trooper.
>
>
>
Fri Nov 17, 2017 9:37 am (PST) . Posted by:
tony9bb
WOW.
Thanks for the speedy repairs. All is working.
You are just awesome.
Thanks,
Tony M
Thanks for the speedy repairs. All is working.
You are just awesome.
Thanks,
Tony M
Fri Nov 17, 2017 8:01 am (PST) . Posted by:
"Ron Spruell" hashky
Randy -
Have you looked at this? Of any value?
"https://www.barchart.com/ondemand/free-market-data-api"
Ron
Have you looked at this? Of any value?
"https://www.barchart.com/ondemand/free-market-data-api"
Ron
Fri Nov 17, 2017 8:48 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I checked them out a few months ago. The current quotes and historical
quotes APIs are free, but not any of the others -- big bucks.
Once you have requested the free API key, you can use the CSV request
option to get current or historical quotes using the smfGetCSVFile()
function. The default is that historical quotes *are* adjusted for
dividends and splits, but either default can be overridden.
https://www.barchart.com/ondemand/api/getQuote
https://www.barchart.com/ondemand/api/getHistory
On Fri, Nov 17, 2017 at 9:01 AM, Ron Spruell hashky@
...
wrote:
>
> Have you looked at this? Of any value?
>
> "https://www.barchart.com/ondemand/free-market-data-api"
>
>
quotes APIs are free, but not any of the others -- big bucks.
Once you have requested the free API key, you can use the CSV request
option to get current or historical quotes using the smfGetCSVFile()
function. The default is that historical quotes *are* adjusted for
dividends and splits, but either default can be overridden.
https://www.barchart.com/ondemand/api/getQuote
https://www.barchart.com/ondemand/api/getHistory
On Fri, Nov 17, 2017 at 9:01 AM, Ron Spruell hashky@
...
wrote:
>
> Have you looked at this? Of any value?
>
> "https://www.barchart.com/ondemand/free-market-data-api"
>
>
Fri Nov 17, 2017 8:11 am (PST) . Posted by:
"Ron Spruell" hashky
Randy -
I try to sync my data using the date. So that fields like finviz "Prev Close make sense.
I am using
=smfGetYahooPortfolioView("SPY","87")
I don't see any date fields being available on finviz.com or barchart.com
Ron
I try to sync my data using the date. So that fields like finviz "Prev Close make sense.
I am using
=smfGetYahooPortfol
I don't see any date fields being available on finviz.com or barchart.com
Ron
Fri Nov 17, 2017 8:28 am (PST) . Posted by:
"Randy Harmelink" rharmelink
For smfGetBarchartPortfolioView(), they call field #16 "Trade Time", which
is the label I gave it, by it's actually just the last traded date. No time
component that I can see.
I don't see a viable field for Finviz. They do display a time stamp on the
web page, but it's placed their dynamically and is not available for
extraction from the source code of the web page. At least not that I see.
On Fri, Nov 17, 2017 at 9:11 AM, Ron Spruell hashky@
...
wrote:
>
> I try to sync my data using the date. So that fields like finviz "Prev
> Close make sense.
>
> I am using
>
> =smfGetYahooPortfolioView("SPY","87")
>
> I don't see any date fields being available on finviz.com or barchart.com
>
>
is the label I gave it, by it's actually just the last traded date. No time
component that I can see.
I don't see a viable field for Finviz. They do display a time stamp on the
web page, but it's placed their dynamically and is not available for
extraction from the source code of the web page. At least not that I see.
On Fri, Nov 17, 2017 at 9:11 AM, Ron Spruell hashky@
...
wrote:
>
> I try to sync my data using the date. So that fields like finviz "Prev
> Close make sense.
>
> I am using
>
> =smfGetYahooPortfol
>
> I don't see any date fields being available on finviz.com or barchart.com
>
>
Fri Nov 17, 2017 10:17 am (PST) . Posted by:
"Ron Spruell" hashky
I must be the last light on the string. I can't seem to get a date from Barchart. I agree with you on FinViz.
Windows 7
Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 14.0; ; Local; 1)
This is what I get from Barchart.
"=smfGetBarchartPortfolioView("SPY","016")" 13:05 ET
"=smfGetBarchartPortfolioView("SPY","16")"
9/15/1900
Formatting both as General, I get 13:05 ET and 259.35
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, November 17, 2017 10:28 AM
Subject: Re: [smf_addin] Date & Sync data
For smfGetBarchartPortfolioView(), they call field #16 "Trade Time", which is the label I gave it, by it's actually just the last traded date. No time component that I can see.
I don't see a viable field for Finviz. They do display a time stamp on the web page, but it's placed their dynamically and is not available for extraction from the source code of the web page. At least not that I see.
On Fri, Nov 17, 2017 at 9:11 AM, Ron Spruell hashky@... wrote:
I try to sync my data using the date. So that fields like finviz "Prev Close make sense.
I am using
=smfGetYahooPortfolioView(" SPY","87")
I don't see any date fields being available on finviz.com or barchart.com
#yiv8834895034 #yiv8834895034 -- #yiv8834895034ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8834895034 #yiv8834895034ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8834895034 #yiv8834895034ygrp-mkp #yiv8834895034hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8834895034 #yiv8834895034ygrp-mkp #yiv8834895034ads {margin-bottom:10px;}#yiv8834895034 #yiv8834895034ygrp-mkp .yiv8834895034ad {padding:0 0;}#yiv8834895034 #yiv8834895034ygrp-mkp .yiv8834895034ad p {margin:0;}#yiv8834895034 #yiv8834895034ygrp-mkp .yiv8834895034ad a {color:#0000ff;text-decoration:none;}#yiv8834895034 #yiv8834895034ygrp-sponsor #yiv8834895034ygrp-lc {font-family:Arial;}#yiv8834895034 #yiv8834895034ygrp-sponsor #yiv8834895034ygrp-lc #yiv8834895034hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8834895034 #yiv8834895034ygrp-sponsor #yiv8834895034ygrp-lc .yiv8834895034ad {margin-bottom:10px;padding:0 0;}#yiv8834895034 #yiv8834895034actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8834895034 #yiv8834895034activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8834895034 #yiv8834895034activity span {font-weight:700;}#yiv8834895034 #yiv8834895034activity span:first-child {text-transform:uppercase;}#yiv8834895034 #yiv8834895034activity span a {color:#5085b6;text-decoration:none;}#yiv8834895034 #yiv8834895034activity span span {color:#ff7900;}#yiv8834895034 #yiv8834895034activity span .yiv8834895034underline {text-decoration:underline;}#yiv8834895034 .yiv8834895034attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8834895034 .yiv8834895034attach div a {text-decoration:none;}#yiv8834895034 .yiv8834895034attach img {border:none;padding-right:5px;}#yiv8834895034 .yiv8834895034attach label {display:block;margin-bottom:5px;}#yiv8834895034 .yiv8834895034attach label a {text-decoration:none;}#yiv8834895034 blockquote {margin:0 0 0 4px;}#yiv8834895034 .yiv8834895034bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8834895034 .yiv8834895034bold a {text-decoration:none;}#yiv8834895034 dd.yiv8834895034last p a {font-family:Verdana;font-weight:700;}#yiv8834895034 dd.yiv8834895034last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8834895034 dd.yiv8834895034last p span.yiv8834895034yshortcuts {margin-right:0;}#yiv8834895034 div.yiv8834895034attach-table div div a {text-decoration:none;}#yiv8834895034 div.yiv8834895034attach-table {width:400px;}#yiv8834895034 div.yiv8834895034file-title a, #yiv8834895034 div.yiv8834895034file-title a:active, #yiv8834895034 div.yiv8834895034file-title a:hover, #yiv8834895034 div.yiv8834895034file-title a:visited {text-decoration:none;}#yiv8834895034 div.yiv8834895034photo-title a, #yiv8834895034 div.yiv8834895034photo-title a:active, #yiv8834895034 div.yiv8834895034photo-title a:hover, #yiv8834895034 div.yiv8834895034photo-title a:visited {text-decoration:none;}#yiv8834895034 div#yiv8834895034ygrp-mlmsg #yiv8834895034ygrp-msg p a span.yiv8834895034yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8834895034 .yiv8834895034green {color:#628c2a;}#yiv8834895034 .yiv8834895034MsoNormal {margin:0 0 0 0;}#yiv8834895034 o {font-size:0;}#yiv8834895034 #yiv8834895034photos div {float:left;width:72px;}#yiv8834895034 #yiv8834895034photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8834895034 #yiv8834895034photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8834895034 #yiv8834895034reco-category {font-size:77%;}#yiv8834895034 #yiv8834895034reco-desc {font-size:77%;}#yiv8834895034 .yiv8834895034replbq {margin:4px;}#yiv8834895034 #yiv8834895034ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8834895034 #yiv8834895034ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8834895034 #yiv8834895034ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8834895034 #yiv8834895034ygrp-mlmsg select, #yiv8834895034 input, #yiv8834895034 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8834895034 #yiv8834895034ygrp-mlmsg pre, #yiv8834895034 code {font:115% monospace;}#yiv8834895034 #yiv8834895034ygrp-mlmsg * {line-height:1.22em;}#yiv8834895034 #yiv8834895034ygrp-mlmsg #yiv8834895034logo {padding-bottom:10px;}#yiv8834895034 #yiv8834895034ygrp-msg p a {font-family:Verdana;}#yiv8834895034 #yiv8834895034ygrp-msg p#yiv8834895034attach-count span {color:#1E66AE;font-weight:700;}#yiv8834895034 #yiv8834895034ygrp-reco #yiv8834895034reco-head {color:#ff7900;font-weight:700;}#yiv8834895034 #yiv8834895034ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8834895034 #yiv8834895034ygrp-sponsor #yiv8834895034ov li a {font-size:130%;text-decoration:none;}#yiv8834895034 #yiv8834895034ygrp-sponsor #yiv8834895034ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8834895034 #yiv8834895034ygrp-sponsor #yiv8834895034ov ul {margin:0;padding:0 0 0 8px;}#yiv8834895034 #yiv8834895034ygrp-text {font-family:Georgia;}#yiv8834895034 #yiv8834895034ygrp-text p {margin:0 0 1em 0;}#yiv8834895034 #yiv8834895034ygrp-text tt {font-size:120%;}#yiv8834895034 #yiv8834895034ygrp-vital ul li:last-child {border-right:none !important;}#yiv8834895034
Windows 7
Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\SMF Add-In; Windows (32-bit) NT 6.01; 14.0; ; Local; 1)
This is what I get from Barchart.
"=smfGetBarchartPortfolioView("SPY","016")" 13:05 ET
"=smfGetBarchartPortfolioView("SPY","16")"
9/15/1900
Formatting both as General, I get 13:05 ET and 259.35
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, November 17, 2017 10:28 AM
Subject: Re: [smf_addin] Date & Sync data
For smfGetBarchartPortf
I don't see a viable field for Finviz. They do display a time stamp on the web page, but it's placed their dynamically and is not available for extraction from the source code of the web page. At least not that I see.
On Fri, Nov 17, 2017 at 9:11 AM, Ron Spruell hashky@... wrote:
I try to sync my data using the date. So that fields like finviz "Prev Close make sense.
I am using
=smfGetYahooPortfol
I don't see any date fields being available on finviz.com or barchart.com
#yiv8834895034 #yiv8834895034 -- #yiv8834895034ygrp-
Fri Nov 17, 2017 9:42 am (PST) . Posted by:
climbermel
Thanks, I guess I need to work faster... I thought I was current with 11.04, but I changed to 11.11 and they work now. Thanks.
Mel
Mel
Fri Nov 17, 2017 9:45 am (PST) . Posted by:
nmalhotr
Randy:
Having difficulties getting the following ticker data using smfgetyahooportfolioview.
Any thoughts?
AMT180420C00130000
IBM190118C00145000
NM
Having difficulties getting the following ticker data using smfgetyahooportfoli
Any thoughts?
AMT180420C00130000
IBM190118C00145000
NM
Fri Nov 17, 2017 9:53 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Not sure what to tell you -- both appear to be working fine here?
01 15 87 17 18 19 20 21 00 51 52
*Ticker Symbol* *Symbol* *Last Price* *Last Traded Date/Time* *Change*
*Open* *High* *Low* *Volume* *--* *Prev Close* *% Chg*
AMT180420C00130000 AMT180420C00130000 $19.41 2017-11-17 10:40:53 AM -$2.24
$19.41 $19.41 $19.41 8 -- $21.65 -10.35%
IBM190118C00145000 IBM190118C00145000 $13.85 2017-11-17 11:53:54 AM $0.22
$14.00 $14.00 $13.85 5 -- $13.63 1.61%
Are you using the most recent version of the add-in? What specific formula
invocations are you using?
On Fri, Nov 17, 2017 at 10:45 AM, namit98@
...
wrote:
> Having difficulties getting the following ticker data using
> smfgetyahooportfolioview.
>
> Any thoughts?
>
> AMT180420C00130000
>
> IBM190118C00145000
>
>
>
01 15 87 17 18 19 20 21 00 51 52
*Ticker Symbol* *Symbol* *Last Price* *Last Traded Date/Time* *Change*
*Open* *High* *Low* *Volume* *--* *Prev Close* *% Chg*
AMT180420C00130000 AMT180420C00130000 $19.41 2017-11-17 10:40:53 AM -$2.24
$19.41 $19.41 $19.41 8 -- $21.65 -10.35%
IBM190118C00145000 IBM190118C00145000 $13.85 2017-11-17 11:53:54 AM $0.22
$14.00 $14.00 $13.85 5 -- $13.63 1.61%
Are you using the most recent version of the add-in? What specific formula
invocations are you using?
On Fri, Nov 17, 2017 at 10:45 AM, namit98@
...
wrote:
> Having difficulties getting the following ticker data using
> smfgetyahooportfoli
>
> Any thoughts?
>
> AMT180420C00130000
>
> IBM190118C00145000
>
>
>
Fri Nov 17, 2017 10:19 am (PST) . Posted by:
nmalhotr
Thanks.
Just realized if the ticker symbol is (accidentally) duplicated in the array, it blanks out the second time.
Really appreciate what you do man!
NM
Just realized if the ticker symbol is (accidentally) duplicated in the array, it blanks out the second time.
Really appreciate what you do man!
NM
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar