Senin, 21 November 2011

[smf_addin] Digest Number 2022

Messages In This Digest (10 Messages)

Messages

1a.

Reuters links will not update

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

Sun Nov 20, 2011 10:57 am (PST)



Hi Randy,
I am stuck with the Reuters historical financial statements - wonder if you had any thoughts on this. The problem is i cant seem to figure out when the Reuters will work or not. I have had it working, and sometimes it even works even after logging out of Reuters. But obviously the problem is it not updating even when logged-in. I am aware of all the previous threads and need to log into reuters before opening excel to get the cookie. I have the add-in parked in program files/SMF add-in.

I did the webquery, even wrote a workbook_open script that automatically logs me into Reuters. I logged in before opening the files, and i also tried Forcerecalculation. However, still the links wont update. I copied the address
(http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=AMGN.O) into the IE browser and it immediately opens into the 5 year history, so it works - yet using e.g. smfGetTagContent ("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=AMGN.O","td",4,"Total revenue") will result in Error.

I wonder if you had any ideas what coudl cause this?

Many thanks

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

Re: Reuters links will not update

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

Sun Nov 20, 2011 11:27 am (PST)



Not sure what to tell you -- I tried the smfGetTagContent() function you
have below and also got an error. Then I brought up the web query dialog to
visit the URL used in the function. It looked fine. Then I ran
smfForceRecalculation, and the formula recalculated with the correct value.
So it's not JUST a security cookie, because I didn't need to log in. But
apparently the cookie DID need to be refreshed. But it sounds like you did
that process, so I'm at a loss as to what might be the problem. Unless you
did some of those steps in a different order?

On Sun, Nov 20, 2011 at 10:12 AM, navelhunt <navelhunt@yahoo.com> wrote:

