6 Messages
Digest #4231
Messages
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.
>
>
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!
..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.
>
>
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.
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.
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?
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?
>
>
>
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?
>
>
>
Sat Nov 11, 2017 11:20 am (PST) . Posted by:
eremon9
Thanks for the tips, Randy. Especially the pointer to the smfUpdateDownloadTable macro. I'll definitely be looking into that.
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 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?
Thank you
JCH
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.
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 "--"
Thank you
JCH
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar