10 New Messages
Digest #2815
2a
Re: Beta version of add-in updated to work for AdvFN URL changes by "Sharon McAllister" sharonnraymc
Messages
Thu Oct 17, 2013 9:49 am (PDT) . Posted by:
af3512b8ef4166b5c33401271c05da3c
I sorted it out by cntrl+H and replased
='C:\Program Files\SMF
Add-in\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B10;"j1")
with empty :)
Thank you
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
See the "Location errors" entry in the LINKS area of the group.
I usually just run the smfFixLinks macro to remove them.
On Thu, Oct 17, 2013 at 2:48 AM, <johkouf@... mailto:johkouf@...> wrote:
I suddenly get the formula below where I used the add-in
='C:\Program Files\SMF
Add-in\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B10;"j1")
What can I do???
='C:\
Add-in\RCH_
with empty :)
Thank you
---In smf_addin@yahoogrou
See the "Location errors" entry in the LINKS area of the group.
I usually just run the smfFixLinks macro to remove them.
On Thu, Oct 17, 2013 at 2:48 AM, <johkouf@
I suddenly get the formula below where I used the add-in
='C:\
Add-in\RCH_
What can I do???
Thu Oct 17, 2013 10:41 am (PDT) . Posted by:
"Sharon McAllister" sharonnraymc
Thank you for the new update! -- Sharon
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, October 17, 2013 10:10 AM
Subject: Re: [smf_addin] RE: Beta version of add-in updated to work for AdvFN URL changes
Ahhh. I'm an idiot. New update:
RCH_Stock_Market_Functions-2.1.2013.10.17.zip
I had hard-coded "MMM" as the ticker symbol when looking up the stock exchange (needed for the URL), so anything outside of NYSE wouldn't work. Now fixed.
My apologies.
BTW, I tried a few AMEX companies and noted that AdvFN had *no* financials for them.
On Thu, Oct 17, 2013 at 7:37 AM, <derekrwerner@gmail.com> wrote:
Just as an FYI, I can only get this beta version to work for companies listed on the NYSE. Companies listed on the NASDAQ all return errors.
>
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Thursday, October 17, 2013 10:10 AM
Subject: Re: [smf_addin] RE: Beta version of add-in updated to work for AdvFN URL changes
Ahhh. I'm an idiot. New update:
RCH_Stock_Market_
I had hard-coded "MMM" as the ticker symbol when looking up the stock exchange (needed for the URL), so anything outside of NYSE wouldn't work. Now fixed.
My apologies.
BTW, I tried a few AMEX companies and noted that AdvFN had *no* financials for them.
On Thu, Oct 17, 2013 at 7:37 AM, <derekrwerner@
Just as an FYI, I can only get this beta version to work for companies listed on the NYSE. Companies listed on the NASDAQ all return errors.
>
Thu Oct 17, 2013 1:38 pm (PDT) . Posted by:
ttizzle2
Just gave RCH_Stock_Market_Functions-2.1.2013.10.17.zip a try from here in Europe. Unfortunately still get errors everywhere so it seems we still need to special case for regions. www.advfn.com resolves to uk.advfn.com here.
Going digging to see what I have to change, it's been a while... pointers welcome!
Thanks,
- Andrew
---In smf_addin@yahoogroups.com, <sharonnraymc@...> wrote:
Thank you for the new update! -- Sharon
From: Randy Harmelink <rharmelink@...>
To: smf_addin@yahoogroups.com
Sent: Thursday, October 17, 2013 10:10 AM
Subject: Re: [smf_addin] RE: Beta version of add-in updated to work for AdvFN URL changes
Ahhh. I'm an idiot. New update:
RCH_Stock_Market_Functions-2.1.2013.10.17.zip
I had hard-coded "MMM" as the ticker symbol when looking up the stock exchange (needed for the URL), so anything outside of NYSE wouldn't work. Now fixed.
My apologies.
BTW, I tried a few AMEX companies and noted that AdvFN had *no* financials for them.
On Thu, Oct 17, 2013 at 7:37 AM, <derekrwerner@... mailto:derekrwerner@...> wrote:
Just as an FYI, I can only get this beta version to work for companies listed on the NYSE. Companies listed on the NASDAQ all return errors.
Going digging to see what I have to change, it's been a while... pointers welcome!
Thanks,
- Andrew
---In smf_addin@yahoogrou
Thank you for the new update! -- Sharon
From: Randy Harmelink <rharmelink@
To: smf_addin@yahoogrou
Sent: Thursday, October 17, 2013 10:10 AM
Subject: Re: [smf_addin] RE: Beta version of add-in updated to work for AdvFN URL changes
Ahhh. I'm an idiot. New update:
RCH_Stock_Market_
I had hard-coded "MMM" as the ticker symbol when looking up the stock exchange (needed for the URL), so anything outside of NYSE wouldn't work. Now fixed.
My apologies.
BTW, I tried a few AMEX companies and noted that AdvFN had *no* financials for them.
On Thu, Oct 17, 2013 at 7:37 AM, <derekrwerner@
Just as an FYI, I can only get this beta version to work for companies listed on the NYSE. Companies listed on the NASDAQ all return errors.
Thu Oct 17, 2013 11:51 am (PDT) . Posted by:
lewglenn
I'm using the statement:
Range("A2:H60") = RCHGetYahooQuotes(SelStr, "spohgl1d1t1m3", , Now(), 0).
It works fine, but the 'm3' in the string is not outputting the 50-day SMA. Am I doing something wrong?
Thanks.
Lew
Range("
It works fine, but the 'm3' in the string is not outputting the 50-day SMA. Am I doing something wrong?
Thanks.
Lew
Thu Oct 17, 2013 1:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If I'm counting parameters correctly, it looks like you don't have enough
columns for it in your Range() statement...
On Thu, Oct 17, 2013 at 11:51 AM, <lewglenn@yahoo.com> wrote:
>
> I'm using the statement:
> Range("A2:H60") = RCHGetYahooQuotes(SelStr, "spohgl1d1t1m3", , Now(), 0).
>
> It works fine, but the 'm3' in the string is not outputting the 50-day
> SMA. Am I doing something wrong?
>
columns for it in your Range() statement...
On Thu, Oct 17, 2013 at 11:51 AM, <lewglenn@yahoo.
>
> I'm using the statement:
> Range("
>
> It works fine, but the 'm3' in the string is not outputting the 50-day
> SMA. Am I doing something wrong?
>
Thu Oct 17, 2013 3:16 pm (PDT) . Posted by:
lewglenn
Of course, you're correct. Dumb mistake.
Many thanks.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
If I'm counting parameters correctly, it looks like you don't have enough columns for it in your Range() statement...
On Thu, Oct 17, 2013 at 11:51 AM, <lewglenn@... mailto:lewglenn@...> wrote:
I'm using the statement:
Range("A2:H60") = RCHGetYahooQuotes(SelStr, "spohgl1d1t1m3", , Now(), 0).
It works fine, but the 'm3' in the string is not outputting the 50-day SMA. Am I doing something wrong?
Many thanks.
---In smf_addin@yahoogrou
If I'm counting parameters correctly, it looks like you don't have enough columns for it in your Range() statement...
On Thu, Oct 17, 2013 at 11:51 AM, <lewglenn@
I'm using the statement:
Range("
It works fine, but the 'm3' in the string is not outputting the 50-day SMA. Am I doing something wrong?
Thu Oct 17, 2013 8:40 pm (PDT) . Posted by:
joelfp2000
Randy...for some strange reason I can't get either of the above to work.
The RCHGetElementNumber("MMM",848) returns an ERROR and the RCHGetYahooQuotes("mmm") returns MMM. I have downloaded all of your "works in progress" files into my SMF folder and all of my other elements work just fine.
Any ideas would be greatly appreciated?
Joel
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
This worked fine for me:
=RCHGetElementNumber("MMM";,848)
Element #25 has been obsoleted. MSN was posting the previous day's closing price for "Last Price" since early last year. You should use RCHGetYahooQuotes() for current quotes.
On Wed, Oct 16, 2013 at 8:57 PM, <joel.andrews@... mailto:joel.andrews@...> wrote:
Randy,
Great work on the AdvFN!
FYI..element #25 (MSN last price) and element # 848 (Zack's ranking) don't seem to be working.
Joel
The RCHGetElementNumber
Any ideas would be greatly appreciated?
Joel
---In smf_addin@yahoogrou
This worked fine for me:
=RCHGetElementNumbe
Element #25 has been obsoleted. MSN was posting the previous day's closing price for "Last Price" since early last year. You should use RCHGetYahooQuotes(
On Wed, Oct 16, 2013 at 8:57 PM, <joel.andrews@
Randy,
Great work on the AdvFN!
FYI..element #25 (MSN last price) and element # 848 (Zack's ranking) don't seem to be working.
Joel
Thu Oct 17, 2013 9:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This:
=RCHGetYahooQuotes("mmm")
...would just return "MMM" if you enter it into a single cell. The default
first column of data is to return the ticker symbol. You need to
array-enter it over multiple columns to retrieve the other default data
items.
Does this work for you?
=0+smfstrExtr(smfGetTagContent("
http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks
Rank:"),": ","-")
Or, what happens if you go to this URL using the EXCEL Web Query dialog
(alt+d+d+w):
http://www.zacks.com/stock/quote/MMM/detailed-estimates
Do you see a Zacks rank?
On Thu, Oct 17, 2013 at 8:40 PM, <joel.andrews@lpl.com> wrote:
> The RCHGetElementNumber("MMM",848) returns an ERROR and the
> RCHGetYahooQuotes("mmm") returns MMM. I have downloaded all of your "works
> in progress" files into my SMF folder and all of my other elements work
> just fine.
>
> Any ideas would be greatly appreciated?
>
=RCHGetYahooQuotes(
...would just return "MMM" if you enter it into a single cell. The default
first column of data is to return the ticker symbol. You need to
array-enter it over multiple columns to retrieve the other default data
items.
Does this work for you?
=0+smfstrExtr(
http://www.zacks.
Rank:")
Or, what happens if you go to this URL using the EXCEL Web Query dialog
(alt+d+d+w):
http://www.zacks.
Do you see a Zacks rank?
On Thu, Oct 17, 2013 at 8:40 PM, <joel.andrews@
> The RCHGetElementNumber
> RCHGetYahooQuotes(
> in progress" files into my SMF folder and all of my other elements work
> just fine.
>
> Any ideas would be greatly appreciated?
>
Thu Oct 17, 2013 8:42 pm (PDT) . Posted by:
spudtatro
Since updating to SMF-2.1.2012.12.29, I am getting #Value! errors on all spreadsheets that are looking for RCH_stock-market_functions. I do not get any spreadsheet errors for cells that have RCH Elements. I did update the add-in link so it is looking for the correct file. One spreadsheet where I am getting errors is the SMF-Template-10-Year-Charts.xls Any suggestions?
Thu Oct 17, 2013 9:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
From your description, I'm not exactly sure what functions you're having
problems with? If I understand the issue:
In the past, I've found using the update links in EXCEL is not reliable.
Have you tried the method suggested in the "Location Errors" item in the
LINKS area of the group?
Or, try running the smfFixLinks macro that is part of the add-in. I use
that regularly when I have link errors in my worksheets.
On Thu, Oct 17, 2013 at 8:42 PM, <labsrcool@hotmail.com> wrote:
> Since updating to SMF-2.1.2012.12.29, I am getting #Value! errors on all
> spreadsheets that are looking for RCH_stock-market_functions. I do not get
> any spreadsheet errors for cells that have RCH Elements. I did update the
> add-in link so it is looking for the correct file. One spreadsheet where I
> am getting errors is the SMF-Template-10-Year-Charts.xls Any suggestions?
>
problems with? If I understand the issue:
In the past, I've found using the update links in EXCEL is not reliable.
Have you tried the method suggested in the "Location Errors" item in the
LINKS area of the group?
Or, try running the smfFixLinks macro that is part of the add-in. I use
that regularly when I have link errors in my worksheets.
On Thu, Oct 17, 2013 at 8:42 PM, <labsrcool@hotmail.
> Since updating to SMF-2.1.2012.
> spreadsheets that are looking for RCH_stock-market_
> any spreadsheet errors for cells that have RCH Elements. I did update the
> add-in link so it is looking for the correct file. One spreadsheet where I
> am getting errors is the SMF-Template-
>
Tidak ada komentar:
Posting Komentar