Messages In This Digest (8 Messages)
- 1.
- VIX in Google From: David
- 2a.
- Re: IPO Date information From: curls07
- 3a.
- How to call smfforerecalculation macro into my user defined macro From: curls07
- 3b.
- Re: How to call smfforerecalculation macro into my user defined macr From: Randy Harmelink
- 4a.
- The Name Field is Too Short From: thomas91112
- 4b.
- Re: The Name Field is Too Short From: Randy Harmelink
- 5a.
- Re: SMFForceRecalculation From: adam pilz
- 5b.
- Re: SMFForceRecalculation From: Randy Harmelink
Messages
- 1.
-
VIX in Google
Posted by: "David" who1012000@yahoo.com who1012000
Mon Oct 31, 2011 10:09 am (PDT)
Hi Guys,
Is the VIX available from Google finance. I tried to look it up, but could not find it. Maybe it is not there.
Thanks,
David
- 2a.
-
Re: IPO Date information
Posted by: "curls07" agc11d@gmail.com curls07
Mon Oct 31, 2011 11:01 am (PDT)
Thanks so much for both of your help. It worked like a charm!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Not really. I originally added the pDim1 and pDim2 parameters to
> array-entered functions so that they could be used as VBA subroutines by
> other VBA routines -- otherwise, the size of the returned array is
> determined by the range the function is entered into.
>
> Basically, they're the number of rows and columns of data that the function
> should return.
>
> On Fri, Oct 28, 2011 at 11:37 AM, Ron Spruell <hashky@...> wrote:
>
> >
> > After seeing your answer, I realized I was wrong. Do you have to last 2
> > inputs, 600 and 1, documented some place?
> >
> > --------------------- ---------
> > *From:* Randy Harmelink <rharmelink@...>
> > *To:* smf_addin@yahoogroups.com
> > *Sent:* Thursday, October 27, 2011 10:55 AM
> > *Subject:* Re: [smf_addin] IPO Date information
> >
> >
> > I think this would get you the date of the first trading date from Yahoo's
> > historical quotes:
> >
> > =RCHGetYahooHistory("MMM",,, ,,,,"m"," D",0,,1,600, 1)
> >
> >
>
- 3a.
-
How to call smfforerecalculation macro into my user defined macro
Posted by: "curls07" agc11d@gmail.com curls07
Mon Oct 31, 2011 11:14 am (PDT)
Hey Guys,
I'm trying to call smfforerecalculation into one of my vba functions using Run.[modUtilities. smfForceRecalcul ation], DoCmd. and application. run
None of these can successfully call the macro, and copying the macro into the function doesn't work either.
There a unique way I should call the function in, because of the add in?
-Thanks for your time.
- 3b.
-
Re: How to call smfforerecalculation macro into my user defined macr
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Oct 31, 2011 11:27 am (PDT)
In order to execute add-in routines and functions from VBA, you need to add
the add-in to your list of referenced libraries.
On Mon, Oct 31, 2011 at 11:14 AM, curls07 <agc11d@gmail.com > wrote:
>
> I'm trying to call smfforerecalculation into one of my vba functions using
> Run.[modUtilities.smfForceRecalcul ation], DoCmd. and application. run
>
> None of these can successfully call the macro, and copying the macro into
> the function doesn't work either.
>
> There a unique way I should call the function in, because of the add in?
>
- 4a.
-
The Name Field is Too Short
Posted by: "thomas91112" thomas91112@yahoo.com thomas91112
Mon Oct 31, 2011 11:18 am (PDT)
Using GetYahooQuotes, find the Name field is too short to present the full name. Some Names are so long that the display is insufficient to identify the security. Can the Name field width be increased?
- 4b.
-
Re: The Name Field is Too Short
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Oct 31, 2011 11:29 am (PDT)
Sorry, but that's what Yahoo provides. If you find a source you like
better, you can bring it in with other functions. However, it will be much
slower than RCHGetYahooQuotes(), since it can get multiple data items on
multiple tickers with a single Internet access. However, you may only need
to do it once...
On Mon, Oct 31, 2011 at 11:17 AM, thomas91112 <thomas91112@yahoo.com > wrote:
> Using GetYahooQuotes, find the Name field is too short to present the full
> name. Some Names are so long that the display is insufficient to identify
> the security. Can the Name field width be increased?
>
- 5a.
-
Re: SMFForceRecalculation
Posted by: "adam pilz" adampilz.2326@gmail.com pilzadam
Mon Oct 31, 2011 5:03 pm (PDT)
Randy,
I have been having problems getting the good element numbers to work. I
have updated the element numbers, ran the smfForceRecalculation macro, and
when I use the diagnostic
=smfGetAParms(3386)
I get the correct "Google Annual Income Statement- interest income
(expense)...."
Any other thoughts? Is reinstalling a possibility?
Thanks so much
Adam
On Thu, Oct 27, 2011 at 11:48 AM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> For the Google issue, you may need the new element definitions from the
> "Works in Progress" folder. Otherwise, the errors may be caused by the
> ticker symbols you're going after. Without more details, it's impossible
> for me to say.
>
> One diagnostic function I have is:
>
> =smfGetAParms(951)
>
> ...which would tell you the definition of element #951, so you could check
> to see what is loaded. In my case:
>
> YahooKS;Most Recent Quarter;
> http://finance.yahoo.com/ HIGHLIGHTS;MOST RECENTq/ks?s=~~ ~~~;1;FINANCIAL
> QUARTER; ; ;0;0;0;0
>
>
> On Thu, Oct 27, 2011 at 8:11 AM, adam pilz <adampilz.2326@gmail.com >wrote:
>
>>
>> Yes I am have questions about this also. When trying to update the
>> element numbers I did the "Alt-F8" step and typed in
>> "smfForceRecalculation." I seemed like something was working but the new
>> element numbers did not update and the google spreadsheets are still
>> reporting "error" in the cells. Any info? (of course please answer Ron's
>> questions first)
>>
>
>
>
- 5b.
-
Re: SMFForceRecalculation
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Oct 31, 2011 5:22 pm (PDT)
Reinstalling shouldn't help at all. But you could install the newer beta
version from the "Works in Progress" folder. Otherwise, give me the FULL
result of the function:
=smfGetAParms(3386)
I though you said you were having trouble loading NEW elements. Are you
using the updated element definitions I mentioned?
On Mon, Oct 31, 2011 at 5:03 PM, adam pilz <adampilz.2326@gmail.com > wrote:
>
> I have been having problems getting the good element numbers to work. I
> have updated the element numbers, ran the smfForceRecalculation macro, and
> when I use the diagnostic
>
> =smfGetAParms(3386)
>
> I get the correct "Google Annual Income Statement- interest income
> (expense)...."
>
> Any other thoughts? Is reinstalling a possibility?
>
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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