15 Messages
Digest #4329
1a
Re: ='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RC by "Randy Harmelink" rharmelink
Messages
Fri May 4, 2018 11:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmm. You must have changed the location of the add-in?
I stopped using the "Edit Links" option in EXCEL because I didn't find it
to be a reliable way to re-establish add-in links.
I always run the smfFixLinks macro when I have unresolved links like that.
I have it attached to a button, but it's also on the SMF context menu. And
you can always run it via the macro dialog (alt+F8), but you need to enter
the name yoursef.
On Fri, May 4, 2018 at 11:04 AM, rr76012@
...
wrote:
>
> I changed the smf-addin to the latest Version.
> now all my excel files have this in the cells:
>
> cells " ='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!
> RCHGetElementNumber(Ticker,624)"
>
> I tried to go to excel -> Data -> Edit Links -> Change Source -> This
> PC-OS(C): Program Files - SMF Add-in
> then clicked "RCH_STock_MarketFunctions.xla
>
> What am I doing wrong?
>
>
>
I stopped using the "Edit Links" option in EXCEL because I didn't find it
to be a reliable way to re-establish add-in links.
I always run the smfFixLinks macro when I have unresolved links like that.
I have it attached to a button, but it's also on the SMF context menu. And
you can always run it via the macro dialog (alt+F8), but you need to enter
the name yoursef.
On Fri, May 4, 2018 at 11:04 AM, rr76012@
...
wrote:
>
> I changed the smf-addin to the latest Version.
> now all my excel files have this in the cells:
>
> cells " ='C:\
> RCHGetElementNumber
>
> I tried to go to excel -> Data -> Edit Links -> Change Source -> This
> PC-OS(C): Program Files - SMF Add-in
> then clicked "RCH_STock_
>
> What am I doing wrong?
>
>
>
Fri May 4, 2018 12:49 pm (PDT) . Posted by:
"mlazarus"
Hi Randy,
Thanks. That worked like a charm. For the archives, here is the
syntax for an individual cell:
=smfGetYahooPortfolioView( $A5, "03" ), where the "03" refers to the
name field.
The function also supports a range of cells.
On 5/4/2018 1:21 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> The best way to get a number of them would be to use
> smfGetYahooPortfolioView().
>
> On Fri, May 4, 2018 at 9:03 AM, mlazarus mlazarus@
> ...
> wrote:
>
> What function and parameters do I use to retrieve the name of the
> stock? TIA.
>
>
> ----------------------------------------------------------
> Posted by: Randy Harmelink <rharmelink@gmail.com>
> ----------------------------------------------------------
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/34859;_ylc=X3oDMTJycjk0dDU0BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMzNDg1OQRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE1MjU0NTQ0OTY-?act=reply&messageNum=34859>
>
>
>
>
>
>
>
>
>
> _
Thanks. That worked like a charm. For the archives, here is the
syntax for an individual cell:
=smfGetYahooPortfolioView( $A5, "03" ), where the "03" refers to the
name field.
The function also supports a range of cells.
On 5/4/2018 1:21 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> The best way to get a number of them would be to use
> smfGetYahooPortfolioView().
>
> On Fri, May 4, 2018 at 9:03 AM, mlazarus mlazarus@
> ...
> wrote:
>
> What function and parameters do I use to retrieve the name of the
> stock? TIA.
>
>
> ----------------------------------------------------------
> Posted by: Randy Harmelink <rharmelink@gmail.com>
> ----------------------------------------------------------
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/34859;_ylc=X3oDMTJycjk0dDU0BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMzNDg1OQRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE1MjU0NTQ0OTY-?act=reply&messageNum=34859>
>
>
>
>
>
>
>
>
>
> _
Fri May 4, 2018 1:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Please do NOT use individual calls if you're getting a number of them.
On Fri, May 4, 2018 at 12:49 PM, mlazarus mlazarus@
...
wrote:
>
> Thanks. That worked like a charm. For the archives, here is the syntax
> for an individual cell:
> =smfGetYahooPortfolioView( $A5, "03" ), where the "03" refers to the name
> field.
>
> The function also supports a range of cells.
>
>
On Fri, May 4, 2018 at 12:49 PM, mlazarus mlazarus@
...
wrote:
>
> Thanks. That worked like a charm. For the archives, here is the syntax
> for an individual cell:
> =smfGetYahooPortfol
> field.
>
> The function also supports a range of cells.
>
>
Sat May 5, 2018 8:09 pm (PDT) . Posted by:
"mlazarus"
Hi Randy,
My formula is: =smfGetYahooPortfolioView( $A5:$A20, "03" ), entered as
an array formula. Whenever there is an identical ticker symbol the
formula returns a double dash ("--"). Is there a way for the formula to
return the name again?
-mark
On 5/4/2018 4:03 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> Please do NOT use individual calls if you're getting a number of them.
>
> On Fri, May 4, 2018 at 12:49 PM, mlazarus mlazarus@
> ...
> wrote:
>
>
> Thanks. That worked like a charm. For the archives, here is the
> syntax for an individual cell:
> =smfGetYahooPortfolioView( $A5, "03" ), where the "03" refers to
> the name field.
>
> The function also supports a range of cells.
>
>
> ----------------------------------------------------------
> Posted by: Randy Harmelink <rharmelink@gmail.com>
> ----------------------------------------------------------
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/34870;_ylc=X3oDMTJydnFydGEzBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMzNDg3MARzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE1MjU0NjQyMTI-?act=reply&messageNum=34870>
>
>
>
>
>
>
>
>
>
> _,_._,___
My formula is: =smfGetYahooPortfolioView( $A5:$A20, "03" ), entered as
an array formula. Whenever there is an identical ticker symbol the
formula returns a double dash ("--"). Is there a way for the formula to
return the name again?
-mark
On 5/4/2018 4:03 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> Please do NOT use individual calls if you're getting a number of them.
>
> On Fri, May 4, 2018 at 12:49 PM, mlazarus mlazarus@
> ...
> wrote:
>
>
> Thanks. That worked like a charm. For the archives, here is the
> syntax for an individual cell:
> =smfGetYahooPortfolioView( $A5, "03" ), where the "03" refers to
> the name field.
>
> The function also supports a range of cells.
>
>
> ----------------------------------------------------------
> Posted by: Randy Harmelink <rharmelink@gmail.com>
> ----------------------------------------------------------
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/34870;_ylc=X3oDMTJydnFydGEzBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMzNDg3MARzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE1MjU0NjQyMTI-?act=reply&messageNum=34870>
>
>
>
>
>
>
>
>
>
> _,_._,___
Sat May 5, 2018 8:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you want to use the same ticker more than once, you need to specify "Y"
for the 3rd parameter. It requires additional overhead processing, so the
default is not to do it.
On Sat, May 5, 2018 at 8:09 PM, mlazarus mlazarus@
...
wrote:
>
> My formula is: =smfGetYahooPortfolioView( $A5:$A20, "03" ), entered as an
> array formula. Whenever there is an identical ticker symbol the formula
> returns a double dash ("--"). Is there a way for the formula to return the
> name again?
>
>
for the 3rd parameter. It requires additional overhead processing, so the
default is not to do it.
On Sat, May 5, 2018 at 8:09 PM, mlazarus mlazarus@
...
wrote:
>
> My formula is: =smfGetYahooPortfol
> array formula. Whenever there is an identical ticker symbol the formula
> returns a double dash ("--"
> name again?
>
>
Sat May 5, 2018 12:00 am (PDT) . Posted by:
bluff_master2cool
Hi Randy,
I am new to your world of excel add-in and firstly would like to thank you for creating a masterpiece
I maintain a portfolio in India and hence was thinking to calculate a risk based matrix for it. Would be very helpful if you can share how one can fetch prices for different stocks across various global stock exchanges .
Thanks
Rohit
I am new to your world of excel add-in and firstly would like to thank you for creating a masterpiece
I maintain a portfolio in India and hence was thinking to calculate a risk based matrix for it. Would be very helpful if you can share how one can fetch prices for different stocks across various global stock exchanges .
Thanks
Rohit
Sat May 5, 2018 12:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If Yahoo carries the data, you should be able to use
smfGetYahooPortfolioView() using the Yahoo ticker symbol.
On Fri, May 4, 2018 at 11:21 PM, potter.rohit@
...
wrote:
>
> I am new to your world of excel add-in and firstly would like to thank you
> for creating a masterpiece
>
> I maintain a portfolio in India and hence was thinking to calculate a risk
> based matrix for it. Would be very helpful if you can share how one can
> fetch prices for different stocks across various global stock exchanges .
>
>
smfGetYahooPortfoli
On Fri, May 4, 2018 at 11:21 PM, potter.rohit@
...
wrote:
>
> I am new to your world of excel add-in and firstly would like to thank you
> for creating a masterpiece
>
> I maintain a portfolio in India and hence was thinking to calculate a risk
> based matrix for it. Would be very helpful if you can share how one can
> fetch prices for different stocks across various global stock exchanges .
>
>
Sat May 5, 2018 8:06 am (PDT) . Posted by:
marion_stuchlik
Hello Randy,
I would like to get the history of data prices of an Index, its ticker is ^SP500-55. But this ticker doens't give any prices when I use the function RCHGetYahooHistory. How can I do to have the historic price data from the function?
Thank you in advance,
Marion
I would like to get the history of data prices of an Index, its ticker is ^SP500-55. But this ticker doens't give any prices when I use the function RCHGetYahooHistory. How can I do to have the historic price data from the function?
Thank you in advance,
Marion
Sat May 5, 2018 8:35 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Since Yahoo doesn't carry the history, there's nothing that can be done to
get the RCHGetYahooHistory() function to return the historical quotes.
You'd have to find a different source of the data....
Can you use the XLU ETF?
On Sat, May 5, 2018 at 8:06 AM, marion_stuchlik@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I would like to get the history of data prices of an Index, its ticker is
> ^SP500-55. But this ticker doens't give any prices when I use the function
> RCHGetYahooHistory. How can I do to have the historic price data from the
> function?
>
>
>
get the RCHGetYahooHistory() function to return the historical quotes.
You'd have to find a different source of the data....
Can you use the XLU ETF?
On Sat, May 5, 2018 at 8:06 AM, marion_stuchlik@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I would like to get the history of data prices of an Index, its ticker is
> ^SP500-55. But this ticker doens't give any prices when I use the function
> RCHGetYahooHistory. How can I do to have the historic price data from the
> function?
>
>
>
Sat May 5, 2018 12:35 pm (PDT) . Posted by:
"Marion Stuchlik" marion_stuchlik
Thank you for your answer. No, I cannot use XLU ETF...
Le samedi 5 mai 2018 à 17:35:42 UTC+2, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> a écrit :
Since Yahoo doesn't carry the history, there's nothing that can be done to get the RCHGetYahooHistory() function to return the historical quotes.
You'd have to find a different source of the data....
Can you use the XLU ETF?
On Sat, May 5, 2018 at 8:06 AM, marion_stuchlik@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I would like to get the history of data prices of an Index, its ticker is ^SP500-55. But this ticker doens't give any prices when I use the function RCHGetYahooHistory. How can I do to have the historic price data from the function?
Le samedi 5 mai 2018 à 17:35:42 UTC+2, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> a écrit :
Since Yahoo doesn't carry the history, there's nothing that can be done to get the RCHGetYahooHistory() function to return the historical quotes.
You'd have to find a different source of the data....
Can you use the XLU ETF?
On Sat, May 5, 2018 at 8:06 AM, marion_stuchlik@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I would like to get the history of data prices of an Index, its ticker is ^SP500-55. But this ticker doens't give any prices when I use the function RCHGetYahooHistory. How can I do to have the historic price data from the function?
Sat May 5, 2018 9:14 am (PDT) . Posted by:
ranger_emmett
Need a little help here please. It has been a very long time since I used any of this stuff.
I entered the tickers down A column from 2 thru 213, I entered "o" "h" "l1" along row 1, then in cell B2 I entered "=RCGGetYahooQuotes(A2:A213, B1:M1)" and all I got was the RCH code in each and every cell.
I have the smf folder on my hard drive but I think I need to point this sheet to that folder and I can't remember how to do that. Could someone please take the time to walk me through this?
I entered the tickers down A column from 2 thru 213, I entered "o" "h" "l1" along row 1, then in cell B2 I entered "=RCGGetYahooQ
I have the smf folder on my hard drive but I think I need to point this sheet to that folder and I can't remember how to do that. Could someone please take the time to walk me through this?
Sat May 5, 2018 9:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
RCHGetYahooQuotes() is now dead. Yahoo unplugged the API that fed it back
in October.
You'll need to install the latest version of the add-in to get the
replacement -- smfGetYahooPortfolioView(). Documentation and template are
on the website.
On Sat, May 5, 2018 at 9:11 AM, ranger_emmett@
...
wrote:
>
> Need a little help here please. It has been a very long time since I used
> any of this stuff.
>
> I entered the tickers down A column from 2 thru 213, I entered "o" "h"
> "l1" along row 1, then in cell B2 I entered "=RCGGetYahooQuotes(A2:A213,
> B1:M1)" and all I got was the RCH code in each and every cell.
>
> I have the smf folder on my hard drive but I think I need to point this
> sheet to that folder and I can't remember how to do that. Could someone
> please take the time to walk me through this?
>
>
in October.
You'll need to install the latest version of the add-in to get the
replacement -- smfGetYahooPortfoli
on the website.
On Sat, May 5, 2018 at 9:11 AM, ranger_emmett@
...
wrote:
>
> Need a little help here please. It has been a very long time since I used
> any of this stuff.
>
> I entered the tickers down A column from 2 thru 213, I entered "o" "h"
> "l1" along row 1, then in cell B2 I entered "=RCGGetYahooQ
> B1:M1)" and all I got was the RCH code in each and every cell.
>
> I have the smf folder on my hard drive but I think I need to point this
> sheet to that folder and I can't remember how to do that. Could someone
> please take the time to walk me through this?
>
>
Sat May 5, 2018 12:15 pm (PDT) . Posted by:
reacher_14
Hi
I you will need to update the SMF_Addin, Also you may find that you have to delete the folder first as I found out when I double checked what had installed it was still the old addin
I you will need to update the SMF_Addin, Also you may find that you have to delete the folder first as I found out when I double checked what had installed it was still the old addin
Sun May 6, 2018 10:10 am (PDT) . Posted by:
kivikatz
Hi All. I just started using the add-in after a long hiatus. It looks like the add-in installed properly, but I get "Undefined" when I enter formulas.
For instance, =RCHGetElementNumber($B$4,595).
I know I must be doing something wrong. Can anyone help me? Thank you.
For instance, =RCHGetElementNumbe
I know I must be doing something wrong. Can anyone help me? Thank you.
Sun May 6, 2018 11:05 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
"Undefined" usually means you didn't follow the installation instruction of
"Extract *ALL* files from the ZIP archive into the folder you just created."
The element definitions are in the "smf-elements-*.txt" files and are
loaded when you first use the RCHGetElementNumber() function. If they don't
exist in the same folder as the XLA file, all elements will be "Undefined".
On Sun, May 6, 2018 at 10:10 AM, kivikatz@
...
wrote:
> Hi All. I just started using the add-in after a long hiatus. It looks
> like the add-in installed properly, but I get "Undefined" when I enter
> formulas.
>
> For instance, =
>
> RCHGetElementNumber($B$4,595).
>
> I know I must be doing something wrong. Can anyone help me? Thank you.
>
>
>
"Extract *ALL* files from the ZIP archive into the folder you just created."
The element definitions are in the "smf-elements-
loaded when you first use the RCHGetElementNumber
exist in the same folder as the XLA file, all elements will be "Undefined&quo
On Sun, May 6, 2018 at 10:10 AM, kivikatz@
...
wrote:
> Hi All. I just started using the add-in after a long hiatus. It looks
> like the add-in installed properly, but I get "Undefined&quo
> formulas.
>
> For instance, =
>
> RCHGetElementNumber
>
> I know I must be doing something wrong. Can anyone help me? Thank you.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar