Jumat, 25 November 2011

[smf_addin] Digest Number 2026

Messages In This Digest (8 Messages)

Messages

1.

Happy Thanksgiving, Randy!

Posted by: "timdbui" timdbui@gmail.com   timdbui

Thu Nov 24, 2011 5:00 am (PST)



Happy Thanksgiving and thank you for your work in updating the add-in program for all of us, Randy! Much appreciation for your contributions.

Tim

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

Re: Problems with smfGETADVFNElement...

Posted by: "zenodk_2" madsdsl@gmail.com   zenodk_2

Thu Nov 24, 2011 7:49 am (PST)



Any other advices? The other functions works or me, but smfGetADVFNElement all of a sudden returns "Error", no matter what i try out.... anyone ever tried that?

Thanks,

ZenoDK

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I just tried your example function with ticker symbols DV and MMM and both
> worked fine here.
>
> As a possible solution/problem, check out the AdvFN item in the "Links"
> area of the group...
>
> On Wed, Nov 23, 2011 at 11:02 AM, zenodk_2 <madsdsl@...> wrote:
>
> >
> > I have used a spreadsheet for months where I rely heavily on the use of
> > smfGETADVFNElement...
> >
> > Then all of a sudden yesterday, the spreadsheet didn't return anything on
> > that command anymore. All my smfGETADVFNElement returns "Error". How could
> > that be? I haven't changed anything in the spreadsheet at all.
> >
> > An example of my syntax:
> > =smfGetADVFNElement(B186,"A",$U$1,">Total Revenue<")
> >
> > All other functions in the spreadsheet works. For example
> > =RCHGetYahooQuotes("DV","r")... but for smfGETADVFNElement, I only get
> > "error"....
> >
> > Any advice would be very much appreciated..
> >
>

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

Re: Problems with smfGETADVFNElement...

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

Thu Nov 24, 2011 9:34 am (PST)



Did you try the "Links" item?

On Thu, Nov 24, 2011 at 8:49 AM, zenodk_2 <madsdsl@gmail.com> wrote:

> Any other advices? The other functions works or me, but smfGetADVFNElement
> all of a sudden returns "Error", no matter what i try out.... anyone ever
> tried that?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

Insert "Trends in Twitter" chart in BATS Template

Posted by: "ronmac17" ronmac17@yahoo.com   ronmac17

Thu Nov 24, 2011 11:40 am (PST)



Randy, I wanted to add a chart from Trendistic http://trendistic.indextank.com/ to the BATS realtime template. I used this URL from the site http://trendistic.indextank.com/_embed-745/ge/_24-hours. My Comment inputs were
=RCHCreateComment("http://trendistic.indextank.com/_embed-745/ge/_24-hours",99,400,190,1)
No chart shows up. Not sure where I made a mistake. Could you tell what I did wrong here.
Thanks, Ron

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

Re: Insert "Trends in Twitter" chart in BATS Template

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

Thu Nov 24, 2011 11:51 am (PST)



Try the URL you're using in your browser:

http://trendistic.indextank.com/_embed-745/ge/_24-hours

I don't see an image. I get the text of a script. When I visit the web page
that has the chart on it, my browser doesn't identify the chart as an
image. I don't see a picture there that EXCEL can import.

On Thu, Nov 24, 2011 at 12:40 PM, ronmac17 <ronmac17@yahoo.com> wrote:

> Randy, I wanted to add a chart from Trendistic
> http://trendistic.indextank.com/ to the BATS realtime template. I used
> this URL from the site
> http://trendistic.indextank.com/_embed-745/ge/_24-hours. My Comment
> inputs were
> =RCHCreateComment("http://trendistic.indextank.com/_embed-745/ge/_24-hours
> ",99,400,190,1)
> No chart shows up. Not sure where I made a mistake. Could you tell what I
> did wrong here.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Re: for us Canadians - any way to pull TSX/TSE specific data from Go

Posted by: "staspmr" staspmr@yahoo.ca   staspmr

Thu Nov 24, 2011 3:33 pm (PST)




Oh great - advFN works now!
are there similar steps for other sites such as morningstar? I'm getting by ok on msn, but still trying to get canadian stocks to work with other sites

thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Take a look at the "Links" area of the group. There is an AdvFN link there
> about a Windows Update that stops AdvFN from working. But you can change
> your Internet settings. Hopefully, that's the issue?
>
> The 2.1.2011.11.23 is an exact copy of what I am using right now. I just
> uploaded it this morning with all of my updated files, because of an issue
> with quarter-end options retrieval that I fixed.
>
> On Wed, Nov 23, 2011 at 4:27 PM, staspmr <staspmr@...> wrote:
>
> > strange, I tried exactly that, and even copied your exact formula, and it
> > still gives me an error.
> >
> > I am located in Toronto, don't think that should be a problem. Come to
> > think of it, it doesn't even work for us stocks, e.g. ibm
> >
> > What version of the tools are you using? i just updated again to the
> > 2.1.2011.11.23 version, and still same problem....
> >
>

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

Re: for us Canadians - any way to pull TSX/TSE specific data from Go

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

Thu Nov 24, 2011 3:38 pm (PST)



Morningstar would need the "XTSE:" prefix on the ticker symbol.

On Thu, Nov 24, 2011 at 4:33 PM, staspmr <staspmr@yahoo.ca> wrote:

>
> Oh great - advFN works now!
> are there similar steps for other sites such as morningstar? I'm getting
> by ok on msn, but still trying to get canadian stocks to work with other
> sites
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4c.

Re: for us Canadians - any way to pull TSX/TSE specific data from Go

Posted by: "staspmr" staspmr@yahoo.ca   staspmr

Thu Nov 24, 2011 3:55 pm (PST)



no, still doesn't work for some reason. pulls data for the US counterparts just fine though. at one point I thought I was getting the proper data, turns out it was the same ticker on the NYSE, lol. good thing I checked.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Morningstar would need the "XTSE:" prefix on the ticker symbol.
>
> On Thu, Nov 24, 2011 at 4:33 PM, staspmr <staspmr@...> wrote:
>
> >
> > Oh great - advFN works now!
> > are there similar steps for other sites such as morningstar? I'm getting
> > by ok on msn, but still trying to get canadian stocks to work with other
> > sites
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
Recent Activity
Visit Your Group
New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! News

Odd News

You won't believe

it, but it's true

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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.06

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)