> Hi Randy,
> I am stuck with the Reuters historical financial statements - wonder if
> you had any thoughts on this. The problem is i cant seem to figure out when
> the Reuters will work or not. I have had it working, and sometimes it even
> works even after logging out of Reuters. But obviously the problem is it
> not updating even when logged-in. I am aware of all the previous threads
> and need to log into reuters before opening excel to get the cookie. I have
> the add-in parked in program files/SMF add-in.
>
> I did the webquery, even wrote a workbook_open script that automatically
> logs me into Reuters. I logged in before opening the files, and i also
> tried Forcerecalculation. However, still the links wont update. I copied
> the address
> (
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=AMGN.O)
> into the IE browser and it immediately opens into the 5 year history, so it
> works - yet using e.g. smfGetTagContent ("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=AMGN.O","td",4,"Total
> revenue") will result in Error.
>
> I wonder if you had any ideas what coudl cause this?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

Download Historical Technical Analysis Data

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

Sun Nov 20, 2011 1:41 pm (PST)



Is there a means by which I can download the daily historical values for EMA, RSI and other technical analysis items?

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

Re: Download Historical Technical Analysis Data

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

Sun Nov 20, 2011 2:15 pm (PST)



Check out this template:

RCHGetWebData-Template-BarChart-Quotes-Extract.xls

...but you'll need to create your own URL and extractions based on chart
settings that you create at BarChart.

On Sun, Nov 20, 2011 at 2:41 PM, thomas91112 <thomas91112@yahoo.com> wrote:

> Is there a means by which I can download the daily historical values for
> EMA, RSI and other technical analysis items?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2c.

Re: Download Historical Technical Analysis Data

Posted by: "Michael Thomas" thomas91112@yahoo.com   thomas91112

Sun Nov 20, 2011 2:39 pm (PST)



Anything available through Yahoo Finance?Thanks

--- On Sun, 11/20/11, Randy Harmelink <rharmelink@gmail.com> wrote:

From: Randy Harmelink <rharmelink@gmail.com>
Subject: Re: [smf_addin] Download Historical Technical Analysis Data
To: smf_addin@yahoogroups.com
Date: Sunday, November 20, 2011, 2:15 PM

 

Check out this template:

RCHGetWebData-Template-BarChart-Quotes-Extract.xls

...but you'll need to create your own URL and extractions based on chart settings that you create at BarChart.

On Sun, Nov 20, 2011 at 2:41 PM, thomas91112 <thomas91112@yahoo.com> wrote:

Is there a means by which I can download the daily historical values for EMA, RSI and other technical analysis items?

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

Re: Download Historical Technical Analysis Data

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

Sun Nov 20, 2011 3:22 pm (PST)



Not to download. But you can download the historical quotes and generate
the technical indicators yourself.

On Sun, Nov 20, 2011 at 3:39 PM, Michael Thomas <thomas91112@yahoo.com>wrote:

>
> Anything available through Yahoo Finance?
>
> Is there a means by which I can download the daily historical values for
> EMA, RSI and other technical analysis items?
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

Combining quarterly financial statements

Posted by: "Ilya R" ilya559@yahoo.com   ilya559

Sun Nov 20, 2011 4:49 pm (PST)



Hi all,

I am downloading quarterly financial statements using RCHGetElementNumber function. Unfortunately it only pulls data for the for the quarter period, say for example Quarter 3. What I am trying to accomplish is create combined income statement values (say for example) for the 9 months period ended 9/30/11. The way I plan on doing it, is by pulling revenues for Q1, Q2, Q3, and then using "IF" statements or somehow an array, to combine the revenue for 3 periods. Preferably, to shave calculation time, I would use an arrays, although I don't have much experience in using it.

Could anyone please advise me, on how would I code it.

many thanks

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

Re: Combining quarterly financial statements

Posted by: "Jason Brach" yitzibrach@gmail.com   yitzman23

Sun Nov 20, 2011 6:07 pm (PST)



Hi. Newbie here. I don't have much expertise with excel and am looking to
learn how to intuitively apply these functions to an excel spreadsheet. Any
tips on good tutorials/ methods for learning?
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3c.

Re: Combining quarterly financial statements

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

Sun Nov 20, 2011 6:13 pm (PST)



Just retrieve the quarterly data and use normal EXCEL formulas...? Some
sources do have TTM figures, which I would think would be better than YTD.
Especially since fiscal years don't align for all companies.

Arrays wouldn't help. Array-entering something like RCHGetYahooQuotes()
speeds things up because it gets all of the data with a single Internet
access, versus doing it one formula at a time, where each formula needs its
own Internet access. With functions like RCHGetElementNumber() and
RCHGetTableCell(), the web page is only retrieved once for all of the data
items being retrieved from that same web page -- so there would be no
advantage to doing them array-entered.

On Sun, Nov 20, 2011 at 5:49 PM, Ilya R <ilya559@yahoo.com> wrote:

>
> I am downloading quarterly financial statements using RCHGetElementNumber
> function. Unfortunately it only pulls data for the for the quarter period,
> say for example Quarter 3. What I am trying to accomplish is create
> combined income statement values (say for example) for the 9 months period
> ended 9/30/11. The way I plan on doing it, is by pulling revenues for Q1,
> Q2, Q3, and then using "IF" statements or somehow an array, to combine the
> revenue for 3 periods. Preferably, to shave calculation time, I would use
> an arrays, although I don't have much experience in using it.
>
> Could anyone please advise me, on how would I code it.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3d.

Re: Combining quarterly financial statements

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

Sun Nov 20, 2011 6:20 pm (PST)



As noted on the front page of the group:

"The "Files" area of this group contains the add-in, documentation on its
functions, and a number of templates that have examples of how the various
functions can be used. The "Links" area of the group has a number of tips
and FAQs."

...or, in the "Welcome to the group" email:

"...documentation of the various functions can be found in the
"Documentation" folder. Sample uses of add-in functions can be found in
the "Templates and Examples" folder.

Also, be sure to check out the "Links" area of the group for links to tips
and frequently asked questions."

But, to be frank, if you're not comfortable using EXCEL, using the add-in
functions may not be a trivial task.

On Sun, Nov 20, 2011 at 6:13 PM, Jason Brach <yitzibrach@gmail.com> wrote:

> Hi. Newbie here. I don't have much expertise with excel and am looking
> to learn how to intuitively apply these functions to an excel spreadsheet.
> Any tips on good tutorials/ methods for learning?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
Recent Activity
Visit Your Group
Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! News

Fashion News

What's the word on

fashion and style?

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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)