Rabu, 02 November 2011

[smf_addin] Digest Number 2004

Messages In This Digest (10 Messages)

Messages

1a.

Re: How to call smfforerecalculation macro into my user defined macr

Posted by: "codyklein" codyklein@alum.drexel.edu   codyklein

Tue Nov 1, 2011 6:52 am (PDT)



This works for me in a sub:
Run [smfforcerecalculation()]

--- In smf_addin@yahoogroups.com, "curls07" <agc11d@...> wrote:
>
> Hey Guys,
>
> I'm trying to call smfforerecalculation into one of my vba functions using Run.[modUtilities.smfForceRecalculation], 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.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2a.

Re: VIX in Google

Posted by: "paul messerschmidt" financepaul@gmail.com   fuelspotpaul

Tue Nov 1, 2011 8:14 am (PDT)



this may be an issue related to quote data vendors and associated
contractual limitations for redistribution.

for example, this is posted on the cboe website (owner of the VIX and
related products/indices)

*PLEASE NOTE: IT IS STRICTLY PROHIBITED TO DOWNLOAD DELAYED QUOTE TABLE
DATA FROM THIS WEB SITE BY USING AUTO-EXTRACTION PROGRAMS/QUERIES AND/OR
SOFTWARE. CBOE WILL BLOCK IP ADDRESSES OF ALL PARTIES WHO ATTEMPT TO DO SO.
THIS DATA IS PROPERTY OF THOMSON REUTERS. DOWNLOADING THIS DATA IN ANY
OTHER WAY THAN BY MANUAL TICKER SYMBOL ENTRY IS STRICTLY PROHIBITED.*
*
*
***
*note that thomson reuters is the data vendor, and they supply yahoo, where
you can access VIX with symbol ^VIX.

it is not clear to me the source for google quotes.

good trading...

On Mon, Oct 31, 2011 at 1:09 PM, David <who1012000@yahoo.com> wrote:

> **
>
>
> 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
>
>
>

--
-----------------------------------------
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

List of functions

Posted by: "cooper" cooper0017@yahoo.com   cooper0017

Tue Nov 1, 2011 11:09 am (PDT)



I am new to this site. Is there a place that all the functions are listed?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.

Re: List of functions

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 1, 2011 11:33 am (PDT)



Best place is to visit the "Documentation" folder of the files area. Also,
this may be of help:

http://finance.groups.yahoo.com/group/smf_addin/message/10059

On Fri, Oct 21, 2011 at 10:02 AM, cooper <cooper0017@yahoo.com> wrote:

> I am new to this site. Is there a place that all the functions are listed?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Re: SMFForceRecalculation

Posted by: "adam pilz" adampilz.2326@gmail.com   pilzadam

Tue Nov 1, 2011 12:16 pm (PDT)



Randy,

I have upgraded to the beta version. I can get the the google worksheets
to work now but I have to manipulate the contents of every cell on the
sheet first. For Instance, the cells are currently reporting "#NAME?"
because every cell has

='C:\Program Files\SMF
Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker, 3614)

in it. When I delete the first part and leave only

=RCHGetElementNumber(Ticker, 3614)

the worksheet works. Is there a reason why the

='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!

portion is coming up? And just for good measure, when I enter
=smfgetaparms(3386) the following is returned:

Google;Annual Income Statement -- Interest Income (Expense), Net
Non-Operating -- FY1;
http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCANNUALDIV;InterestIncome(Expense),
Net
Non-Operating; ; ;0;</TABLE;0;0

Thanks so much,
Adam

On Mon, Oct 31, 2011 at 8:22 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> 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?
>>
>>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4b.

Re: SMFForceRecalculation

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 1, 2011 1:33 pm (PDT)



See the "Location Errors" entry in the "Links" section of the group. It's
an EXCEL thing.

On Tue, Nov 1, 2011 at 12:16 PM, adam pilz <adampilz.2326@gmail.com> wrote:

>
> I have upgraded to the beta version. I can get the the google worksheets
> to work now but I have to manipulate the contents of every cell on the
> sheet first. For Instance, the cells are currently reporting "#NAME?"
> because every cell has
>
> ='C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker, 3614)
>
> in it. When I delete the first part and leave only
>
> =RCHGetElementNumber(Ticker, 3614)
>
> the worksheet works. Is there a reason why the
>
> ='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!
>
> portion is coming up?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
5a.

RCHGetElementNumber Returning "Error"

Posted by: "e_bartsch" eabartsch@comcast.net   e_bartsch

Tue Nov 1, 2011 7:22 pm (PDT)



Randy:

RCHGetElementNumber is returning an "Error" message for elements 798 & 799. If there has a been a post about this already, I apologize in advance.

Is there a fix? 799 and 798 finger the 80 day support and resistance technical points for a security.

Thanks much for the help.

Eric

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5b.

Re: RCHGetElementNumber Returning "Error"

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 1, 2011 7:49 pm (PDT)



Someone just noted that the other day. Stockhouse has removed their web
page with technical analysis data items.

No replacement that I'm aware of. The other person did ask about using the
barchart.com data items, but those data points don't necessarily have the
same meaning.

http://finance.groups.yahoo.com/group/smf_addin/messages/16163?threaded=1&m=e&var=1&tidx=1

On Tue, Nov 1, 2011 at 7:22 PM, e_bartsch <eabartsch@comcast.net> wrote:

>
> RCHGetElementNumber is returning an "Error" message for elements 798 &
> 799. If there has a been a post about this already, I apologize in advance.
>
> Is there a fix? 799 and 798 finger the 80 day support and resistance
> technical points for a security.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6a.

Re: which function can i use to extract a picture

Posted by: "Miguel" spectratecharchitecture@gmail.com   spectratecharchitecture

Tue Nov 1, 2011 8:37 pm (PDT)



thank you, is there a specific website that you have found that has the best charts?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> To extract the chart, you need the URL of the image. Check the documentation
> for RCHCreateComment().
>
> For example, in its simplest form for the chart on the web page you noted:
>
> =RCHCreateComment("
> http://chart.finance.yahoo.com/z?s=IXN&t=2y&q=c&l=on&z=l&p=m50,m200&a=v&lang=en-US&region=US
> ",99)
>
> On Fri, Oct 21, 2011 at 12:07 PM, spectratecharchitecture <
> spectratecharchitecture@...> wrote:
>
> >
> > I was wondering which function i could use to extract a chart in the
> > form of a png. the webpage IS bookmarkable (
> > http://finance.yahoo.com/q/bc?s=IXN&t=2y&l=on&z=l&q=c&c= )
> > and i can modify the parameters in the link to change the stock, time and
> > time frame. Just wanted to know which function would be best to get that
> > picture chart into excel.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
6b.

Re: which function can i use to extract a picture

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 1, 2011 8:59 pm (PDT)



I tend to use StockCharts.com

On Fri, Oct 21, 2011 at 1:28 PM, Miguel
<spectratecharchitecture@gmail.com>wrote:

> thank you, is there a specific website that you have found that has the
> best charts?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 02.47

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)