Messages In This Digest (8 Messages)
- 1.
- Happy Thanksgiving, Randy! From: timdbui
- 2a.
- Re: Problems with smfGETADVFNElement... From: zenodk_2
- 2b.
- Re: Problems with smfGETADVFNElement... From: Randy Harmelink
- 3a.
- Insert "Trends in Twitter" chart in BATS Template From: ronmac17
- 3b.
- Re: Insert "Trends in Twitter" chart in BATS Template From: Randy Harmelink
- 4a.
- Re: for us Canadians - any way to pull TSX/TSE specific data from Go From: staspmr
- 4b.
- Re: for us Canadians - any way to pull TSX/TSE specific data from Go From: Randy Harmelink
- 4c.
- Re: for us Canadians - any way to pull TSX/TSE specific data from Go From: staspmr
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
- 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..
> >
>
- 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?
>
- 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. to the BATS realtime template. I used this URL from the site http://trendistic.com/ indextank. My Comment inputs werecom/_embed- 745/ge/_24- hours.
=RCHCreateComment("http://trendistic. indextank. ",99,400,190,com/_embed- 745/ge/_24- hours 1)
No chart shows up. Not sure where I made a mistake. Could you tell what I did wrong here.
Thanks, Ron
- 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. to the BATS realtime template. I usedcom/
> this URL from the site
> http://trendistic.indextank. My Commentcom/_embed- 745/ge/_24- hours.
> 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.
>
- 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....
> >
>
- 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
>
- 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
> >
>
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