15 Messages
Digest #4226
Messages
Thu Nov 9, 2017 6:43 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Explain how IE8 and IE11 are "having problems" with the JSON file? When I
try it in IE11, I get a popup at the bottom asking me if I want to open or
save the file. When I choose to open it with Notepad, I get the same result
you had from FireFox.
What do you get in EXCEL with:
=WEBSERVICE("
https://core-api.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,lastPrice
")
On Thu, Nov 9, 2017 at 6:05 PM, pauljl52@
...
wrote:
>
> I am having issues running smfGetBarchartPortfolioView-Example.xls on a
> WinXP machine with IE8 (Which I never use, i.e . IE8) all other
> aspects of smf including smfGetYahooPortfolioView.-example.xls run fine
> on this machine. I use this machine to run my Excel spreadsheets.
>
> I decided to give this a try:
> I have another machine running Win7 Pro with IE11
> smfGetBarchartPortfolioView-Example.xls is running fine on this machine
> Even though IE 11 is having problems resolving address you suggested I try.
>
> https://core- api.barchart.com/v1/quotes/
> get?symbols=MMM&fields=symbol, lastPrice
> <https://core-api.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,lastPrice>
>
> Using Firefox I get:
>
> {"count":1,"total":1,"data":[{"symbol":"MMM","lastPrice":"228.39"}],"errors":null} as well on both computers
>
>
> Both IE 8 and IE 11 have problems resolving this address:
>
> Any ideas?
>
>
try it in IE11, I get a popup at the bottom asking me if I want to open or
save the file. When I choose to open it with Notepad, I get the same result
you had from FireFox.
What do you get in EXCEL with:
=WEBSERVICE("
https://core-api.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,lastPrice
")
On Thu, Nov 9, 2017 at 6:05 PM, pauljl52@
...
wrote:
>
> I am having issues running smfGetBarchartPortfolioView-Example.xls on a
> WinXP machine with IE8 (Which I never use, i.e . IE8) all other
> aspects of smf including smfGetYahooPortfolioView.-example.xls run fine
> on this machine. I use this machine to run my Excel spreadsheets.
>
> I decided to give this a try:
> I have another machine running Win7 Pro with IE11
> smfGetBarchartPortfolioView-Example.xls is running fine on this machine
> Even though IE 11 is having problems resolving address you suggested I try.
>
> https://core- api.barchart.com/v1/quotes/
> get?symbols=MMM&fields=symbol, lastPrice
> <https://core-api.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,lastPrice>
>
> Using Firefox I get:
>
> {"count"
>
>
> Both IE 8 and IE 11 have problems resolving this address:
>
> Any ideas?
>
>
Fri Nov 10, 2017 6:05 am (PST) . Posted by:
pauljl52
Here is a screen shot (RCH) of the result I got after entering :
=WEBSERVICE("https://core-api.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,lastPrice https://core-api.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,lastPrice")
In screen shot (RCH 2) I put the URL into IE8 and that is the result
I had turned off the pop-up blocker still no pop-up appeared[
In screen shot RCH 3 result from IE 11 pop-up which is same result you got as well. Which means it's working and the smfGETBarChart is working on my Win 7 machine.
Thanks
=WEBSERVICE("https://core-api.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,lastPrice https://core-api.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,lastPrice")
In screen shot (RCH 2) I put the URL into IE8 and that is the result
I had turned off the pop-up blocker still no pop-up appeared[
In screen shot RCH 3 result from IE 11 pop-up which is same result you got as well. Which means it's working and the smfGETBarChart is working on my Win 7 machine.
Thanks
Attachment(s) from
3 of 3 File(s)
Fri Nov 10, 2017 9:31 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, if EXCEL and IE can't access the file, the add-in certainly
won't be able to. It's using the same Windows routines to access the
Internet that they use (i.e. Microsoft products).
On Fri, Nov 10, 2017 at 7:05 AM, pauljl52@
...
wrote:
>
> Here is a screen shot (RCH) of the result I got after entering :
>
> =WEBSERVICE("https://core-api.barchart.com/v1/quotes/get?
> symbols=MMM&fields=symbol,lastPrice")
>
> In screen shot (RCH 2) I put the URL into IE8 and that is the result
> I had turned off the pop-up blocker still no pop-up appeared[
>
> In screen shot RCH 3 result from IE 11 pop-up which is same result you
> got as well. Which means it's working and the smfGETBarChart is working on
> my Win 7 machine.
>
>
won't be able to. It's using the same Windows routines to access the
Internet that they use (i.e. Microsoft products).
On Fri, Nov 10, 2017 at 7:05 AM, pauljl52@
...
wrote:
>
> Here is a screen shot (RCH) of the result I got after entering :
>
> =WEBSERVICE("https://core-api.barchart.com/v1/quotes/get?
> symbols=MMM&fields=
>
> In screen shot (RCH 2) I put the URL into IE8 and that is the result
> I had turned off the pop-up blocker still no pop-up appeared[
>
> In screen shot RCH 3 result from IE 11 pop-up which is same result you
> got as well. Which means it's working and the smfGETBarChart is working on
> my Win 7 machine.
>
>
Thu Nov 9, 2017 7:02 pm (PST) . Posted by:
lhassrick
Randy,
Thank you for the SMF Add-in and your incredible patience. Like the others on the list, I have found the Addin an important tool in tracking and managing all my accounts as well as focusing my investing.
I have the latest version installed and it meets my needs well. Of course, if it were to somehow provide Starbucks coffee and bagels in the morning, well, that of course would be more than awesome.
Thanks!
Locke Hassrick
Thank you for the SMF Add-in and your incredible patience. Like the others on the list, I have found the Addin an important tool in tracking and managing all my accounts as well as focusing my investing.
I have the latest version installed and it meets my needs well. Of course, if it were to somehow provide Starbucks coffee and bagels in the morning, well, that of course would be more than awesome.
Thanks!
Locke Hassrick
Thu Nov 9, 2017 8:19 pm (PST) . Posted by:
jimmymc00
Randy or others. I could use some help finding an appropriate ticker to use with BarchartPortfolio add-in for a company traded on the DAX in Germany for Deutsche Post AG, one of my largest holdings. Yahoo used the company's DPW.de ticker which returned the correct information in Euros. Barchart website shows an international number (London exchg?), A-0H3Q.LS, that shows the company along with the correct price info in EUROs. When using that number with the BarchartPorfolio add-in it returns the correct company name but not the correct price info.
I'm only looking for last and previous price and would appreciate your thoughts. Is it possible to run a second file to get this data from Yahoo using the smfGetYahooPortfolio. I'm a little nervous going down this path and hosing up a days worth of work with the new BarchartPortfolio. RCHGetElementNumber also pulls data for DPW.de but I didn't see fields for the two data points mentioned.
BTW, this stock is doing very well, up around 30% this past year, setting record highs and it is not even X'mas yet (international parcel and mail delivery).
Thanks for any help. Jim
I'm only looking for last and previous price and would appreciate your thoughts. Is it possible to run a second file to get this data from Yahoo using the smfGetYahooPortfoli
BTW, this stock is doing very well, up around 30% this past year, setting record highs and it is not even X'mas yet (international parcel and mail delivery).
Thanks for any help. Jim
Thu Nov 9, 2017 8:33 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
There shouldn't be any issue running both an smfGetYahooPortfolioView() and
an smfGetBarchartPortfolioView() function, except that they would need
different ticker symbols...
On Thu, Nov 9, 2017 at 9:19 PM, jmcatee133@
...
wrote:
>
> Randy or others. I could use some help finding an appropriate ticker to
> use with BarchartPortfolio add-in for a company traded on the DAX in
> Germany for Deutsche Post AG, one of my largest holdings. Yahoo used the
> company's DPW.de ticker which returned the correct information in Euros.
> Barchart website shows an international number (London exchg?), A-0H3Q.LS,
> that shows the company along with the correct price info in EUROs. When
> using that number with the BarchartPorfolio add-in it returns the correct
> company name but not the correct price info.
>
> I'm only looking for last and previous price and would appreciate your
> thoughts. Is it possible to run a second file to get this data from Yahoo
> using the smfGetYahooPortfolio. I'm a little nervous going down this path
> and hosing up a days worth of work with the new BarchartPortfolio.
> RCHGetElementNumber also pulls data for DPW.de but I didn't see fields for
> the two data points mentioned.
>
> BTW, this stock is doing very well, up around 30% this past year, setting
> record highs and it is not even X'mas yet (international parcel and mail
> delivery).
>
>
an smfGetBarchartPortf
different ticker symbols...
On Thu, Nov 9, 2017 at 9:19 PM, jmcatee133@
...
wrote:
>
> Randy or others. I could use some help finding an appropriate ticker to
> use with BarchartPortfolio add-in for a company traded on the DAX in
> Germany for Deutsche Post AG, one of my largest holdings. Yahoo used the
> company'
> Barchart website shows an international number (London exchg?), A-0H3Q.LS,
> that shows the company along with the correct price info in EUROs. When
> using that number with the BarchartPorfolio add-in it returns the correct
> company name but not the correct price info.
>
> I'm only looking for last and previous price and would appreciate your
> thoughts. Is it possible to run a second file to get this data from Yahoo
> using the smfGetYahooPortfoli
> and hosing up a days worth of work with the new BarchartPortfolio.
> RCHGetElementNumber also pulls data for DPW.de but I didn't see fields for
> the two data points mentioned.
>
> BTW, this stock is doing very well, up around 30% this past year, setting
> record highs and it is not even X'mas yet (international parcel and mail
> delivery).
>
>
Fri Nov 10, 2017 2:34 am (PST) . Posted by:
eclipsme
I am using the following, arrayed entered:
=smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
where $B$4:$B$411 is the list of tickers and $C$2:$AJ$2 are the data points desired.
#33, dividends per share, seems to be returning incorrect data.
For instance, according to nasdaq.com, AAPL currently pays $.63 per quarter, or $2.42 per year.
Yahoo is returning $2.34.
I get similar discrepancies for T, TGT, ABBV.
Perhaps I am using the wrong data point? Even if I look at actual payments for the past year I do not get the same numbers that the spreadsheet is providing.
Have I done something wrong???
Thanks!
=smfGetYahooPortfol
where $B$4:$B$411 is the list of tickers and $C$2:$AJ$2 are the data points desired.
#33, dividends per share, seems to be returning incorrect data.
For instance, according to nasdaq.com, AAPL currently pays $.63 per quarter, or $2.42 per year.
Yahoo is returning $2.34.
I get similar discrepancies for T, TGT, ABBV.
Perhaps I am using the wrong data point? Even if I look at actual payments for the past year I do not get the same numbers that the spreadsheet is providing.
Have I done something wrong???
Thanks!
Fri Nov 10, 2017 4:27 am (PST) . Posted by:
jimmymc00
Harvey. I saw the same issue when using YahooPortfolio. It appears Yahoo hasn't kept up with the payments. The $2.34 number for AAPL coincides with the 2017 May and Feb and 2016 Nov and Aug payments. I switched over to the Forward Div Rate #36 which appears to be the current rate applied to the next 4 payments. More useful for me since it helps provide a good estimate (div rate x shares) of my next 12 mos of income.
-----Original Message-----
From: harvey@eclipsme.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Fri, Nov 10, 2017 5:34 am
Subject: [smf_addin] smfGetYahooPortfolioView dividends
I am using the following, arrayed entered:
=smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
where $B$4:$B$411 is the list of tickers and $C$2:$AJ$2 are the data points desired.
#33, dividends per share, seems to be returning incorrect data.
For instance, according to nasdaq.com, AAPL currently pays $.63 per quarter, or $2.42 per year.
Yahoo is returning $2.34.
I get similar discrepancies for T, TGT, ABBV.
Perhaps I am using the wrong data point? Even if I look at actual payments for the past year I do not get the same numbers that the spreadsheet is providing.
Have I done something wrong???
Thanks!
-----Original Message-----
From: harvey@eclipsme.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Fri, Nov 10, 2017 5:34 am
Subject: [smf_addin] smfGetYahooPortfoli
I am using the following, arrayed entered:
=smfGetYahooPortfol
where $B$4:$B$411 is the list of tickers and $C$2:$AJ$2 are the data points desired.
#33, dividends per share, seems to be returning incorrect data.
For instance, according to nasdaq.com, AAPL currently pays $.63 per quarter, or $2.42 per year.
Yahoo is returning $2.34.
I get similar discrepancies for T, TGT, ABBV.
Perhaps I am using the wrong data point? Even if I look at actual payments for the past year I do not get the same numbers that the spreadsheet is providing.
Have I done something wrong???
Thanks!
Fri Nov 10, 2017 9:21 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, that's what Yahoo is returning. You are using the trailing
dividend, but as you note, even that calculation seems to be wrong, since
$2.34 is three quarters of $0.57 and one quarter of $0.63 even though
they've paid out $0.63 the two most recent quarters.
As jmcatee133 notes, I think you want field #36, which is $2.52.
On Fri, Nov 10, 2017 at 3:34 AM, harvey@
...
wrote:
>
> I am using the following, arrayed entered:
> =smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
>
> where $B$4:$B$411 is the list of tickers and $C$2:$AJ$2 are the data
> points desired.
>
> #33, dividends per share, seems to be returning incorrect data.
>
> For instance, according to nasdaq.com, AAPL currently pays $.63 per
> quarter, or $2.42 per year.
>
> Yahoo is returning $2.34.
>
> I get similar discrepancies for T, TGT, ABBV.
>
> Perhaps I am using the wrong data point? Even if I look at actual payments
> for the past year I do not get the same numbers that the spreadsheet is
> providing.
>
> Have I done something wrong???
>
>
>
dividend, but as you note, even that calculation seems to be wrong, since
$2.34 is three quarters of $0.57 and one quarter of $0.63 even though
they've paid out $0.63 the two most recent quarters.
As jmcatee133 notes, I think you want field #36, which is $2.52.
On Fri, Nov 10, 2017 at 3:34 AM, harvey@
...
wrote:
>
> I am using the following, arrayed entered:
> =smfGetYahooPortfol
>
> where $B$4:$B$411 is the list of tickers and $C$2:$AJ$2 are the data
> points desired.
>
> #33, dividends per share, seems to be returning incorrect data.
>
> For instance, according to nasdaq.com, AAPL currently pays $.63 per
> quarter, or $2.42 per year.
>
> Yahoo is returning $2.34.
>
> I get similar discrepancies for T, TGT, ABBV.
>
> Perhaps I am using the wrong data point? Even if I look at actual payments
> for the past year I do not get the same numbers that the spreadsheet is
> providing.
>
> Have I done something wrong???
>
>
>
Fri Nov 10, 2017 6:59 am (PST) . Posted by:
gshell422
Not working on my computer.
I downloaded version 2017.11.04 as well as 2017.11.02. The following entry does not return any errors, although it does not return any values either.
=RCHGetYahooQuotes(A5:A17,"l1")
Thanks
I downloaded version 2017.11.04 as well as 2017.11.02. The following entry does not return any errors, although it does not return any values either.
=RCHGetYahooQuotes(
Thanks
Fri Nov 10, 2017 9:26 am (PST) . Posted by:
"Randy Harmelink" rharmelink
RCHGetYahooQuotes() is dead. Yahoo is no longer providing the data source.
See recent blog entries on the announcements blog:
https://smf-add-in.blogspot.com/
On Fri, Nov 10, 2017 at 7:59 AM, gshell422@
...
wrote:
>
> Not working on my computer.
> I downloaded version 2017.11.04 as well as 2017.11.02. The following entry
> does not return any errors, although it does not return any values either.
>
> =RCHGetYahooQuotes(A5:A17,"l1")
>
>
>
See recent blog entries on the announcements blog:
https://smf-add-in.blogspot.com/
On Fri, Nov 10, 2017 at 7:59 AM, gshell422@
...
wrote:
>
> Not working on my computer.
> I downloaded version 2017.11.04 as well as 2017.11.02. The following entry
> does not return any errors, although it does not return any values either.
>
> =RCHGetYahooQuotes(
>
>
>
Fri Nov 10, 2017 8:54 am (PST) . Posted by:
redcorolla9595
Hi all,
seems that Bloomberg has changed their website layout again
so the old formula to get the latest price
=smfGetTagContent("https://www.bloomberg.com/quote/BH:TB","div",0,"span class=""priceText""",,,,1)
seems not to work.
Does anyone know how the formula can be tweaked?
thanks!!
seems that Bloomberg has changed their website layout again
so the old formula to get the latest price
=smfGetTagContent("https://www.bloomberg.com/quote/BH:TB","
seems not to work.
Does anyone know how the formula can be tweaked?
thanks!!
Fri Nov 10, 2017 9:08 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfGetTagContent("https://www.bloomberg.com/quote/BH:TB","span",0,"span
class=""priceText_",,,,1)
On Fri, Nov 10, 2017 at 9:10 AM, redcorolla9595@
...
wrote:
> seems that Bloomberg has changed their website layout again
>
> so the old formula to get the latest price
>
> =smfGetTagContent("https://www.bloomberg.com/quote/BH:TB","div",0,"span
> class=""priceText""",,,,1)
>
> seems not to work.
>
> Does anyone know how the formula can be tweaked?
>
>
>
=smfGetTagContent("https://www.bloomberg.com/quote/BH:TB","span",0,"span
class=""priceText_",,,,1)
On Fri, Nov 10, 2017 at 9:10 AM, redcorolla9595@
...
wrote:
> seems that Bloomberg has changed their website layout again
>
> so the old formula to get the latest price
>
> =smfGetTagContent("https://www.bloomberg.com/quote/BH:TB","
> class="
>
> seems not to work.
>
> Does anyone know how the formula can be tweaked?
>
>
>
Fri Nov 10, 2017 8:54 am (PST) . Posted by:
"Raymond Lui" redcorolla9595
Hi all,
seems that bloomberg has changed their layout, so the previous formula to grab the latest price doesn't seem to work=smfGetTagContent("https://www.bloomberg.com/quote/"&B3,"div",0,"class=""price";"",,,,1)
does anyone have any suggestions?
thanks!!
seems that bloomberg has changed their layout, so the previous formula to grab the latest price doesn't seem to work=smfGetTagContent("https://www.bloomberg.com/quote/"&B3,"
does anyone have any suggestions?
thanks!!
Fri Nov 10, 2017 9:11 am (PST) . Posted by:
borat_rules
Okay thanks Randy I will try out your suggestion tonight when I get home from work and see if it works.
Thanks again you are a rock star.
SH
Thanks again you are a rock star.
SH
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar