15 Messages
Digest #4232
Messages
Sat Nov 11, 2017 6:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
#NAME? usually means the add-in isn't installed properly.
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetWebData("https://core-api.barchart.com/v1/quotes/get
?symbols=MMM&fields=symbol,lastPrice")
On Sat, Nov 11, 2017 at 6:37 PM, jchyjun@
...
wrote:
>
> I use SMF for awhile in quite simple way very similar to initial
> borat_rules message from Nov 9 3:51 PM in this treat.
>
> Because of Yahoo problem I downloaded latest SMF /so I have Stock Market
> Functions add-in, Version 2.1.2017.11.08/ as well as the template file
> smfGetYahooPortfolioView-Example.xls. I presume that
> smfGetYahooPortfolioView() function is included in the latest
> RCH_Stock_Market_Functions file (is it correct?)
>
> After I reloaded MS-Excel 2003 with latest SMF (C:\SMF Add-In; Windows
> (32-bit) NT 5.01; 11.0; ; ; 1) I also got "--" in each active cell
>
> Cell with =smfGetYahooPorfolioView("MMM","15") produces #NAME?.
>
> Why "--"and "#NAME"? appears? How to get numbers?
>
>
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetWebData("https://core-api.barchart.com/v1/quotes/get
?symbols=MMM&fields
On Sat, Nov 11, 2017 at 6:37 PM, jchyjun@
...
wrote:
>
> I use SMF for awhile in quite simple way very similar to initial
> borat_rules message from Nov 9 3:51 PM in this treat.
>
> Because of Yahoo problem I downloaded latest SMF /so I have Stock Market
> Functions add-in, Version 2.1.2017.11.
> smfGetYahooPortfoli
> smfGetYahooPortfoli
> RCH_Stock_Market_
>
> After I reloaded MS-Excel 2003 with latest SMF (C:\SMF Add-In; Windows
> (32-bit) NT 5.01; 11.0; ; ; 1) I also got "--" in each active cell
>
> Cell with =smfGetYahooPorfoli
>
> Why "--"
>
>
Sat Nov 11, 2017 6:46 pm (PST) . Posted by:
JCHyjun
I got "Last Price" when I put symbol MMM in B5 cell and =smfGetYahooPortfolioView(B5,"15",,1) in C5 cell
I got "Invalid tickers parameter: " if B5 cell is empty.
How to get numbers (e.g. price 227.45now for MMM)?
Thanks
JCH
I got "Invalid tickers parameter: " if B5 cell is empty.
How to get numbers (e.g. price 227.45now for MMM)?
Thanks
JCH
Sat Nov 11, 2017 6:49 pm (PST) . Posted by:
JCHyjun
I should add:
I get "--" for =smfGetYahooPortfolioView(B6,"15",,0) even when symbol is in B6
I get "--" for =smfGetYahooPortfol
Sat Nov 11, 2017 7:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
If you ask for a header and only enter it into a single cell, all you'll
get is the header.
On Sat, Nov 11, 2017 at 7:46 PM, jchyjun@
...
wrote:
>
> I got "Last Price" when I put symbol MMM in B5 cell and
> =smfGetYahooPortfolioView(B5,"15",,1) in C5 cell
> I got "Invalid tickers parameter: " if B5 cell is empty.
> How to get numbers (e.g. price 227.45now for MMM)?
>
>
get is the header.
On Sat, Nov 11, 2017 at 7:46 PM, jchyjun@
...
wrote:
>
> I got "Last Price" when I put symbol MMM in B5 cell and
> =smfGetYahooPortfol
> I got "Invalid tickers parameter: " if B5 cell is empty.
> How to get numbers (e.g. price 227.45now for MMM)?
>
>
Sat Nov 11, 2017 8:05 pm (PST) . Posted by:
JCHyjun
I read http://ogres-crypt.com/SMF/Documentation/viewer.php?name=smfGetYahooPortfolioView-Function.html http://ogres-crypt.com/SMF/Documentation/viewer.php?name=smfGetYahooPortfolioView-Function.html but cannot figure out how to get stock price (not header)
=smfGetYahooPortfolioView(B5,"15",,,0) produces "--"
=smfGetYahooPortfolioView(B5,"15") produces "--"
=smfGetYahooPortfolioView(B5:B6,C3:D3,,1) produces "--"
etc...
=smfGetYahooPortfolioView(B5,15) produces "Invalid items parameter: 15"
=RCHGetElementNumber("Version" ) produces "Stock Market Functions add-in, Version 2.1.2017.11.08 (C:\SMF Add-In; Windows (32-bit) NT 5.01; 11.0; ; ; 1) "
I use SMF at Windows XP with MS-Excel 2003 computer.
How to get single stock price using smfGetYahooPortfolioView ?
Thanks
JCH
=smfGetYahooPortfol
=smfGetYahooPortfol
=smfGetYahooPortfol
etc...
=smfGetYahooPortfol
=RCHGetElementNumbe
I use SMF at Windows XP with MS-Excel 2003 computer.
How to get single stock price using smfGetYahooPortfoli
Thanks
JCH
Sat Nov 11, 2017 9:41 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
All are working for me, but I've got some additional changes in place since
2017.11.08. The function was designed to get a range of items for multiple
tickers, not an individual item for a single ticker, so I had to make some
changes for that. If you are getting multiple quotes, you SHOULD
array-enter it and NOT get each price individually.
What do you get with:
=RCHGetWebData("https://core-api.barchart.com/v1/quotes/get?
symbols=MMM&fields=symbol,lastPrice")
=smfGetYahooPortfolioView("MMM","1552")
Re:
=smfGetYahooPortfolioView(B5:B6,C3:D3,,1) produces "--"
If a single "--" is all you got, you didn't array-enter it over a range.
That should be array-entered over a 3-row by 2-column range. Try using 15
and 52 in cells C3 and D3.
On Sat, Nov 11, 2017 at 9:05 PM, jchyjun@
...
wrote:
>
> I read http://ogres-crypt.com/SMF/Documentation/viewer.php?name=
> smfGetYahooPortfolioView-Function.html but cannot figure out how to get
> stock price (not header)
> =
>
> smfGetYahooPortfolioView(B5,"15",,,0) produces "--"
> =smfGetYahooPortfolioView(B5,"15") produces "--"
>
> =smfGetYahooPortfolioView(B5:B6,C3:D3,,1) produces "--"
> etc...
>
> =smfGetYahooPortfolioView(B5,15) produces "Invalid items parameter: 15"
>
> =RCHGetElementNumber("Version" ) produces "Stock Market Functions add-in,
> Version 2.1.2017.11.08 (C:\SMF Add-In; Windows (32-bit) NT 5.01; 11.0; ; ;
> 1) "
>
> I use SMF at Windows XP with MS-Excel 2003 computer.
>
> How to get single stock price using smfGetYahooPortfolioView ?
>
>
2017.11.08. The function was designed to get a range of items for multiple
tickers, not an individual item for a single ticker, so I had to make some
changes for that. If you are getting multiple quotes, you SHOULD
array-enter it and NOT get each price individually.
What do you get with:
=RCHGetWebData("https://core-api.barchart.com/v1/quotes/get?
symbols=MMM&fields=symbol,lastPrice")
=smfGetYahooPortfolioView("MMM","1552")
Re:
=smfGetYahooPortfolioView(B5:B6,C3:D3,,1) produces "--"
If a single "--" is all you got, you didn't array-enter it over a range.
That should be array-entered over a 3-row by 2-column range. Try using 15
and 52 in cells C3 and D3.
On Sat, Nov 11, 2017 at 9:05 PM, jchyjun@
...
wrote:
>
> I read http://ogres-crypt.com/SMF/Documentation/viewer.php?name=
> smfGetYahooPortfoli
> stock price (not header)
> =
>
> smfGetYahooPortfoli
> =smfGetYahooPortfol
>
> =smfGetYahooPortfol
> etc...
>
> =smfGetYahooPortfol
>
> =RCHGetElementNumbe
> Version 2.1.2017.11.
> 1) "
>
> I use SMF at Windows XP with MS-Excel 2003 computer.
>
> How to get single stock price using smfGetYahooPortfoli
>
>
Sat Nov 11, 2017 11:02 pm (PST) . Posted by:
JCHyjun
Randy,
I know that you designed smfGetYahooPortfolioView for array but it should work for 1x1 (i.e. single cell) or 2x2 (see below) array as well - isn't it?
I get "--" in all C3...AJ411 cells of your recent template file smfGetYahooPortfolioView-Example, so I try to figure out the cause for smaller array.
>Try using 15 and 52 in cells C3 and D3.
I get "--" in the cells C5,C6,D5,D6 with
=smfGetYahooPortfolioView(B5:B6,C3:D3) or with
=smfGetYahooPortfolioView(B5:B6,C3:D3,,0)
when the cells C3=15, D3=52, B5=MMM, B6=IBM .
I get "Last Price" for C4 cell and "%Chg" for D4 cell for =smfGetYahooPortfolioView(B5:B6,C3:D3,,1). It seems that header 1 works but header 0 does not.
I get "--" for =smfGetYahooPortfolioView("MMM","1552"). As far as I understand this is 1x2 array.
I get "Error" for =RCHGetWebData("https://core-a pi.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,last Price") I guess because I'm not barchart.com subscriber. I didn't use RCHGetWebData before
I get CORRECT PRICE for =smfGetTagContent("http://quotes.morningstar.com/stockq/c-header?t=MMM","div",-1,"vkey=""LastPrice""",,,,1)
Please help.
JCH
I know that you designed smfGetYahooPortfolioView for array but it should work for 1x1 (i.e. single cell) or 2x2 (see below) array as well - isn't it?
I get "--" in all C3...AJ411 cells of your recent template file smfGetYahooPortfolioView-Example, so I try to figure out the cause for smaller array.
>Try using 15 and 52 in cells C3 and D3.
I get "--" in the cells C5,C6,D5,D6 with
=smfGetYahooPortfolioView(B5:B6,C3:D3) or with
=smfGetYahooPortfolioView(B5:B6,C3:D3,,0)
when the cells C3=15, D3=52, B5=MMM, B6=IBM .
I get "Last Price" for C4 cell and "%Chg" for D4 cell for =smfGetYahooPortfolioView(B5:B6,C3:D3,,1). It seems that header 1 works but header 0 does not.
I get "--" for =smfGetYahooPortfolioView("MMM","1552"). As far as I understand this is 1x2 array.
I get "Error" for =RCHGetWebData("https://core-a pi.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,last Price") I guess because I'm not barchart.com subscriber. I didn't use RCHGetWebData before
I get CORRECT PRICE for =smfGetTagContent("http://quotes.morningstar.com/stockq/c-header?t=MMM","
Please help.
JCH
Sat Nov 11, 2017 11:26 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Oops. I meant to ask about the Yahoo URL, not the Barchart one. Does this
one work:
=RCHGetWebData("
https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&formatted=false&symbols=MMM
")
I think you'll need the next release of the add-in to get just the latest
price. It is working here, but I did have to make a change if no
non-default fields were requested, because the add-in was trimming 2 bytes
off the field list it generated. However, if only default fields were
requested, the field list was only 1 byte long. That causes an error. which
returns all of the defaulted "--" values that fill the returned area.
I'll try to post the next release later today (Sunday).
On Sun, Nov 12, 2017 at 12:02 AM, jchyjun@
...
wrote:
>
> I know that you designed smfGetYahooPortfolioView for array but it should
> work for 1x1 (i.e. single cell) or 2x2 (see below) array as well - isn't it?
> I get "--" in all C3...AJ411 cells of your recent template file
> smfGetYahooPortfolioView-Example, so I try to figure out the cause for
> smaller array.
>
> >Try using 15 and 52 in cells C3 and D3.
> I get "--" in the cells C5,C6,D5,D6 with
> =smfGetYahooPortfolioView(B5:B6,C3:D3) or with
> =smfGetYahooPortfolioView(B5:B6,C3:D3,,0)
> when the cells C3=15, D3=52, B5=MMM, B6=IBM .
>
> I get "Last Price" for C4 cell and "%Chg" for D4 cell for
> =smfGetYahooPortfolioView(B5:B6,C3:D3,,1). It seems that header 1 works
> but header 0 does not.
>
> I get "--" for =smfGetYahooPortfolioView("MMM","1552"). As far as I
> understand this is 1x2 array.
>
> I get "Error" for =RCHGetWebData("https://core-a
> pi.barchart.com/v1/quotes/get?symbols=MMM&fields=symbol,last Price") I
> guess because I'm not barchart.com subscriber. I didn't use RCHGetWebData
> before
>
>
> I get CORRECT PRICE for =smfGetTagContent("http://
> quotes.morningstar.com/stockq/c-header?t=MMM","div",-1,"
> vkey=""LastPrice""",,,,1)
>
> Please help.
>
one work:
=RCHGetWebData("
https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&formatted=false&symbols=MMM
")
I think you'll need the next release of the add-in to get just the latest
price. It is working here, but I did have to make a change if no
non-default fields were requested, because the add-in was trimming 2 bytes
off the field list it generated. However, if only default fields were
requested, the field list was only 1 byte long. That causes an error. which
returns all of the defaulted "--" values that fill the returned area.
I'll try to post the next release later today (Sunday).
On Sun, Nov 12, 2017 at 12:02 AM, jchyjun@
...
wrote:
>
> I know that you designed smfGetYahooPortfolioView for array but it should
> work for 1x1 (i.e. single cell) or 2x2 (see below) array as well - isn't it?
> I get "--" in all C3...AJ411 cells of your recent template file
> smfGetYahooPortfolioView-Example, so I try to figure out the cause for
> smaller array.
>
> >Try using 15 and 52 in cells C3 and D3.
> I get "--" in the cells C5,C6,D5,D6 with
> =smfGetYahooPortfolioView(B5:B6,C3:D3) or with
> =smfGetYahooPortfolioView(B5:B6,C3:D3,,0)
> when the cells C3=15, D3=52, B5=MMM, B6=IBM .
>
> I get "Last Price" for C4 cell and "%Chg" for D4 cell for
> =smfGetYahooPortfolioView(B5:B6,C3:D3,,1). It seems that header 1 works
> but header 0 does not.
>
> I get "--" for =smfGetYahooPortfolioView("MMM","1552"). As far as I
> understand this is 1x2 array.
>
> I get "Error" for =RCHGetWebData("https://core-a
> pi.barchart.
> guess because I'm not barchart.com subscriber. I didn't use RCHGetWebData
> before
>
>
> I get CORRECT PRICE for =smfGetTagContent(
> quotes.morningstar.
> vkey=""
>
> Please help.
>
Sun Nov 12, 2017 5:45 am (PST) . Posted by:
JCHyjun
Hi Randy
I get empty cell with =RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&formatted=false&symbols=MMM")
JCH
I get empty cell with =RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&formatted=false&symbols=MMM")
JCH
Sun Nov 12, 2017 5:56 am (PST) . Posted by:
JCHyjun
Hi Randy,
I think than reincarnation of RCHGetYahooQuotes() function will be useful. You can give new name e.g. RCHGetYahooInfo2017() and simplify replacing codes with field numbers (as in smfGetYahooPortfolioView-Example file). It gives SMF users significant flexibility.
Best Regards
JCH http://ogres-crypt.com/SMF/Documentation/viewer.php?name=RCHGetYahooQuotes-Function.html
I think than reincarnation of RCHGetYahooQuotes() function will be useful. You can give new name e.g. RCHGetYahooInfo2017() and simplify replacing codes with field numbers (as in smfGetYahooPortfolioView-Example file). It gives SMF users significant flexibility.
Best Regards
JCH http://ogres-crypt.com/SMF/Documentation/viewer.php?name=RCHGetYahooQuotes-Function.html
Sun Nov 12, 2017 9:15 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, if you get nothing with that URL, smfGetYahooPortfolioView()
is never going to work. That's where it gets it's data. It should be
returning something like:
{"quoteResponse":{"result":[{"language":"en-US","quoteType":"EQUITY","market":"us_market","fullExchangeName":"NYSE","regularMarketPrice":227.45,"regularMarketTime":1510347764,"sourceInterval":15,"exchangeTimezoneName":"America/New_York","exchangeTimezoneShortName":"EST","gmtOffSetMilliseconds":-18000000,"tradeable":true,"marketState":"CLOSED","exchange":"NYQ","exchangeDataDelayedBy":0,"symbol":"MMM"}],"error":null}}
That JSON file also feeds this web page on Yahoo:
https://finance.yahoo.com/quotes/IBM,MMM/view/v1?ql=1
I'm curious what you get if you visit that web page with IE? Do you get
different results with your default browser?
On Sun, Nov 12, 2017 at 6:45 AM, jchyjun@
...
wrote:
>
> I get empty cell with =
>
> RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/quote?fields=
> regularMarketPrice&formatted=false&symbols=MMM")
>
>
>
is never going to work. That's where it gets it's data. It should be
returning something like:
{"quoteResponse":{"result":[{"language":"en-US","quoteType":"EQUITY","market":"us_market","fullExchangeName":"NYSE","regularMarketPrice":227.45,"regularMarketTime":1510347764,"sourceInterval":15,"exchangeTimezoneName":"America/New_York","exchangeTimezoneShortName":"EST","gmtOffSetMilliseconds":-18000000,"tradeable":true,"marketState":"CLOSED","exchange":"NYQ","exchangeDataDelayedBy":0,"symbol":"MMM"}],"error":null}}
That JSON file also feeds this web page on Yahoo:
https://finance.yahoo.com/quotes/IBM,MMM/view/v1?ql=1
I'm curious what you get if you visit that web page with IE? Do you get
different results with your default browser?
On Sun, Nov 12, 2017 at 6:45 AM, jchyjun@
...
wrote:
>
> I get empty cell with =
>
> RCHGetWebData("https://query1.finance.yahoo.com/v7/finance/quote?fields=
> regularMarketPrice&
>
>
>
Sun Nov 12, 2017 9:17 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It was my plan to eventually update RCHGetYahooQuotes(), adding a
field-to-field translation. However, as time goes on and people manually
convert to smfGetYahooPortfolioView(), I think there is less and less of a
need.
On Sun, Nov 12, 2017 at 6:56 AM, jchyjun@
...
wrote:
>
> I think than reincarnation of RCHGetYahooQuotes() function will be
> useful. You can give new name e.g. RCHGetYahooInfo2017() and simplify
> replacing codes with field numbers (as in smfGetYahooPortfolioView-Example
> file). It gives SMF users significant flexibility.
>
>
field-to-field translation. However, as time goes on and people manually
convert to smfGetYahooPortfoli
need.
On Sun, Nov 12, 2017 at 6:56 AM, jchyjun@
...
wrote:
>
> I think than reincarnation of RCHGetYahooQuotes(
> useful. You can give new name e.g. RCHGetYahooInfo2017
> replacing codes with field numbers (as in smfGetYahooPortfoli
> file). It gives SMF users significant flexibility.
>
>
Sun Nov 12, 2017 9:42 am (PST) . Posted by:
JCHyjun
Firefox (ver. 52.4.0) gives me table with correct data.
Sorry I do not have working IE in PC where I use SMF. Old IE (ver. 7.0) cannot make Internet connection.
Sorry I do not have working IE in PC where I use SMF. Old IE (ver. 7.0) cannot make Internet connection.
Sun Nov 12, 2017 9:35 am (PST) . Posted by:
"Christopher Chang Sue" cchangsue
HI Randy
I am trying to pull the HIGH, LOW, Change and %Change on this website, but for some reason, I cannot get it working. The formula I am using is
=RCHGetTableCell(https://web.tmxmoney.com/quote.php?locale=en&qm_symbol=XEN,1,"High:"). Please advise on what the 4 formulas should be?
Thanks
Chris
On Saturday, November 11, 2017 9:02 PM, "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com> wrote:
<!--#yiv0771737119 #yiv0771737119ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0771737119 #yiv0771737119ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0771737119 #yiv0771737119ygrp-mkp #yiv0771737119hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0771737119 #yiv0771737119ygrp-mkp #yiv0771737119ads {margin-bottom:10px;}#yiv0771737119 #yiv0771737119ygrp-mkp .yiv0771737119ad {padding:0 0;}#yiv0771737119 #yiv0771737119ygrp-mkp .yiv0771737119ad p {margin:0;}#yiv0771737119 #yiv0771737119ygrp-mkp .yiv0771737119ad a {color:#0000ff;text-decoration:none;}#yiv0771737119 #yiv0771737119ygrp-sponsor #yiv0771737119ygrp-lc {font-family:Arial;}#yiv0771737119 #yiv0771737119ygrp-sponsor #yiv0771737119ygrp-lc #yiv0771737119hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0771737119 #yiv0771737119ygrp-sponsor #yiv0771737119ygrp-lc .yiv0771737119ad {margin-bottom:10px;padding:0 0;}--> EXCEL Stock Market Functions Add-in EXCEL Stock Market Functions Add-in Group
6 Messages
Digest #4231 1a Re: RCHGetElementNumber() For Stock Sectors [1 Attachment] by "Randy Harmelink" rharmelink 1b Re: RCHGetElementNumber() For Stock Sectors [1 Attachment] by davie_001 2a Addin Stopped Working by rtcutler 2b Re: Addin Stopped Working by "Randy Harmelink" rharmelink 3.1 Re: smfGetPortfolioView() by eremon9 4a Re: Help with smfGetYahooPortfolioView by JCHyjun
Messages
1a
Re: RCHGetElementNumber() For Stock Sectors [1 Attachment]
Sat Nov 11, 2017 10:35 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Two other items:
1. If you didn't want to see the "UR1" cell on the page, you could define
the ranged name as:
="
http://quote.morningstar.ca/QuickTakes/ETF/etf_Portfolionew.aspx?region=CAN&culture=en-CA&t=
"
...instead of:
=Sheet1!$B$2
2. Or, if you want to be really tricky, you could create the whole URL as a
ranged name. Select cell C7, then define name "rURL" as:
="
http://quote.morningstar.ca/QuickTakes/ETF/etf_Portfolionew.aspx?region=CAN&culture=en-CA&t=
"&Sheet1! C$5
..and that could be used for your URL in all formulas.
On Sat, Nov 11, 2017 at 11:11 AM, dahook@
....
wrote:
>
> You are a true wizard, and thanks for concat lesson, though have no idea
> how to turn it into a single reference. Your knowledge will greatly help in
> future usage of SMF, which is even better news.
>
>
Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^
1b
Re: RCHGetElementNumber() For Stock Sectors [1 Attachment]
Sat Nov 11, 2017 10:48 am (PST) . Posted by:
davie_001
Is there no end to your tricks?
Thanks for the hints. I'd like to see the callout, so in case the ETF call stops working for MFs, then I could define a second name and apply it to the appropriate range.
Feels like I've got a personal coach, and I'm extremely grateful and ready to press on to find other SMF tools that I can merge into my portfolio spreadsheet. I'll try not to call for help so much in future, so others can benefit from your expertise.
Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^
2a
Addin Stopped Working
Sat Nov 11, 2017 10:59 am (PST) . Posted by:
rtcutler
I have been using RCHGetYahooQuotes for a long time (years) in an Excel spreadsheet. Today it suddenly stopped working. Returns nothing. As far as I know nothing has changed recently on my machine. No new versions of anything, except of course for the Win 10 updates that keep coming silently. Does anyone have any idea what may have happened?
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^
2b
Re: Addin Stopped Working
Sat Nov 11, 2017 11:05 am (PST) . Posted by:
"Randy Harmelink" rharmelink
On 10/31, Yahoo unplugged the API that RCHGetYahooQuotes() used. See the
announcements blog for recent updates and alternatives:
https://smf-add-in.blogspot.com/
On Sat, Nov 11, 2017 at 11:59 AM, cutler@
...
wrote:
> I have been using RCHGetYahooQuotes for a long time (years) in an Excel
> spreadsheet. Today it suddenly stopped working. Returns nothing. As far
> as I know nothing has changed recently on my machine. No new versions of
> anything, except of course for the Win 10 updates that keep coming
> silently. Does anyone have any idea what may have happened?
>
>
>
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^
3.1
Re: smfGetPortfolioView()
Sat Nov 11, 2017 11:20 am (PST) . Posted by:
eremon9
Thanks for the tips, Randy. Especially the pointer to the smfUpdateDownloadTa ble macro. I'll definitely be looking into that. Reply to sender . Reply to group . Reply via Web Post . All Messages (70) . Top ^
4a
Re: Help with smfGetYahooPortfolioView
Sat Nov 11, 2017 5:37 pm (PST) . Posted by:
JCHyjun
Hi
I use SMF for awhile in quite simple way very similar to initial
borat_rules message from Nov 9 3:51 PM in this treat.
Because of Yahoo problem I downloaded latest SMF /so I have Stock Market Functions add-in, Version 2.1.2017.11. 08/ as well as the template file smfGetYahooPortfoli oView-Example. xls. I presume that smfGetYahooPortfoli oView() function is included in the latest RCH_Stock_Market_ Functions file (is it correct?)
After I reloaded MS-Excel 2003 with latest SMF (C:\SMF Add-In; Windows (32-bit) NT 5.01; 11.0; ; ; 1) I also got "--" in each active cell
Cell with =smfGetYahooPorfoli oView(" MMM" ,"15" ) produces #NAME?.
Why "--" and "#NAME" ? appears? How to get numbers?
Thank you
JCH Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^ For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF Visit Your Group
- New Members 8
• Privacy • Unsubscribe • Terms of Use
I am trying to pull the HIGH, LOW, Change and %Change on this website, but for some reason, I cannot get it working. The formula I am using is
=RCHGetTableCell(https://web.tmxmoney.com/quote.php?locale=en&qm_symbol=XEN,1,"High:"). Please advise on what the 4 formulas should be?
Thanks
Chris
On Saturday, November 11, 2017 9:02 PM, "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com> wrote:
<!--#yiv0771737119 #yiv0771737119ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0771737119 #yiv0771737119ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0771737119 #yiv0771737119ygrp-mkp #yiv0771737119hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0771737119 #yiv0771737119ygrp-mkp #yiv0771737119ads {margin-bottom:10px;}#yiv0771737119 #yiv0771737119ygrp-mkp .yiv0771737119ad {padding:0 0;}#yiv0771737119 #yiv0771737119ygrp-mkp .yiv0771737119ad p {margin:0;}#yiv0771737119 #yiv0771737119ygrp-mkp .yiv0771737119ad a {color:#0000ff;text-decoration:none;}#yiv0771737119 #yiv0771737119ygrp-sponsor #yiv0771737119ygrp-lc {font-family:Arial;}#yiv0771737119 #yiv0771737119ygrp-sponsor #yiv0771737119ygrp-lc #yiv0771737119hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0771737119 #yiv0771737119ygrp-sponsor #yiv0771737119ygrp-lc .yiv0771737119ad {margin-bottom:10px;padding:0 0;}--> EXCEL Stock Market Functions Add-in EXCEL Stock Market Functions Add-in Group
6 Messages
Digest #4231 1a Re: RCHGetElementNumber() For Stock Sectors [1 Attachment] by "Randy Harmelink" rharmelink 1b Re: RCHGetElementNumber() For Stock Sectors [1 Attachment] by davie_001 2a Addin Stopped Working by rtcutler 2b Re: Addin Stopped Working by "Randy Harmelink" rharmelink 3.1 Re: smfGetPortfolioView() by eremon9 4a Re: Help with smfGetYahooPortfolioView by JCHyjun
Messages
1a
Re: RCHGetElementNumber() For Stock Sectors [1 Attachment]
Sat Nov 11, 2017 10:35 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Two other items:
1. If you didn't want to see the "UR1" cell on the page, you could define
the ranged name as:
="
http://quote.morningstar.ca/QuickTakes/ETF/etf_Portfolionew.aspx?region=CAN&culture=en-CA&t=
"
...instead of:
=Sheet1!$B$2
2. Or, if you want to be really tricky, you could create the whole URL as a
ranged name. Select cell C7, then define name "rURL" as:
="
http://quote.morningstar.ca/QuickTakes/ETF/etf_Portfolionew.aspx?region=CAN&culture=en-CA&t=
"&Sheet1! C$5
..and that could be used for your URL in all formulas.
On Sat, Nov 11, 2017 at 11:11 AM, dahook@
....
wrote:
>
> You are a true wizard, and thanks for concat lesson, though have no idea
> how to turn it into a single reference. Your knowledge will greatly help in
> future usage of SMF, which is even better news.
>
>
Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^
1b
Re: RCHGetElementNumber() For Stock Sectors [1 Attachment]
Sat Nov 11, 2017 10:48 am (PST) . Posted by:
davie_001
Is there no end to your tricks?
Thanks for the hints. I'd like to see the callout, so in case the ETF call stops working for MFs, then I could define a second name and apply it to the appropriate range.
Feels like I've got a personal coach, and I'm extremely grateful and ready to press on to find other SMF tools that I can merge into my portfolio spreadsheet. I'll try not to call for help so much in future, so others can benefit from your expertise.
Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^
2a
Addin Stopped Working
Sat Nov 11, 2017 10:59 am (PST) . Posted by:
rtcutler
I have been using RCHGetYahooQuotes for a long time (years) in an Excel spreadsheet. Today it suddenly stopped working. Returns nothing. As far as I know nothing has changed recently on my machine. No new versions of anything, except of course for the Win 10 updates that keep coming silently. Does anyone have any idea what may have happened?
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^
2b
Re: Addin Stopped Working
Sat Nov 11, 2017 11:05 am (PST) . Posted by:
"Randy Harmelink" rharmelink
On 10/31, Yahoo unplugged the API that RCHGetYahooQuotes() used. See the
announcements blog for recent updates and alternatives:
https://smf-add-in.blogspot.com/
On Sat, Nov 11, 2017 at 11:59 AM, cutler@
...
wrote:
> I have been using RCHGetYahooQuotes for a long time (years) in an Excel
> spreadsheet. Today it suddenly stopped working. Returns nothing. As far
> as I know nothing has changed recently on my machine. No new versions of
> anything, except of course for the Win 10 updates that keep coming
> silently. Does anyone have any idea what may have happened?
>
>
>
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^
3.1
Re: smfGetPortfolioView()
Sat Nov 11, 2017 11:20 am (PST) . Posted by:
eremon9
Thanks for the tips, Randy. Especially the pointer to the smfUpdateDownloadTa ble macro. I'll definitely be looking into that. Reply to sender . Reply to group . Reply via Web Post . All Messages (70) . Top ^
4a
Re: Help with smfGetYahooPortfolioView
Sat Nov 11, 2017 5:37 pm (PST) . Posted by:
JCHyjun
Hi
I use SMF for awhile in quite simple way very similar to initial
borat_rules message from Nov 9 3:51 PM in this treat.
Because of Yahoo problem I downloaded latest SMF /so I have Stock Market Functions add-in, Version 2.1.2017.11. 08/ as well as the template file smfGetYahooPortfoli oView-Example. xls. I presume that smfGetYahooPortfoli oView() function is included in the latest RCH_Stock_Market_ Functions file (is it correct?)
After I reloaded MS-Excel 2003 with latest SMF (C:\SMF Add-In; Windows (32-bit) NT 5.01; 11.0; ; ; 1) I also got "--" in each active cell
Cell with =smfGetYahooPorfoli oView(" MMM" ,"15" ) produces #NAME?.
Why "--" and "#NAME" ? appears? How to get numbers?
Thank you
JCH Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^ For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF Visit Your Group
- New Members 8
• Privacy • Unsubscribe • Terms of Use
Sun Nov 12, 2017 9:46 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Your search term wasn't unique enough and was finding a different table
cell than you intended. Try:
=RCHGetTableCell("https://web.tmxmoney.com/quote.php?locale=en&qm_symbol=XEN
",1,">High:")
=RCHGetTableCell("https://web.tmxmoney.com/quote.php?locale=en&qm_symbol=XEN
",1,">Low:")
=smfStrExtr(smfGetTagContent("
https://web.tmxmoney.com/quote.php?locale=en&qm_symbol=XEN","div",-1,">Change:"),">
","(",1)
=smfStrExtr(smfGetTagContent("
https://web.tmxmoney.com/quote.php?locale=en&qm_symbol=XEN
","div",-1,">Change:"),"(",")",1)
P.S. In the future, please start a topic with an appropriate subject
instead of replying to a digest. And please trim your messages.
On Sun, Nov 12, 2017 at 10:31 AM, Christopher Chang Sue cchangsue@
...
wrote:
>
> I am trying to pull the HIGH, LOW, Change and %Change on this website, but
> for some reason, I cannot get it working. The formula I am using is
>
> =RCHGetTableCell(https://web.tmxmoney.com/quote.php?locale=
> en&qm_symbol=XEN,1,"High:"). Please advise on what the 4 formulas should
> be?
>
>
>
cell than you intended. Try:
=RCHGetTableCell("https://web.tmxmoney.com/quote.php?locale=en&qm_symbol=XEN
",1,">High:")
=RCHGetTableCell("https://web.tmxmoney.com/quote.php?locale=en&qm_symbol=XEN
",1,">Low:")
=smfStrExtr(smfGetTagContent("
https://web.tmxmoney.com/quote.php?locale=en&qm_symbol=XEN","div",-1,">Change:"),">
","(",1)
=smfStrExtr(smfGetTagContent("
https://web.tmxmoney.com/quote.php?locale=en&qm_symbol=XEN
","div",-1,">Change:"),"(",")",1)
P.S. In the future, please start a topic with an appropriate subject
instead of replying to a digest. And please trim your messages.
On Sun, Nov 12, 2017 at 10:31 AM, Christopher Chang Sue cchangsue@
...
wrote:
>
> I am trying to pull the HIGH, LOW, Change and %Change on this website, but
> for some reason, I cannot get it working. The formula I am using is
>
> =RCHGetTableCell(https://web.tmxmoney.com/quote.php?locale=
> en&qm_symbol=
> be?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar