Messages In This Digest (12 Messages)
- 1a.
- Re: new vervion of smfGetADVFNElement() is not working, but the prev From: AlanY
- 1b.
- Re: new vervion of smfGetADVFNElement() is not working, but the prev From: Randy Harmelink
- 2a.
- Re: Change AdvFN URL from "www" to "uk" From: AlanY
- 2b.
- Re: Change AdvFN URL from "www" to "uk" From: Randy Harmelink
- 3a.
- Getting Data from Value Line pdf files From: E John
- 3b.
- Re: Getting Data from Value Line pdf files From: Randy Harmelink
- 4a.
- version not upgrading From: AlanY
- 4b.
- Re: version not upgrading From: Randy Harmelink
- 5a.
- Commodities overview and currencies From: RonaldKok_98
- 5b.
- Re: Commodities overview and currencies From: Randy Harmelink
- 6a.
- Historical prices won't pull in for specific SP5 telecom ETF From: naderphilip
- 6b.
- Re: Historical prices won't pull in for specific SP5 telecom ETF From: Randy Harmelink
Messages
- 1a.
-
Re: new vervion of smfGetADVFNElement() is not working, but the prev
Posted by: "AlanY" alan.j.ying@gmail.com alan_ying
Thu Feb 23, 2012 3:02 pm (PST)
hi randy, i just found this thread after i posted about AdvFN.
my version is also 2.1.2012.01.30. i re-downloaded the most recent version on the website and it's still that version. am i looking in the wrong place?
--- In smf_addin@yahoogroups.com , "dkarbayev" <dkarbayev@...> wrote:
>
> Great! Thanks. i've just checked and found that i actually used version 2.1.2012.01.30 which i'm gonna change now.
>
>
> --- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@> wrote:
> >
> > Which new version are you using? 2.1.2012.01.30 used "us", but I changed
> > it back to "www" in 2.1.2012.02.02, after AdvFN flip-flopped back. So,
> > the "most recent version" should be using "www", not "us".
> >
> > You can find out the version you are using with:
> >
> > =RCHGetElementNumber("Version" )
> >
> > On Mon, Feb 6, 2012 at 9:24 PM, dkarbayev <dkarbayev@> wrote:
> > Hi, Randy!
> >
> > Your addin is OUTSTANDING. Thank you for this!
> >
> > As far as I understand from the message history, in the most recent
> > version of the addin 'www' was changed for 'us' in the
> > smfGetADVFNElement() function. But this seems not to be working now
> > (last checked on Feb 7 2012).
> >
> > I've tried to reinstall the previous version of the addin, and
> > smfGetADVFNElement()is still working fine. But this previous version of
> > the addin does not contain your last developments and bug fixes. I can
> > imagine that you are overloaded with messages of the SMF group, but
> > could you have a look at it once again?
> >
>
- 1b.
-
Re: new vervion of smfGetADVFNElement() is not working, but the prev
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Feb 23, 2012 3:17 pm (PST)
You need to be exit and restart EXCEL in order to load the new add-in.
Add-ins are loaded when EXCEL starts up.
On Thu, Feb 23, 2012 at 3:11 PM, AlanY <alan.j.ying@gmail.com > wrote:
> hi randy, i just found this thread after i posted about AdvFN.
>
> my version is also 2.1.2012.01.30. i re-downloaded the most recent
> version on the website and it's still that version. am i looking in the
> wrong place?
>
- 2a.
-
Re: Change AdvFN URL from "www" to "uk"
Posted by: "AlanY" alan.j.ying@gmail.com alan_ying
Thu Feb 23, 2012 3:02 pm (PST)
hi randy,
i'm obviously stalking this problem through multiple posts (this is my third message on this) - apologies on frequency.
you mentioned in this reply that you changed the folder of your add-in to c: instead of c:\program files.
that's not in your current "install" documentation - should i be doing that?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> No, it's not password protected. The problem of not being able to save
> changes is why I ended up moving my copy of the add-in to "C:\SMF Add-in"
> instead under the "Program Files" folder. Microsoft changed security in
> Vista so that edits like that can no longer be saved into the "Program
> Files" folder without special permissions.
>
> I've been trying to figure out if there is a more automatic way of setting
> or maintaining that constant. What I'm thinking right now is to have the
> add-in look for a file like "AdvFN-prefix.txt". If the file doesn't exist,
> the add-in will use "www", otherwise you could create the text file and
> just put "uk" in it, and it would use that. That way, if the add-in gets
> updated, that file doesn't get replaced and your settings are maintained
> from version to version.
>
> On Sat, Feb 4, 2012 at 7:53 AM, paul84j <paul84j@...> wrote:
>
> >
> > I had a problem accessing AdvFN which was overcome by changing the constant
> >
> > Const kAdvFNPrefix = "www" to Const kAdvFNPrefix = "uk"
> >
> > but I can't save this change in the add-in so end up having to make the
> > change everytime I open Excel. Is the add-in password protected?
> >
>
- 2b.
-
Re: Change AdvFN URL from "www" to "uk"
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Feb 23, 2012 3:23 pm (PST)
Really, you can locate the add-in anywhere you want. It's just that it
makes files more difficult to share when two people have it in different
locations. Right now, any new files I upload will use the C:\ location, but
most files -- the older files -- still use the C:\Program Files location.
When I open up an older file, I just run the smfFixLinks macro that I have
in the add-in. I think the way it is right now would fix all location
errors.
On Thu, Feb 23, 2012 at 3:26 PM, AlanY <alan.j.ying@gmail.com > wrote:
>
> i'm obviously stalking this problem through multiple posts (this is my
> third message on this) - apologies on frequency.
>
> you mentioned in this reply that you changed the folder of your add-in to
> c: instead of c:\program files.
>
> that's not in your current "install" documentation - should i be doing
> that?
>
- 3a.
-
Getting Data from Value Line pdf files
Posted by: "E John" JWhelchel@comcast.net whelchelej
Thu Feb 23, 2012 3:02 pm (PST)
Hi Randy,
Thanks very much for this very useful add-in and the yahoo support group. I have been using the add-in for some time.
Is there a way to use the add-in or one of the templates to extract data from a Value Line pdf file? I note that there are ways to extract data from Morningstar. In addition, I see on the group website some prior e-mails on templates that appear to extract data from Value Line web pages. The web pages I think have fewer data points than the pdf reports, so it would be more useful to extract data from the pdf reports. There's an added benefit that once you have a subscription, which I do, extracting data from downloaded pdf files does not involve extracting large amounts of data from a web page on a free basis.
Any help you could give on this point would be very greatly appreciated.
John
- 3b.
-
Re: Getting Data from Value Line pdf files
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Feb 23, 2012 3:20 pm (PST)
I believe there are tools out there to extract data out of PDF files,
depending on how it was built, but the add-in isn't one of them. Sorry.
On Thu, Feb 23, 2012 at 3:32 PM, E John <JWhelchel@comcast.net > wrote:
>
> Is there a way to use the add-in or one of the templates to extract data
> from a Value Line pdf file? I note that there are ways to extract data
> from Morningstar. In addition, I see on the group website some prior
> e-mails on templates that appear to extract data from Value Line web pages.
> The web pages I think have fewer data points than the pdf reports, so it
> would be more useful to extract data from the pdf reports. There's an
> added benefit that once you have a subscription, which I do, extracting
> data from downloaded pdf files does not involve extracting large amounts of
> data from a web page on a free basis.
>
> Any help you could give on this point would be very greatly appreciated.
>
- 4a.
-
version not upgrading
Posted by: "AlanY" alan.j.ying@gmail.com alan_ying
Thu Feb 23, 2012 3:02 pm (PST)
ok, this may be the problem.
-- The specific function(s) or template(s) you are having problems with.
-- The parameter(s) you are using with the function(s).
my version (RCHGetElementNumber("Version" ) still says 2.1.2012.01. 30.
when i open the source file, it says 2012-02-02 at the top. when i open the .txt file 7 for AdvFN, there's no "www" or "us" URL anywhere in the file.
all my AdvFN calls are getting "Errors."
-- The version of EXCEL you use.
version 14.06.6112.5000 (32-bit)
-- The operating system you're running EXCEL under.
microsoft windows 7 home premium version 6.1.7601 SP1 Build 7601
-- The steps you took to try to resolve the problem.
i've re-extracted the newest zip files into the SMF Add-in folder
i've tested my formulas against non AdvFN sites and they mostly seem to work
advfn is the only one with annuals going back 10 yrs, so there are no comparables for 10yrs back
-- The ticker symbols or URLs that are being used.
i've used easy ones like IBM to test.
-- The results you expect to get and what you actually get
this all started happening really these last few wks - all my cells had been calculating correctly until a few wks ago.
- 4b.
-
Re: version not upgrading
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Feb 23, 2012 3:19 pm (PST)
AdvFN isn't going to work until you upgrade to 2.1.2012.02.02, because of
the flip-flop they did of the domain names.
On Thu, Feb 23, 2012 at 3:42 PM, AlanY <alan.j.ying@gmail.com > wrote:
> ok, this may be the problem.
>
> -- The specific function(s) or template(s) you are having problems with.
> -- The parameter(s) you are using with the function(s).
>
> my version (RCHGetElementNumber("Version" ) still says 2.1.2012.01. 30.
>
> when i open the source file, it says 2012-02-02 at the top. when i open
> the .txt file 7 for AdvFN, there's no "www" or "us" URL anywhere in the
> file.
>
> all my AdvFN calls are getting "Errors."
>
> -- The version of EXCEL you use.
> version 14.06.6112.5000 (32-bit)
>
> -- The operating system you're running EXCEL under.
> microsoft windows 7 home premium version 6.1.7601 SP1 Build 7601
>
> -- The steps you took to try to resolve the problem.
> i've re-extracted the newest zip files into the SMF Add-in folder
> i've tested my formulas against non AdvFN sites and they mostly seem to
> work
> advfn is the only one with annuals going back 10 yrs, so there are no
> comparables for 10yrs back
>
> -- The ticker symbols or URLs that are being used.
> i've used easy ones like IBM to test.
>
> -- The results you expect to get and what you actually get
> this all started happening really these last few wks - all my cells had
> been calculating correctly until a few wks ago.
>
>
>
>
>
> --------------------- --------- ------
>
> Yahoo! Groups Links
>
>
>
>
- 5a.
-
Commodities overview and currencies
Posted by: "RonaldKok_98" rkok@gmx.de RonaldKok_98
Thu Feb 23, 2012 3:32 pm (PST)
Hello,
Does maybe someone know the codes for the major commodities and currencies?
Thanks in advance,
Ronald
- 5b.
-
Re: Commodities overview and currencies
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Feb 23, 2012 4:05 pm (PST)
Start looking here:
http://finance.yahoo.com/ futures
http://finance.yahoo.com/ currency- investing
On Thu, Feb 23, 2012 at 4:32 PM, RonaldKok_98 <rkok@gmx.de> wrote:
>
> Does maybe someone know the codes for the major commodities and currencies?
>
- 6a.
-
Historical prices won't pull in for specific SP5 telecom ETF
Posted by: "naderphilip" naderphilip@yahoo.com naderphilip
Thu Feb 23, 2012 9:53 pm (PST)
Hello,
I can't seem to pull in the historical prices for ticker: XTL (Select Spyder Telecom ETF.
I've used the same formula for plenty other companies and tickers in my spreadsheet but for some reason this one won't calculate the closing prices after 12/1/2011.
I'm using the RCHgetyahoohistory- i've tried inputting the dates as well as just highlighting an array and it still stops at 12/1/2011.
Would anyone happen to know why?
- 6b.
-
Re: Historical prices won't pull in for specific SP5 telecom ETF
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Feb 23, 2012 10:14 pm (PST)
I just tried:
=RCHGetYahooHistory("XTL")
...and it worked fine for me. Could you possibly have your regional
settings on something that doesn't conform to mm/dd/yyyy? That would cause
VBA to have an issue when it tried to convert the dates.
On Thu, Feb 23, 2012 at 10:53 PM, naderphilip <naderphilip@yahoo.com > wrote:
> Hello,
> I can't seem to pull in the historical prices for ticker: XTL (Select
> Spyder Telecom ETF.
> I've used the same formula for plenty other companies and tickers in my
> spreadsheet but for some reason this one won't calculate the closing prices
> after 12/1/2011.
> I'm using the RCHgetyahoohistory- i've tried inputting the dates as well
> as just highlighting an array and it still stops at 12/1/2011.
>
> Would anyone happen to know why?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar