Messages In This Digest (7 Messages)
- 1a.
- Screner Capability From: Kit
- 1b.
- Re: Screner Capability From: Randy Harmelink
- 2.
- Barchart What Not1.xlsm From: kim54blake
- 3a.
- exact DATE match for smfGetEconData ? From: r d
- 3b.
- Re: exact DATE match for smfGetEconData ? From: Randy Harmelink
- 3c.
- Re: exact DATE match for smfGetEconData ? From: r d
- 3d.
- Re: exact DATE match for smfGetEconData ? From: Randy Harmelink
Messages
- 1a.
-
Screner Capability
Posted by: "Kit" frizeby@yahoo.com frizeby
Wed Mar 28, 2012 9:21 am (PDT)
Hi Randy,
I greatly appreciate this add-in and have already created my own calculator from it.
However, I was wondering if you could help me figure out how to screen a handful of stock tickers through a calculation and spit out their calculated values into another cell. Thanks for your time.
Kit
- 1b.
-
Re: Screner Capability
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Mar 28, 2012 9:22 am (PDT)
Why wouldn't you just do a normal calculation in EXCEL? I guess I don't
understand what you're trying to do.
On Wed, Mar 28, 2012 at 9:19 AM, Kit <frizeby@yahoo.com > wrote:
>
> I greatly appreciate this add-in and have already created my own
> calculator from it.
>
> However, I was wondering if you could help me figure out how to screen a
> handful of stock tickers through a calculation and spit out their
> calculated values into another cell. Thanks for your time.
>
- 2.
-
Barchart What Not1.xlsm
Posted by: "kim54blake" kblake@rogers.com kim54blake
Wed Mar 28, 2012 10:47 am (PDT)
I just downloaded this file, it looks very impressive, however when I click on any of the buttons I get a compile error: "Method or data member not found" with .ProgressBar1 highlighted??
Is this a problem at my end or is a module missing?
- 3a.
-
exact DATE match for smfGetEconData ?
Posted by: "r d" freddy@email.com stupid21bull
Wed Mar 28, 2012 5:38 pm (PDT)
wondering if there is a way to retrieve an EXACT date match for the data being retrieved?
ie.
Obtaining data from NHSUSSPU15 for January 15,2012:
=smfGetEconData("NHSUSSPU15" ,DATE(2012, 01,15))
returns the correct value of "5"
however the date is actually JANUARY 01, 2012.
Is there any way to return a matching value of "01-01-2012" for reference purposes?
- 3b.
-
Re: exact DATE match for smfGetEconData ?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Mar 28, 2012 6:18 pm (PDT)
Given that data series is monthly, the day will ALWAYS be the first of the
month.
The function was written to look for the first data less than or equal to
the passed date, to account for the possibility of weekly and monthly time
series. So that you DIDN'T have to know the exact dates.
You can always use:
=smfGetEconData("NHSUSSPU15" ,"Date Range")
=smfGetEconData("NHSUSSPU15" ,"Frequency" )
...to find out what kinds of dates are available...
On Wed, Mar 28, 2012 at 5:38 PM, r d <freddy@email.com > wrote:
> wondering if there is a way to retrieve an EXACT date match for the data
> being retrieved?
>
> ie.
> Obtaining data from NHSUSSPU15 for January 15,2012:
> =smfGetEconData("NHSUSSPU15" ,DATE(2012, 01,15))
>
> returns the correct value of "5"
>
> however the date is actually JANUARY 01, 2012.
>
> Is there any way to return a matching value of "01-01-2012" for reference
> purposes?
>
- 3c.
-
Re: exact DATE match for smfGetEconData ?
Posted by: "r d" freddy@email.com stupid21bull
Thu Mar 29, 2012 12:20 am (PDT)
yes the function works excellent, however assuming one wishes to compare data from different series...it will be helpful to import exact date references.
take for instance this example:
I wish to compare "Per Capita personal income" in California against the Far West Regional average on December 15, 2011.
the State average is published Annually
the Regional average is published Monthly
therefore if I happen to use December 15 as my date...the State stat is actually 11 months behind the Regional stat!
So it'd be helpful to therefore realize actual true dates for the stats I am importing...
(c what I mean?)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Given that data series is monthly, the day will ALWAYS be the first of the
> month.
>
> The function was written to look for the first data less than or equal to
> the passed date, to account for the possibility of weekly and monthly time
> series. So that you DIDN'T have to know the exact dates.
>
> You can always use:
>
> =smfGetEconData("NHSUSSPU15" ,"Date Range")
> =smfGetEconData("NHSUSSPU15" ,"Frequency" )
>
> ...to find out what kinds of dates are available...
>
> On Wed, Mar 28, 2012 at 5:38 PM, r d <freddy@...> wrote:
>
> > wondering if there is a way to retrieve an EXACT date match for the data
> > being retrieved?
> >
> > ie.
> > Obtaining data from NHSUSSPU15 for January 15,2012:
> > =smfGetEconData("NHSUSSPU15" ,DATE(2012, 01,15))
> >
> > returns the correct value of "5"
> >
> > however the date is actually JANUARY 01, 2012.
> >
> > Is there any way to return a matching value of "01-01-2012" for reference
> > purposes?
> >
>
- 3d.
-
Re: exact DATE match for smfGetEconData ?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Mar 29, 2012 1:07 am (PDT)
To me, that's just a matter of you knowing and understanding the data you
are retrieving. If you want to compare daily to monthly to annual, you have
to compare the data at the annual dates. If you want to compare daily to
monthly, you need to use the monthly dates. There is nothing to compare on
the other dates.
With this function, is there even any reason to use the monthly or annual
series if the daily is available? I suppose speed would be a factor if you
are retrieving a lot of different dates, since the daily file has more data
to search through.
On Thu, Mar 29, 2012 at 12:19 AM, r d <freddy@email.com > wrote:
>
> yes the function works excellent, however assuming one wishes to compare
> data from different series...it will be helpful to import exact date
> references.
>
> take for instance this example:
> I wish to compare "Per Capita personal income" in California against the
> Far West Regional average on December 15, 2011.
> the State average is published Annually
> the Regional average is published Monthly
>
> therefore if I happen to use December 15 as my date...the State stat is
> actually 11 months behind the Regional stat!
>
> So it'd be helpful to therefore realize actual true dates for the stats I
> am importing...
>
> (c what I mean?)
>
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