15 Messages
Digest #4220
7b
Re: smfGetYahooPortfolioView; Output of Field Numbers 58,61,65,68,72 by "Randy Harmelink" rharmelink
Messages
Tue Nov 7, 2017 10:37 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The RCHGetYahooQuotes() function is dead, at least for now. If I do
"resurrect" it, it would just invoke smfGetYahooPortfolioView() anyway.
There are three ways to run smfFixLinks macro from the add-in:
1. Assign the macro to a button on your Quick Access Toolbar. A quick
Google search can find plenty of examples.
2. Use the macro dialog (alt+F8), type in the macro name, and click on the
"Run" button when it activates.
3. Use the context menu (right mouse click on a cell), choose "SMF" and
then "Fix Links".
On Tue, Nov 7, 2017 at 6:39 PM, wayne-moore@
...
wrote:
> I do not know how to run the smfFixLinks macro, so I need something that
> describes how to do that. I have the current and past SMF folders in the
> C:/SMF Add-In directory and the "1000 InputTickers" and the
> "smfGetPortfolioView" example SS in a separate folder in Dropbox. I suspect
> there are very specific requirements and settings needed but I do not know
> what they are to get to a working SS again. PS. If it gets set up correctly
> / my issues resolved, should I then be able to use the "1000 InputTickers"
> SS or only the smfGetPortfolio example?
>
>
>
"resurrect&quo
There are three ways to run smfFixLinks macro from the add-in:
1. Assign the macro to a button on your Quick Access Toolbar. A quick
Google search can find plenty of examples.
2. Use the macro dialog (alt+F8), type in the macro name, and click on the
"Run" button when it activates.
3. Use the context menu (right mouse click on a cell), choose "SMF" and
then "Fix Links".
On Tue, Nov 7, 2017 at 6:39 PM, wayne-moore@
...
wrote:
> I do not know how to run the smfFixLinks macro, so I need something that
> describes how to do that. I have the current and past SMF folders in the
> C:/SMF Add-In directory and the "1000 InputTickers" and the
> "smfGetPortfol
> there are very specific requirements and settings needed but I do not know
> what they are to get to a working SS again. PS. If it gets set up correctly
> / my issues resolved, should I then be able to use the "1000 InputTickers"
> SS or only the smfGetPortfolio example?
>
>
>
Tue Nov 7, 2017 10:38 pm (PST) . Posted by:
zbgb952
Randy,
Can you show me the correct RCHGetTableCell function to use to get the current price of a stock from this finviz.com website (in this case for ticker symbol BTI ):
https://finviz.com/quote.ashx?t=bti https://finviz.com/quote.ashx?t=bti
The value I want would be for 'price' which is right under 'prev close'...in the group of values
under the graph
I am trying to use this function instead of that Yahoo function that no longer works.
Thanks
Can you show me the correct RCHGetTableCell function to use to get the current price of a stock from this finviz.com website (in this case for ticker symbol BTI ):
https://finviz.com/quote.ashx?t=bti https://finviz.com/quote.ashx?t=bti
The value I want would be for 'price&#
under the graph
I am trying to use this function instead of that Yahoo function that no longer works.
Thanks
Tue Nov 7, 2017 11:00 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
This should do it:
=smfGetTagContent("https://finviz.com/quote.ashx?t=bti
","td",1,">Price",,,,1)
Getting them one at a time is a very inefficient way to get them, and a
waste of resources. I hope you only plan to do a few.
On Tue, Nov 7, 2017 at 11:38 PM, mb0329@
...
wrote:
>
> Can you show me the correct RCHGetTableCell function to use to get the
> current price of a stock from this finviz.com website (in this case for
> ticker symbol BTI ):
>
> https://finviz.com/quote.ashx?t=bti
>
> The value I want would be for 'price' which is right under 'prev
> close'...in the group of values
> under the graph
>
> I am trying to use this function instead of that Yahoo function that no
> longer works.
>
>
=smfGetTagContent("https://finviz.com/quote.ashx?t=bti
","td",1,">Price",,,,1)
Getting them one at a time is a very inefficient way to get them, and a
waste of resources. I hope you only plan to do a few.
On Tue, Nov 7, 2017 at 11:38 PM, mb0329@
...
wrote:
>
> Can you show me the correct RCHGetTableCell function to use to get the
> current price of a stock from this finviz.com website (in this case for
> ticker symbol BTI ):
>
> https://finviz.com/quote.ashx?t=bti
>
> The value I want would be for 'price&#
> close'..
> under the graph
>
> I am trying to use this function instead of that Yahoo function that no
> longer works.
>
>
Wed Nov 8, 2017 7:32 am (PST) . Posted by:
"Frank kirk" nautilustech
Getting them one at a time is a very inefficient way to get them, and a waste of resources. I hope you only plan to do a few.
Randy, What's your definition of "a few"? ☺
Visit Your Group
- New Members 14
• Privacy • Unsubscribe • Terms of Use
#yiv4481204063 #yiv4481204063 -- #yiv4481204063 .yiv4481204063ygrp-
Wed Nov 8, 2017 7:51 am (PST) . Posted by:
"Randy Harmelink" rharmelink
10 or less.
On Wed, Nov 8, 2017 at 8:32 AM, Frank kirk nautilustech@
...
wrote:
> Getting them one at a time is a very inefficient way to get them, and a
> waste of resources. I hope you only plan to do a few.
>
> Randy,
> What's your definition of "a few"? ☺
>
>
On Wed, Nov 8, 2017 at 8:32 AM, Frank kirk nautilustech@
...
wrote:
> Getting them one at a time is a very inefficient way to get them, and a
> waste of resources. I hope you only plan to do a few.
>
> Randy,
> What's your definition of "a few"? ☺
>
>
Wed Nov 8, 2017 8:16 am (PST) . Posted by:
lexstar
Can anyone point me to the documentation for smfGetPortfolioView()?
I only see the sample template only.
I can't find it anywhere on ogres-crypt.com/SMF/Documentation/
Thanks in advance.
I only see the sample template only.
I can't find it anywhere on ogres-crypt.
Thanks in advance.
Wed Nov 8, 2017 10:23 am (PST) . Posted by:
marquiskissel
Randy, When I skip a line in my ticker list or when I have an incorrect ticker, the new smfGetYahooPortfolioView does not put dashes or NAMES or anything in its cell and instead skips it so that my tickers and prices in the cells below no longer are on the correct rows...for example in the EXAMPLE sheet you provided for the function, the WZ17.CBT data is in row 10 instead of row 16...how can I correct this?
Thanks so much!
Thanks so much!
Attachment(s) from
1 of 1 Photo(s)
Wed Nov 8, 2017 10:34 am (PST) . Posted by:
"Randy Harmelink" rharmelink
To fix your issues, update to version 2017.11.04 of the add-in. They were
all part of that update
=RCHGetElementNumber("Version")
On Wed, Nov 8, 2017 at 10:16 AM, marquiskissel@
...
wrote:
>
> Randy, When I skip a line in my ticker list or when I have an incorrect
> ticker, the new smfGetYahooPortfolioView does not put dashes or NAMES or
> anything in its cell and instead skips it so that my tickers and prices in
> the cells below no longer are on the correct rows...for example in the
> EXAMPLE sheet you provided for the function, the WZ17.CBT data is in row 10
> instead of row 16...how can I correct this?
>
>
>
all part of that update
=RCHGetElementNumbe
On Wed, Nov 8, 2017 at 10:16 AM, marquiskissel@
...
wrote:
>
> Randy, When I skip a line in my ticker list or when I have an incorrect
> ticker, the new smfGetYahooPortfoli
> anything in its cell and instead skips it so that my tickers and prices in
> the cells below no longer are on the correct rows...for example in the
> EXAMPLE sheet you provided for the function, the WZ17.CBT data is in row 10
> instead of row 16...how can I correct this?
>
>
>
Wed Nov 8, 2017 11:35 am (PST) . Posted by:
"Randy Harmelink" rharmelink
FYI -- The sWebCache processing should be fixed on the next release. As
written, it was always replacing the first slot's web page. That might wipe
out another web page being used for a different calculation. The range
selection updating should also work for multiple SMF functions now as well.
*But with the next release, you'll need to reset sWebCache to "Y" at the
end of your subroutine in order for it to continue working properly.*
The recalculation subroutine now looks like this:
Private Sub smfMenuRecalculateSelection()
' Disable the cache and recalculate the selected range
sWebCache = "N"
Selection.Dirty
On Error Resume Next
Selection.Calculate
sWebCache = "Y"
End Sub
...and that is the only place the sWebCache now gets set back to "Y".
On Tue, Nov 7, 2017 at 10:22 AM, tamurphy@cableone.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm using the 2017.11.04 version.
>
> Re: WFCPL, The problem is that the last trade date I'm getting is
> 09/26/17, and the corresponding price is, as you show, $1321. That price is
> incorrect for the last trade date as of today. The dates and prices for
> other tickers appear to be correct.
>
> Re: BRK-B Book, I believe for all other tickers Item #41 returns
> Book/Share, whereas for BRK it returns total Book value. For example, WMT
> shows as 25.52 both here and when using smfGetElement, whereas BRK-B shows
> 182767 when using GetPortfolioView and 121.84 when using GetElement.
>
> Re: selectively recalculating a smfGetPortfolioValue array without using
> smfForceRecalculation. I've managed to make this work by creating a public
> procedure that does essentially what your private procedure smfMenuRecalculateSelection()
> does. The only difference is that it refers to a named range [pvTblData]
> rather than to a selection...
>
> Public Sub RecalcPortView()
> sWebCache = "N" ' this is a SMF public variable
> With [pvTblData]
> .Dirty
> .Calculate
> End With
> End Sub
>
> According to the Time item, smfGetPortfolioView is now retrieving
> practically real-time quotes in a fraction of the time previously required
> using smfGetYahooQuotes.
>
> Thanks again for your most valuable assistance over so many years, Randy.
> My Portfolio Manager is heavily dependent upon the fine utilities you've
> created.
>
written, it was always replacing the first slot's web page. That might wipe
out another web page being used for a different calculation. The range
selection updating should also work for multiple SMF functions now as well.
*But with the next release, you'll need to reset sWebCache to "Y" at the
end of your subroutine in order for it to continue working properly.*
The recalculation subroutine now looks like this:
Private Sub smfMenuRecalculateSelection()
' Disable the cache and recalculate the selected range
sWebCache = "N"
Selection.Dirty
On Error Resume Next
Selection.Calculate
sWebCache = "Y"
End Sub
...and that is the only place the sWebCache now gets set back to "Y".
On Tue, Nov 7, 2017 at 10:22 AM, tamurphy@cableone.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm using the 2017.11.04 version.
>
> Re: WFCPL, The problem is that the last trade date I'm getting is
> 09/26/17, and the corresponding price is, as you show, $1321. That price is
> incorrect for the last trade date as of today. The dates and prices for
> other tickers appear to be correct.
>
> Re: BRK-B Book, I believe for all other tickers Item #41 returns
> Book/Share, whereas for BRK it returns total Book value. For example, WMT
> shows as 25.52 both here and when using smfGetElement, whereas BRK-B shows
> 182767 when using GetPortfolioView and 121.84 when using GetElement.
>
> Re: selectively recalculating a smfGetPortfolioValu
> smfForceRecalculati
> procedure that does essentially what your private procedure smfMenuRecalculateS
> does. The only difference is that it refers to a named range [pvTblData]
> rather than to a selection...
>
> Public Sub RecalcPortView(
> sWebCache = "N" ' this is a SMF public variable
> With [pvTblData]
> .Dirty
> .Calculate
> End With
> End Sub
>
> According to the Time item, smfGetPortfolioView is now retrieving
> practically real-time quotes in a fraction of the time previously required
> using smfGetYahooQuotes.
>
> Thanks again for your most valuable assistance over so many years, Randy.
> My Portfolio Manager is heavily dependent upon the fine utilities you've
> created.
>
Wed Nov 8, 2017 10:26 am (PST) . Posted by:
john_hoel
Your tool is a winner. It is very easy to use and lightning fast. Many thanks for sharing.
Wed Nov 8, 2017 11:30 am (PST) . Posted by:
"Jim Morlock" kagawonger
Here are a couple of alternate free tools for obtaining historical stock price quotes:
www.yloader.com <http://www.yloader.com>
https://api.tiingo.com/
Randy,
I don't know how you keep up with the ongoing development, maintenance, and Q&A for your fabulous SMF add-in tool, but your work is most impressive and greatly appreciated. Many thanks for sharing your add-in and for your unselfish and ongoing contributions to help others make it work.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, November 3, 2017 1:15 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo Finance API appears to be gone
This has been the topic of the last few hundred messages on the Yahoo group. :)
See the recent announcements on the blog:
https://smf-add-in.blogspot.com/
If you know of a suitable replacement source, I'm all ears? At this point, the most viable alternatives I've seen are to create watch lists or portfolios on other services, and export the data (usually manually).
On Fri, Nov 3, 2017 at 5:46 AM, timbowers23@
...
wrote:
Within the last few days RCHGetYahooQuotes stopped returning data. Today after some finagling I got this message:
Yahoo! - 403 Forbidden -- error 403
It has come to our attention that this service is being used in violation of the Yahoo Terms of Service. As such, the service is being discontinued. For all future markets and equities data research, please refer to finance.yahoo.com <http://finance.yahoo.com> .
Appears to be time to try some other avenue for stock and mutual fund quotes. Does anybody have any suggestions?
Wed Nov 8, 2017 12:20 pm (PST) . Posted by:
"Marco Deen" marco.deen
Thanks, nearly had that but missed one " .
On Tue, Nov 7, 2017 at 4:50 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Just the plain old EXCEL concatenation:
>
> =smfGetTagContent("http://quotes.morningstar.com/stockq/c-header?t=
> "&B5,"div",-1,"vkey=""LastPrice""",,,,1)
>
> On Tue, Nov 7, 2017 at 2:45 PM, Marco Deen marco.deen@
> ...
> wrote:
>
>>
>> =
>>
>> smfGetTagContent("http://quotes.morningstar.com/stockq/c-header?t=MMM
>> ","div",-1,"vkey=""LastPrice""",,,,1)
>>
>> How would I use this formula if I want it to refer to cell A1?
>>
>>
>>
>
On Tue, Nov 7, 2017 at 4:50 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Just the plain old EXCEL concatenation:
>
> =smfGetTagContent("http://quotes.morningstar.com/stockq/c-header?t=
> "&B5,"div",-1,"vkey=""LastPrice""",,,,1)
>
> On Tue, Nov 7, 2017 at 2:45 PM, Marco Deen marco.deen@
> ...
> wrote:
>
>>
>> =
>>
>> smfGetTagContent("http://quotes.morningstar.com/stockq/c-header?t=MMM
>> ","
>>
>> How would I use this formula if I want it to refer to cell A1?
>>
>>
>>
>
Wed Nov 8, 2017 2:23 pm (PST) . Posted by:
alberto.ratti
Great job, Randy!
Up to me (see attached excerpt), the output of the the following Field Numbers:
58
61
65
68
72
76
should be multiplied by 100.
Or, the function, before to output the result, should avoid dividing by 100.
Thanks, once more!
Alberto
Up to me (see attached excerpt), the output of the the following Field Numbers:
58
61
65
68
72
76
should be multiplied by 100.
Or, the function, before to output the result, should avoid dividing by 100.
Thanks, once more!
Alberto
Wed Nov 8, 2017 2:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
For version 2017.11.08:
-- I agree that the division by 100 on 58, 61, 65, and 68 should be backed
out.
-- But 72 and 76 look fine to me?
That's what I get for assuming all percentage fields would be treated the
same. *sigh*
New release for tomorrow, pending additional changes. Sorry about that.
On Wed, Nov 8, 2017 at 3:23 PM, alberto.ratti@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Great job, Randy!
>
> Up to me (see attached excerpt), the output of the the following Field
> Numbers:
>
> 58
>
> 61
>
> 65
>
> 68
>
> 72
>
> 76
>
> should be multiplied by 100.
>
> Or, the function, before to output the result, should avoid dividing by
> 100.
>
>
>
-- I agree that the division by 100 on 58, 61, 65, and 68 should be backed
out.
-- But 72 and 76 look fine to me?
That's what I get for assuming all percentage fields would be treated the
same. *sigh*
New release for tomorrow, pending additional changes. Sorry about that.
On Wed, Nov 8, 2017 at 3:23 PM, alberto.ratti@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Great job, Randy!
>
> Up to me (see attached excerpt), the output of the the following Field
> Numbers:
>
> 58
>
> 61
>
> 65
>
> 68
>
> 72
>
> 76
>
> should be multiplied by 100.
>
> Or, the function, before to output the result, should avoid dividing by
> 100.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar