15 Messages
Digest #4078
Messages
Mon Jul 3, 2017 9:11 am (PDT) . Posted by:
"Leo Bueno" leobueno
Here is what I am using. None work anymore (worked a couple of weeks ago). I just installed the latest version of the AddIn, but that did not help.
Stock price
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A8,"l1")
Bond yield
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("^TYX","l1")
Euro to Dollar
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes($A33&B$29&"=X","l1")
=========
Leo Bueno
=========
From: Leo Bueno
Sent: Monday, July 03, 2017 12:03 PM
To: smf_addin@yahoogroups.com
Subject: Stock price data source other than Yahoo
I need simple information for some stocks: current price (and name to make sure I have the right stock's price).
I keep having problems with the SMFAddIn getting the data from Yahoo.
Is there another data site that is more compatible with the SMFAddIn?
While we are at it, I also need the current 30-year treasury yield.
Thanks in advance for your assistance.
=========
Leo Bueno
=========
Stock price
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A8,"l1")
Bond yield
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("^TYX","l1")
Euro to Dollar
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes($A33&B$29&"=X","l1")
=========
Leo Bueno
=========
From: Leo Bueno
Sent: Monday, July 03, 2017 12:03 PM
To: smf_addin@yahoogroups.com
Subject: Stock price data source other than Yahoo
I need simple information for some stocks: current price (and name to make sure I have the right stock's price).
I keep having problems with the SMFAddIn getting the data from Yahoo.
Is there another data site that is more compatible with the SMFAddIn?
While we are at it, I also need the current 30-year treasury yield.
Thanks in advance for your assistance.
=========
Leo Bueno
=========
Mon Jul 3, 2017 9:17 am (PDT) . Posted by:
"Leo Bueno" leobueno
I need simple information for some stocks: current price (and name to make sure I have the right stock's price).
I keep having problems with the SMFAddIn getting the data from Yahoo.
Is there another data site that is more compatible with the SMFAddIn?
While we are at it, I also need the current 30-year treasury yield.
Thanks in advance for your assistance.
=========
Leo Bueno
=========
Mon Jul 3, 2017 9:36 am (PDT) . Posted by:
"Leo Bueno" leobueno
I need simple information for some stocks: current price (and name to make sure I have the right stock's price).
I keep having problems with the SMFAddIn getting the data from Yahoo.
Is there another data site that is more compatible with the SMFAddIn?
While we are at it, I also need the current 30-year treasury yield.
Thanks in advance for your assistance.
=========
Leo Bueno
=========
I keep having problems with the SMFAddIn getting the data from Yahoo.
Is there another data site that is more compatible with the SMFAddIn?
While we are at it, I also need the current 30-year treasury yield.
Thanks in advance for your assistance.
=========
Leo Bueno
=========
Mon Jul 3, 2017 9:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You have location errors. The path in front of your function invocation
means that EXCEL couldn't find the add-in in that location, so it tags
those items as "unresolved links". EXCEL should have given you a warning
when you opened he workbook. This would have happened with ANY add-in
function, because when you save a workbook, EXCEL hard-codes the location
of the add-in. If it's not there when you next open the workbook,
unresolved links occur.
Did you install the add-in into a different location? Or move the add-in?
In any case, all you should need to do is run the smfFixLinks macro. It
will remove those hard-coded paths and force EXCEL to use the add-in
functions from the current location of the add-in that is defined by the
add-in manager.
On Mon, Jul 3, 2017 at 9:11 AM, Leo Bueno Leo@
...
wrote:
>
> Here is what I am using*. None* work anymore (worked a couple of weeks
> ago). I just installed the latest version of the AddIn, but that did not
> help.
>
>
>
> Stock price
>
> ='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A8,"l1")
>
>
>
> Bond yield
>
> ='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!
> RCHGetYahooQuotes("^TYX","l1")
>
>
>
> Euro to Dollar
>
> ='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!
> RCHGetYahooQuotes($A33&B$29&"=X","l1")
>
>
>
>
>
means that EXCEL couldn't find the add-in in that location, so it tags
those items as "unresolved links". EXCEL should have given you a warning
when you opened he workbook. This would have happened with ANY add-in
function, because when you save a workbook, EXCEL hard-codes the location
of the add-in. If it's not there when you next open the workbook,
unresolved links occur.
Did you install the add-in into a different location? Or move the add-in?
In any case, all you should need to do is run the smfFixLinks macro. It
will remove those hard-coded paths and force EXCEL to use the add-in
functions from the current location of the add-in that is defined by the
add-in manager.
On Mon, Jul 3, 2017 at 9:11 AM, Leo Bueno Leo@
...
wrote:
>
> Here is what I am using*. None* work anymore (worked a couple of weeks
> ago). I just installed the latest version of the AddIn, but that did not
> help.
>
>
>
> Stock price
>
> ='C:\
>
>
>
> Bond yield
>
> ='C:\
> RCHGetYahooQuotes(
>
>
>
> Euro to Dollar
>
> ='C:\
> RCHGetYahooQuotes(
>
>
>
>
>
Mon Jul 3, 2017 9:59 am (PDT) . Posted by:
"Gaston Bullrich" gbullr
here is the 30 year.
https://fred.stlouisfed.org/series/DGS30
There is a FRED addin to excel allows you to pull in all the data.
On Mon, Jul 3, 2017 at 12:02 PM, Leo Bueno Leo@BuenoLaw.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> I need simple information for some stocks: current price (and name to make
> sure I have the right stock's price).
>
>
>
> I keep having problems with the SMFAddIn getting the data from Yahoo.
>
>
>
> Is there another data site that is more compatible with the SMFAddIn?
>
>
>
> While we are at it, I also need the current 30-year treasury yield.
>
>
>
> Thanks in advance for your assistance.
>
>
>
> =========
> Leo Bueno
> =========
>
>
> ------------------------------
> Posted by: Leo Bueno <leo@buenolaw.com>
> ------------------------------
> Reply via web post
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32699;_ylc=X3oDMTJybjVyMTI2BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMzMjY5OQRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE0OTkwOTk3NzQ-?act=reply&messageNum=32699>
> • Reply to sender
> <leo@buenolaw.com?subject=Re%3A%20Stock%20price%20data%20source%20other%20than%20Yahoo>
> • Reply to group
> <smf_addin@yahoogroups.com?subject=Re%3A%20Stock%20price%20data%20source%20other%20than%20Yahoo>
> • Start a New Topic
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/newtopic;_ylc=X3oDMTJmOHVsZm1pBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNudHBjBHN0aW1lAzE0OTkwOTk3NzQ->
> • Messages in this topic
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/32696;_ylc=X3oDMTM3dDFsNmloBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMzMjY5OQRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzE0OTkwOTk3NzQEdHBjSWQDMzI2OTY->
> (3)
> ------------------------------
> Have you tried the highest rated email app? <https://yho.com/1wwmgg>
> With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email
> app on the market. What are you waiting for? Now you can access all your
> inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email
> again with 1000GB of free cloud storage.
> ------------------------------
> For the Add-in, Documentation, Templates, Tips and FAQs, visit
> http://ogres-crypt.com/SMF
> Visit Your Group
> <https://groups.yahoo.com/neo/groups/smf_addin/info;_ylc=X3oDMTJmcXB2N2lwBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzE0OTkwOTk3NzQ->
>
> - New Members
> <https://groups.yahoo.com/neo/groups/smf_addin/members/all;_ylc=X3oDMTJnNmJ1bTE1BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDdnRsBHNsawN2bWJycwRzdGltZQMxNDk5MDk5Nzc0>
> 9
>
> [image: Yahoo! Groups]
> <https://groups.yahoo.com/neo;_ylc=X3oDMTJlZmJ1dmN0BF9TAzk3NDc2NTkwBGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTQ5OTA5OTc3NA-->
> • Privacy <https://info.yahoo.com/privacy/us/yahoo/groups/details.html> •
> Unsubscribe <smf_addin-unsubscribe@yahoogroups.com?subject=Unsubscribe> • Terms
> of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/>
>
> .
>
>
https://fred.stlouisfed.org/series/DGS30
There is a FRED addin to excel allows you to pull in all the data.
On Mon, Jul 3, 2017 at 12:02 PM, Leo Bueno Leo@BuenoLaw.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> I need simple information for some stocks: current price (and name to make
> sure I have the right stock's price).
>
>
>
> I keep having problems with the SMFAddIn getting the data from Yahoo.
>
>
>
> Is there another data site that is more compatible with the SMFAddIn?
>
>
>
> While we are at it, I also need the current 30-year treasury yield.
>
>
>
> Thanks in advance for your assistance.
>
>
>
> =========
> Leo Bueno
> =========
>
>
> ------------------------------
> Posted by: Leo Bueno <leo@buenolaw.com>
> ------------------------------
> Reply via web post
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32699;_ylc=X3oDMTJybjVyMTI2BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMzMjY5OQRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE0OTkwOTk3NzQ-?act=reply&messageNum=32699>
> • Reply to sender
> <leo@buenolaw.com?subject=Re%3A%20Stock%20price%20data%20source%20other%20than%20Yahoo>
> • Reply to group
> <smf_addin@yahoogroups.com?subject=Re%3A%20Stock%20price%20data%20source%20other%20than%20Yahoo>
> • Start a New Topic
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/newtopic;_ylc=X3oDMTJmOHVsZm1pBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNudHBjBHN0aW1lAzE0OTkwOTk3NzQ->
> • Messages in this topic
> <https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/32696;_ylc=X3oDMTM3dDFsNmloBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMzMjY5OQRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzE0OTkwOTk3NzQEdHBjSWQDMzI2OTY->
> (3)
> ------------------------------
> Have you tried the highest rated email app? <https://yho.com/1wwmgg>
> With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email
> app on the market. What are you waiting for? Now you can access all your
> inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email
> again with 1000GB of free cloud storage.
> ------------------------------
> For the Add-in, Documentation, Templates, Tips and FAQs, visit
> http://ogres-crypt.com/SMF
> Visit Your Group
> <https://groups.yahoo.com/neo/groups/smf_addin/info;_ylc=X3oDMTJmcXB2N2lwBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzE0OTkwOTk3NzQ->
>
> - New Members
> <https://groups.yahoo.com/neo/groups/smf_addin/members/all;_ylc=X3oDMTJnNmJ1bTE1BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDdnRsBHNsawN2bWJycwRzdGltZQMxNDk5MDk5Nzc0>
> 9
>
> [image: Yahoo! Groups]
> <https://groups.yahoo.com/neo;_ylc=X3oDMTJlZmJ1dmN0BF9TAzk3NDc2NTkwBGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTQ5OTA5OTc3NA-->
> • Privacy <https://info.yahoo.com/privacy/us/yahoo/groups/details.html> •
> Unsubscribe <smf_addin-unsubscribe@yahoogroups.com?subject=Unsubscribe> • Terms
> of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/>
>
> .
>
>
Mon Jul 3, 2017 11:15 am (PDT) . Posted by:
"Leo Bueno" leobueno
How do I run the smfFixLinks macro?
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 12:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
You have location errors. The path in front of your function invocation means that EXCEL couldn't find the add-in in that location, so it tags those items as "unresolved links". EXCEL should have given you a warning when you opened he workbook. This would have happened with ANY add-in function, because when you save a workbook, EXCEL hard-codes the location of the add-in. If it's not there when you next open the workbook, unresolved links occur.
Did you install the add-in into a different location? Or move the add-in?
In any case, all you should need to do is run the smfFixLinks macro. It will remove those hard-coded paths and force EXCEL to use the add-in functions from the current location of the add-in that is defined by the add-in manager.
On Mon, Jul 3, 2017 at 9:11 AM, Leo Bueno Leo@
...
wrote:
Here is what I am using. None work anymore (worked a couple of weeks ago). I just installed the latest version of the AddIn, but that did not help.
Stock price
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A8,"l1")
Bond yield
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("^TYX","l1")
Euro to Dollar
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes($A33&B$29&"=X","l1")
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 12:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
You have location errors. The path in front of your function invocation means that EXCEL couldn't find the add-in in that location, so it tags those items as "unresolved links". EXCEL should have given you a warning when you opened he workbook. This would have happened with ANY add-in function, because when you save a workbook, EXCEL hard-codes the location of the add-in. If it's not there when you next open the workbook, unresolved links occur.
Did you install the add-in into a different location? Or move the add-in?
In any case, all you should need to do is run the smfFixLinks macro. It will remove those hard-coded paths and force EXCEL to use the add-in functions from the current location of the add-in that is defined by the add-in manager.
On Mon, Jul 3, 2017 at 9:11 AM, Leo Bueno Leo@
...
wrote:
Here is what I am using. None work anymore (worked a couple of weeks ago). I just installed the latest version of the AddIn, but that did not help.
Stock price
='C:\
Bond yield
='C:\
Euro to Dollar
='C:\
Mon Jul 3, 2017 11:22 am (PDT) . Posted by:
"Leo Bueno" leobueno
When I go to File/Options/Quick Access Toolbar/ Macros I don't see any macros. Only a <Separator>.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 2:16 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RE: Stock price data source other than Yahoo
How do I run the smfFixLinks macro?
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 12:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
You have location errors. The path in front of your function invocation means that EXCEL couldn't find the add-in in that location, so it tags those items as "unresolved links". EXCEL should have given you a warning when you opened he workbook. This would have happened with ANY add-in function, because when you save a workbook, EXCEL hard-codes the location of the add-in. If it's not there when you next open the workbook, unresolved links occur.
Did you install the add-in into a different location? Or move the add-in?
In any case, all you should need to do is run the smfFixLinks macro. It will remove those hard-coded paths and force EXCEL to use the add-in functions from the current location of the add-in that is defined by the add-in manager.
On Mon, Jul 3, 2017 at 9:11 AM, Leo Bueno Leo@
...
wrote:
Here is what I am using. None work anymore (worked a couple of weeks ago). I just installed the latest version of the AddIn, but that did not help.
Stock price
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A8,"l1")
Bond yield
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("^TYX","l1")
Euro to Dollar
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes($A33&B$29&"=X","l1")
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 2:16 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RE: Stock price data source other than Yahoo
How do I run the smfFixLinks macro?
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 12:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
You have location errors. The path in front of your function invocation means that EXCEL couldn't find the add-in in that location, so it tags those items as "unresolved links". EXCEL should have given you a warning when you opened he workbook. This would have happened with ANY add-in function, because when you save a workbook, EXCEL hard-codes the location of the add-in. If it's not there when you next open the workbook, unresolved links occur.
Did you install the add-in into a different location? Or move the add-in?
In any case, all you should need to do is run the smfFixLinks macro. It will remove those hard-coded paths and force EXCEL to use the add-in functions from the current location of the add-in that is defined by the add-in manager.
On Mon, Jul 3, 2017 at 9:11 AM, Leo Bueno Leo@
...
wrote:
Here is what I am using. None work anymore (worked a couple of weeks ago). I just installed the latest version of the AddIn, but that did not help.
Stock price
='C:\
Bond yield
='C:\
Euro to Dollar
='C:\
Mon Jul 3, 2017 11:28 am (PDT) . Posted by:
"Leo Bueno" leobueno
I then went to File/Options/Trust Center/Trust Center Settings/ and clicked the radio button "Enable all macros . . .".
When I went back to File/Options/Quick Access Toolbar/ Macros, I stil did not see any macros.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 2:23 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RE: Stock price data source other than Yahoo
When I go to File/Options/Quick Access Toolbar/ Macros I don't see any macros. Only a <Separator>.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 2:16 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RE: Stock price data source other than Yahoo
How do I run the smfFixLinks macro?
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 12:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
You have location errors. The path in front of your function invocation means that EXCEL couldn't find the add-in in that location, so it tags those items as "unresolved links". EXCEL should have given you a warning when you opened he workbook. This would have happened with ANY add-in function, because when you save a workbook, EXCEL hard-codes the location of the add-in. If it's not there when you next open the workbook, unresolved links occur.
Did you install the add-in into a different location? Or move the add-in?
In any case, all you should need to do is run the smfFixLinks macro. It will remove those hard-coded paths and force EXCEL to use the add-in functions from the current location of the add-in that is defined by the add-in manager.
On Mon, Jul 3, 2017 at 9:11 AM, Leo Bueno Leo@
...
wrote:
Here is what I am using. None work anymore (worked a couple of weeks ago). I just installed the latest version of the AddIn, but that did not help.
Stock price
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A8,"l1")
Bond yield
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("^TYX","l1")
Euro to Dollar
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes($A33&B$29&"=X","l1")
When I went back to File/Options/Quick Access Toolbar/ Macros, I stil did not see any macros.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 2:23 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RE: Stock price data source other than Yahoo
When I go to File/Options/Quick Access Toolbar/ Macros I don't see any macros. Only a <Separator>.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 2:16 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RE: Stock price data source other than Yahoo
How do I run the smfFixLinks macro?
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 12:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
You have location errors. The path in front of your function invocation means that EXCEL couldn't find the add-in in that location, so it tags those items as "unresolved links". EXCEL should have given you a warning when you opened he workbook. This would have happened with ANY add-in function, because when you save a workbook, EXCEL hard-codes the location of the add-in. If it's not there when you next open the workbook, unresolved links occur.
Did you install the add-in into a different location? Or move the add-in?
In any case, all you should need to do is run the smfFixLinks macro. It will remove those hard-coded paths and force EXCEL to use the add-in functions from the current location of the add-in that is defined by the add-in manager.
On Mon, Jul 3, 2017 at 9:11 AM, Leo Bueno Leo@
...
wrote:
Here is what I am using. None work anymore (worked a couple of weeks ago). I just installed the latest version of the AddIn, but that did not help.
Stock price
='C:\
Bond yield
='C:\
Euro to Dollar
='C:\
Mon Jul 3, 2017 11:49 am (PDT) . Posted by:
"Leo Bueno" leobueno
I ran the spreadsheet from another computer in the Windows home network (two PCs connected through a switch; files shared). Maybe that's what caused the insertion of the path.
I am currently using Excel 2010 and the latest version of the SMFAddIn.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 12:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
You have location errors. The path in front of your function invocation means that EXCEL couldn't find the add-in in that location, so it tags those items as "unresolved links". EXCEL should have given you a warning when you opened he workbook. This would have happened with ANY add-in function, because when you save a workbook, EXCEL hard-codes the location of the add-in. If it's not there when you next open the workbook, unresolved links occur.
Did you install the add-in into a different location? Or move the add-in?
In any case, all you should need to do is run the smfFixLinks macro. It will remove those hard-coded paths and force EXCEL to use the add-in functions from the current location of the add-in that is defined by the add-in manager.
On Mon, Jul 3, 2017 at 9:11 AM, Leo Bueno Leo@
...
wrote:
Here is what I am using. None work anymore (worked a couple of weeks ago). I just installed the latest version of the AddIn, but that did not help.
Stock price
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A8,"l1")
Bond yield
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes("^TYX","l1")
Euro to Dollar
='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes($A33&B$29&"=X","l1")
I am currently using Excel 2010 and the latest version of the SMFAddIn.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 12:55 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
You have location errors. The path in front of your function invocation means that EXCEL couldn't find the add-in in that location, so it tags those items as "unresolved links". EXCEL should have given you a warning when you opened he workbook. This would have happened with ANY add-in function, because when you save a workbook, EXCEL hard-codes the location of the add-in. If it's not there when you next open the workbook, unresolved links occur.
Did you install the add-in into a different location? Or move the add-in?
In any case, all you should need to do is run the smfFixLinks macro. It will remove those hard-coded paths and force EXCEL to use the add-in functions from the current location of the add-in that is defined by the add-in manager.
On Mon, Jul 3, 2017 at 9:11 AM, Leo Bueno Leo@
...
wrote:
Here is what I am using. None work anymore (worked a couple of weeks ago). I just installed the latest version of the AddIn, but that did not help.
Stock price
='C:\
Bond yield
='C:\
Euro to Dollar
='C:\
Mon Jul 3, 2017 11:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Mon, Jul 3, 2017 at 11:15 AM, Leo Bueno Leo@
...
wrote:
>
> How do I run the smfFixLinks macro?
>
Alt+F8 to bring up the macro dialog. Type in the name of the macro and
then click on the "Run" button when it's available.
On Mon, Jul 3, 2017 at 11:22 AM, Leo Bueno Leo@
...
wrote:
>
> When I go to File/Options/Quick Access Toolbar/ Macros I don't see any
> macros. Only a <Separator>.
>
That would seem to indicate you don't have the add-in installed and
activated.
On Mon, Jul 3, 2017 at 11:28 AM, Leo Bueno Leo@
...
wrote:
>
> I then went to File/Options/Trust Center/Trust Center Settings/ and
> clicked the radio button "Enable all macros . . .".
>
>
>
> When I went back to File/Options/Quick Access Toolbar/ Macros, I stil did
> not see any macros.
>
Don't enable all macros. That can be dangerous.
On Mon, Jul 3, 2017 at 11:34 AM, Leo Bueno Leo@
...
wrote:
>
> I ran the spreadsheet from another computer in the Windows home network
> (two PCs connected through a switch; files shared). Maybe that's what
> caused the insertion of the path.
>
>
>
> I am currently using Excel 2010 and the latest version of the SMFAddIn.
>
Are you sure you installed and activated the add-in on both computers?
You can verify by checking the version:
=RCHGetElementNumber("Version")
...
wrote:
>
> How do I run the smfFixLinks macro?
>
Alt+F8 to bring up the macro dialog. Type in the name of the macro and
then click on the "Run" button when it's available.
On Mon, Jul 3, 2017 at 11:22 AM, Leo Bueno Leo@
...
wrote:
>
> When I go to File/Options/
> macros. Only a <Separator>
>
That would seem to indicate you don't have the add-in installed and
activated.
On Mon, Jul 3, 2017 at 11:28 AM, Leo Bueno Leo@
...
wrote:
>
> I then went to File/Options/
> clicked the radio button "Enable all macros . . .".
>
>
>
> When I went back to File/Options/
> not see any macros.
>
Don't enable all macros. That can be dangerous.
On Mon, Jul 3, 2017 at 11:34 AM, Leo Bueno Leo@
...
wrote:
>
> I ran the spreadsheet from another computer in the Windows home network
> (two PCs connected through a switch; files shared). Maybe that's what
> caused the insertion of the path.
>
>
>
> I am currently using Excel 2010 and the latest version of the SMFAddIn.
>
Are you sure you installed and activated the add-in on both computers?
You can verify by checking the version:
=RCHGetElementNumbe
Mon Jul 3, 2017 12:15 pm (PDT) . Posted by:
"Leo Bueno" leobueno
The good news: All the links now look good, i.e., the function bar shows, for example,
=RCHGetYahooQuotes(A10,"n")
for when I am trying to get the name of the ticker on cell A10 and
=RCHGetYahooQuotes(A10,"l1")
when I am trying to get the price.
The bad news: the results are blank cells, nothing.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 2:57 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
On Mon, Jul 3, 2017 at 11:15 AM, Leo Bueno Leo@
...
wrote:
How do I run the smfFixLinks macro?
Alt+F8 to bring up the macro dialog. Type in the name of the macro and then click on the "Run" button when it's available.
On Mon, Jul 3, 2017 at 11:22 AM, Leo Bueno Leo@
...
wrote:
When I go to File/Options/Quick Access Toolbar/ Macros I don't see any macros. Only a <Separator>.
That would seem to indicate you don't have the add-in installed and activated.
On Mon, Jul 3, 2017 at 11:28 AM, Leo Bueno Leo@
...
wrote:
I then went to File/Options/Trust Center/Trust Center Settings/ and clicked the radio button "Enable all macros . . .".
When I went back to File/Options/Quick Access Toolbar/ Macros, I stil did not see any macros.
Don't enable all macros. That can be dangerous.
On Mon, Jul 3, 2017 at 11:34 AM, Leo Bueno Leo@
...
wrote:
I ran the spreadsheet from another computer in the Windows home network (two PCs connected through a switch; files shared). Maybe that's what caused the insertion of the path.
I am currently using Excel 2010 and the latest version of the SMFAddIn.
Are you sure you installed and activated the add-in on both computers?
You can verify by checking the version:
=RCHGetElementNumber("Version")
=RCHGetYahooQuotes(A10,"n")
for when I am trying to get the name of the ticker on cell A10 and
=RCHGetYahooQuotes(A10,"l1")
when I am trying to get the price.
The bad news: the results are blank cells, nothing.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 2:57 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
On Mon, Jul 3, 2017 at 11:15 AM, Leo Bueno Leo@
...
wrote:
How do I run the smfFixLinks macro?
Alt+F8 to bring up the macro dialog. Type in the name of the macro and then click on the "Run" button when it's available.
On Mon, Jul 3, 2017 at 11:22 AM, Leo Bueno Leo@
...
wrote:
When I go to File/Options/
That would seem to indicate you don't have the add-in installed and activated.
On Mon, Jul 3, 2017 at 11:28 AM, Leo Bueno Leo@
...
wrote:
I then went to File/Options/
When I went back to File/Options/
Don't enable all macros. That can be dangerous.
On Mon, Jul 3, 2017 at 11:34 AM, Leo Bueno Leo@
...
wrote:
I ran the spreadsheet from another computer in the Windows home network (two PCs connected through a switch; files shared). Maybe that's what caused the insertion of the path.
I am currently using Excel 2010 and the latest version of the SMFAddIn.
Are you sure you installed and activated the add-in on both computers?
You can verify by checking the version:
=RCHGetElementNumbe
Mon Jul 3, 2017 9:26 am (PDT) . Posted by:
"Luis Barahona" luismbarahona
Do any of you guys know how I can get the historical data on the corporate bonds spreads?
The Reuters Corporate Spreads used to be a good source. Luis Miguel Barahona
Phone: (786) 691-3922
e-mail: luismbarahona@yahoo.com
The Reuters Corporate Spreads used to be a good source. Luis Miguel Barahona
Phone: (786) 691-3922
e-mail: luismbarahona@yahoo.com
Mon Jul 3, 2017 9:57 am (PDT) . Posted by:
"Gaston Bullrich" gbullr
Fairly difficult to get but on the finra page.
http://finra-markets.morningstar.com/BondCenter/Screener.jsp
And then you can write scripts to get into excel but it is not easy. I have
a spreadsheet in the resource section called bond something or other that
does it (I don't know if it works any more)
[image: Inline image 1]
On Mon, Jul 3, 2017 at 12:26 PM, Luis Barahona luismbarahona@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Do any of you guys know how I can get the historical data on the corporate
> bonds spreads?
>
> The Reuters Corporate Spreads used to be a good source.
>
> *Luis Miguel Barahona*
>
> Phone: (786) 691-3922
> e-mail: luismbarahona@yahoo.com
>
>
>
http://finra-markets.morningstar.com/BondCenter/Screener.jsp
And then you can write scripts to get into excel but it is not easy. I have
a spreadsheet in the resource section called bond something or other that
does it (I don't know if it works any more)
[image: Inline image 1]
On Mon, Jul 3, 2017 at 12:26 PM, Luis Barahona luismbarahona@yahoo.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Do any of you guys know how I can get the historical data on the corporate
> bonds spreads?
>
> The Reuters Corporate Spreads used to be a good source.
>
> *Luis Miguel Barahona*
>
> Phone: (786) 691-3922
> e-mail: luismbarahona@yahoo.com
>
>
>
Mon Jul 3, 2017 11:54 am (PDT) . Posted by:
dfl10
I've noticed lately that I get an "Error" return when using =RCHGetYahooQuotes(A517,"n") and =RCHGetYahooQuotes(A517,"l1") with A517 as a ticker reference. The weird thing is =RCHGetYahooQuotes(A517,"p6") works fine (PB Ratio). Sometimes everything returns normal, but lately more often than not "Error" is returned. Any ideas on what may be going on? I'm using the latest 5/3/17 release.
Mon Jul 3, 2017 12:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
How many different RCHGetYahooQuotes() functions are you doing? It could be
Yahoo servers are having trouble keeping up with the number of requests.
Try changing to array-entered formulas. You can get multiple data items on
up to 200 ticker symbols with a single RCHGetYahooQuotes() function.
What ticker symbol is in cell A517?
On Mon, Jul 3, 2017 at 11:54 AM, dloewith@
...
wrote:
> I've noticed lately that I get an "Error" return when
> using =RCHGetYahooQuotes(A517,"n") and =RCHGetYahooQuotes(A517,"l1") with
> A517 as a ticker reference. The weird thing is =RCHGetYahooQuotes(A517,"p6")
> works fine (PB Ratio). Sometimes everything returns normal, but lately
> more often than not "Error" is returned. Any ideas on what may be going
> on? I'm using the latest 5/3/17 release.
>
Yahoo servers are having trouble keeping up with the number of requests.
Try changing to array-entered formulas. You can get multiple data items on
up to 200 ticker symbols with a single RCHGetYahooQuotes(
What ticker symbol is in cell A517?
On Mon, Jul 3, 2017 at 11:54 AM, dloewith@
...
wrote:
> I've noticed lately that I get an "Error" return when
> using =RCHGetYahooQuotes(
> A517 as a ticker reference. The weird thing is =RCHGetYahooQuotes(
> works fine (PB Ratio). Sometimes everything returns normal, but lately
> more often than not "Error" is returned. Any ideas on what may be going
> on? I'm using the latest 5/3/17 release.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar