13 New Messages
Digest #2368
| 4b Re: Any Way to Retrieve Arbitrary Parts of Balance Sheet and Income by "Randy Harmelink" rharmelink 6b Re: problem with RCHGetHTMLTable for reuters.com and market.ft.com [ by "Randy Harmelink" rharmelink 6d Re: problem with RCHGetHTMLTable for reuters.com and market.ft.com by "Randy Harmelink" rharmelink |
Messages
Mon Oct 8, 2012 9:28 am (PDT) . Posted by:
"Randy H" rharmelink
As per the documentation, you would change the "A" parameter to a "C" in
the RCHGetYahooHistory() function. The smfPricesByDates() function only
returns adjusted closing prices.
On Mon, Oct 8, 2012 at 9:02 AM, Wayne Lewis <wlewis@la-fl.com
<mailto:wlewis@la-fl.com > > wrote:
Thanks a lot!!
This gets me pretty close. The price your function retrieves is
"adj close", not the actual "close". I haven't had a chance to
think this through of which is best for what I want to do. What
call would you use to get the actual close?
On 10/8/2012 11:41 AM, Randy Harmelink wrote:
You can use either RCHGetYahooHistory() or
smfPricesByDates(). For example, either of these would
retrieve the adjusted closing price from last Monday:
=RCHGetYahooHistory("MMM",2012,8,1,2012,8,1,,"A",0)
=smfPricesByDates("MMM","8/1/2012")
the RCHGetYahooHistory(
returns adjusted closing prices.
On Mon, Oct 8, 2012 at 9:02 AM, Wayne Lewis <wlewis@la-fl.
<mailto:wlewis@la-fl.
Thanks a lot!!
This gets me pretty close. The price your function retrieves is
"adj close", not the actual "close". I haven't had a chance to
think this through of which is best for what I want to do. What
call would you use to get the actual close?
On 10/8/2012 11:41 AM, Randy Harmelink wrote:
You can use either RCHGetYahooHistory(
smfPricesByDates(
retrieve the adjusted closing price from last Monday:
=RCHGetYahooHistory
=smfPricesByDates(
Mon Oct 8, 2012 9:34 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not easily...this would tell you if the first slot was used (0/1 values):
=--(smfGetAData(1,2)>"")
You'd need to vary the 1 from 1 to 1000 to could how many slots were used.
On Mon, Oct 8, 2012 at 9:11 AM, codyklein <codyklein@alum.drexel.edu > wrote:
> Is there a way to return this number to see where one is at. In my case I
> have a spreadsheet where its impossible to tell due to all the vba code and
> just the entire structure. I always thought I was well below the limit but
> suspect I'm am hitting it. Anyway it would be good to know how many web
> pages have been downloaded.
>
=--(smfGetAData(
You'd need to vary the 1 from 1 to 1000 to could how many slots were used.
On Mon, Oct 8, 2012 at 9:11 AM, codyklein <codyklein@alum.
> Is there a way to return this number to see where one is at. In my case I
> have a spreadsheet where its impossible to tell due to all the vba code and
> just the entire structure. I always thought I was well below the limit but
> suspect I'm am hitting it. Anyway it would be good to know how many web
> pages have been downloaded.
>
Mon Oct 8, 2012 9:35 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
See: http://finance.groups.yahoo.com/group/smf_addin/message/19858
On Mon, Oct 8, 2012 at 8:54 AM, Chris Ball <crball02@gmail.com > wrote:
>
> I am trying to use the add in and keep recieving the errors for some
> formulas, here are a couple of examples:
>
> =RCHGetElementNumber(Ticker,25)
> =RCHGetElementNumber(Ticker,48)
> =RCHGetElementNumber(Ticker,84)
> =RCHGetElementNumber(Ticker,AN12)
>
> I am using version 2.1.2012.04.07
>
> Any help is greatly appreciated.
>
On Mon, Oct 8, 2012 at 8:54 AM, Chris Ball <crball02@gmail.
>
> I am trying to use the add in and keep recieving the errors for some
> formulas, here are a couple of examples:
>
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> =RCHGetElementNumbe
>
> I am using version 2.1.2012.04.
>
> Any help is greatly appreciated.
>
Mon Oct 8, 2012 1:19 pm (PDT) . Posted by:
"westes2" westes2
I'm trying to build a financial model that will be shared by people all over the world. Making 20 copies of a spreadsheet that is constantly changing isn't a smart maintenance model....
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Doubtful. It uses some Windows reference libraries.
>
> You can't install EXCEL there, can you?
>
> On Mon, Oct 8, 2012 at 3:50 AM, westes2 <westes@...> wrote:
>
> > Will your functions work in a cloud environment in something like Windows
> > SkyDrive?
> >
>
--- In smf_addin@yahoogrou
>
> Doubtful. It uses some Windows reference libraries.
>
> You can't install EXCEL there, can you?
>
> On Mon, Oct 8, 2012 at 3:50 AM, westes2 <westes@...> wrote:
>
> > Will your functions work in a cloud environment in something like Windows
> > SkyDrive?
> >
>
Mon Oct 8, 2012 1:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The spreadsheets can be located almost anywhere. The add-in can be located
almost anywhere. However, if you open a spreadsheet with the add-in in a
different location than when it was saved, then you need to manually edit
all of the unresolved links.
But each user would have to have their own installed version of EXCEL, with
the add-in activated.
On Mon, Oct 8, 2012 at 1:19 PM, westes2 <westes@earthbroadcast.com > wrote:
> I'm trying to build a financial model that will be shared by people all
> over the world. Making 20 copies of a spreadsheet that is constantly
> changing isn't a smart maintenance model....
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Doubtful. It uses some Windows reference libraries.
> >
> > You can't install EXCEL there, can you?
> >
> > On Mon, Oct 8, 2012 at 3:50 AM, westes2 <westes@...> wrote:
> >
> > > Will your functions work in a cloud environment in something like
> Windows
> > > SkyDrive?
>
almost anywhere. However, if you open a spreadsheet with the add-in in a
different location than when it was saved, then you need to manually edit
all of the unresolved links.
But each user would have to have their own installed version of EXCEL, with
the add-in activated.
On Mon, Oct 8, 2012 at 1:19 PM, westes2 <westes@earthbroadca
> I'm trying to build a financial model that will be shared by people all
> over the world. Making 20 copies of a spreadsheet that is constantly
> changing isn't a smart maintenance model....
>
> --- In smf_addin@yahoogrou
> >
> > Doubtful. It uses some Windows reference libraries.
> >
> > You can't install EXCEL there, can you?
> >
> > On Mon, Oct 8, 2012 at 3:50 AM, westes2 <westes@...> wrote:
> >
> > > Will your functions work in a cloud environment in something like
> Windows
> > > SkyDrive?
>
Mon Oct 8, 2012 2:37 pm (PDT) . Posted by:
"Pete A" option2z
> > Will your functions work in a cloud environment in something like Windows
> > SkyDrive?
I use skydrive with excel, and it does some awesome things for simple excel spreadsheets. But I can't see how it would access ANY add-in. There is no process available, and it really isn't doing "Excel" as per your machine. It is running serverside processes that process a spreadsheet into either "embed code/iframe" or javascript.
Here's a link to a blog post I wrote to illustrate sky drive's implementation of excel sheet sharing for some of my investment group:
http://www.sundogno
You will be able to use a spreadsheet without having excel on your computer (and it has a download option too). It IS limited in functionality though, but I find it useful.
Pete A
Mon Oct 8, 2012 9:52 pm (PDT) . Posted by:
"Neil" dj_nil99
hello any one send me all type of automatic calculation excel sheet i cant get any where pls help me
Thanx
Neil
____________
From: westes2 <westes@earthbroadca
To: smf_addin@yahoogrou
Sent: Tuesday, October 9, 2012 1:49 AM
Subject: [smf_addin] Re: Any Way to Retrieve Arbitrary Parts of Balance Sheet and Income Statement?
I'm trying to build a financial model that will be shared by people all over the world. Making 20 copies of a spreadsheet that is constantly changing isn't a smart maintenance model....
--- In smf_addin@yahoogrou
>
> Doubtful. It uses some Windows reference libraries.
>
> You can't install EXCEL there, can you?
>
> On Mon, Oct 8, 2012 at 3:50 AM, westes2 <westes@...> wrote:
>
> > Will your functions work in a cloud environment in something like Windows
> > SkyDrive?
> >
>
Mon Oct 8, 2012 1:28 pm (PDT) . Posted by:
"Xin L" liucyndy
Randy,
Thanks a lot for this great tool. But I met a problem as I used it for the first time: all data cells got "Error" message. I do not know where should I input ticker to let those cells have valid data. Please advise.
Thanks a lot!
Cindy
Thanks a lot for this great tool. But I met a problem as I used it for the first time: all data cells got "Error" message. I do not know where should I input ticker to let those cells have valid data. Please advise.
Thanks a lot!
Cindy
Mon Oct 8, 2012 1:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The yellow-shaded cell is for the ticker symbol.
If you still get "Error" results, take a look at the "Location error" item
in the LINKS area of the Yahoo group...
On Mon, Oct 8, 2012 at 12:57 PM, Xin L <jgr1230@gmail.com > wrote:
>
> Thanks a lot for this great tool. But I met a problem as I used it for the
> first time: all data cells got "Error" message. I do not know where should
> I input ticker to let those cells have valid data. Please advise.
>
If you still get "Error" results, take a look at the "Location error" item
in the LINKS area of the Yahoo group...
On Mon, Oct 8, 2012 at 12:57 PM, Xin L <jgr1230@gmail.
>
> Thanks a lot for this great tool. But I met a problem as I used it for the
> first time: all data cells got "Error" message. I do not know where should
> I input ticker to let those cells have valid data. Please advise.
>
Tue Oct 9, 2012 1:13 am (PDT) . Posted by:
"it's p²n" dlx_0lb
I'm using RCH_Stock_Market_Functions-2.1.2012.02.02
This is my target :
=RCHGetHTMLTable("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=TICKER ","In Millions of",-1,"",1)
and
=RCHGetHTMLTable("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=TICKER ","In Millions of",-1,"",1)
It worked fine for first Ticker : APPLE
=RCHGetHTMLTable("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=AAPL.O ","In Millions of",-1,"",1)
=RCHGetHTMLTable("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=AAPL.O ","In Millions of",-1,"",1)
but return blanks for GOGGLE and YAHOO
=RCHGetHTMLTable("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=GOOG.O ","In
Millions of",-1,"",1)
=RCHGetHTMLTable("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=GOOG.O ","In
Millions of",-1,"",1)
=RCHGetHTMLTable("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=YHOO.O ","In
Millions of",-1,"",1)
=RCHGetHTMLTable("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=YHOO.O ","In
Millions of",-1,"",1)
My file in attachment
________________________________
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Monday, October 8, 2012 7:23 AM
Subject: Re: [smf_addin] problem with RCHGetHTMLTable for reuters.com and market.ft.com
Can you give me two example formulas, where the first one works fine and the second one returns blanks? Preferably from reuters.com.
Also, which version of the add-in are you running?
On Tue, Sep 25, 2012 at 6:20 PM, dlx_0lb <dlx_0lb@yahoo.com > wrote:
>I signed up to reuters.com and market.ft.com and , I log into reuters.com and market.ft.com via Excel Web Query, and start using RCHGetHTMLTable function.
>It worked fine for the first ticker, but return blanks for the rest.
>Delete all of cookies, history, temporary files etc, relog, but it worked for another first ticker.
>Any idea ?
>
This is my target :
=RCHGetHTMLTable(
and
=RCHGetHTMLTable(
It worked fine for first Ticker : APPLE
=RCHGetHTMLTable(
=RCHGetHTMLTable(
but return blanks for GOGGLE and YAHOO
=RCHGetHTMLTable(
Millions of",-1,"",1)
=RCHGetHTMLTable(
Millions of",-1,"",1)
=RCHGetHTMLTable(
Millions of",-1,"",1)
=RCHGetHTMLTable(
Millions of",-1,"",1)
My file in attachment
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Monday, October 8, 2012 7:23 AM
Subject: Re: [smf_addin] problem with RCHGetHTMLTable for reuters.com and market.ft.com
Can you give me two example formulas, where the first one works fine and the second one returns blanks? Preferably from reuters.com.
Also, which version of the add-in are you running?
On Tue, Sep 25, 2012 at 6:20 PM, dlx_0lb <dlx_0lb@yahoo.
>I signed up to reuters.com and market.ft.com and , I log into reuters.com and market.ft.com via Excel Web Query, and start using RCHGetHTMLTable function.
>It worked fine for the first ticker, but return blanks for the rest.
>Delete all of cookies, history, temporary files etc, relog, but it worked for another first ticker.
>Any idea ?
>
Attachments with this message:
1 of 1 File(s)
Tue Oct 9, 2012 1:24 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure what to tell you -- all of the sheets worked fine here...
For the way you're doing the processing, it may make more sense to put
values into the workbook, rather than the formula. For example, something
like:
Range("A1:F100") = RCHGetHTMLTable("
http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=YHOO.O ",
"In Millions of", -1, "", 1, pDim1:=100, pDim2:=6)
On Tue, Oct 9, 2012 at 12:51 AM, it's p²n <dlx_0lb@yahoo.com > wrote:
>
> I'm using RCH_Stock_Market_Functions-2.1.2012.02.02
>
> This is my target :
> =RCHGetHTMLTable("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=
> TICKER","In Millions of",-1,"",1)
> and
> =RCHGetHTMLTable("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=
> TICKER","In Millions of",-1,"",1)
>
> It worked fine for first Ticker : APPLE
> =RCHGetHTMLTable("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=AAPL.O ","In
> Millions of",-1,"",1)
> =RCHGetHTMLTable("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=AAPL.O ","In
> Millions of",-1,"",1)
>
> but return blanks for GOGGLE and YAHOO
> =RCHGetHTMLTable("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=GOOG.O ","In
> Millions of",-1,"",1)
> =RCHGetHTMLTable("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=GOOG.O ","In
> Millions of",-1,"",1)
> =RCHGetHTMLTable("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=YHOO.O ","In
> Millions of",-1,"",1)
> =RCHGetHTMLTable("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=YHOO.O ","In
> Millions of",-1,"",1)
>
> My file in attachment
>
For the way you're doing the processing, it may make more sense to put
values into the workbook, rather than the formula. For example, something
like:
Range("A1:F100"
http://www.reuters.
"In Millions of", -1, "", 1, pDim1:=100, pDim2:=6)
On Tue, Oct 9, 2012 at 12:51 AM, it's p²n <dlx_0lb@yahoo.
>
> I'm using RCH_Stock_Market_
>
> This is my target :
> =RCHGetHTMLTable(
> http://www.reuters.
> TICKER","In Millions of",-1,"",1)
> and
> =RCHGetHTMLTable(
> http://www.reuters.
> TICKER","In Millions of",-1,"",1)
>
> It worked fine for first Ticker : APPLE
> =RCHGetHTMLTable(
> http://www.reuters.
> Millions of",-1,"",1)
> =RCHGetHTMLTable(
> http://www.reuters.
> Millions of",-1,"",1)
>
> but return blanks for GOGGLE and YAHOO
> =RCHGetHTMLTable(
> http://www.reuters.
> Millions of",-1,"",1)
> =RCHGetHTMLTable(
> http://www.reuters.
> Millions of",-1,"",1)
> =RCHGetHTMLTable(
> http://www.reuters.
> Millions of",-1,"",1)
> =RCHGetHTMLTable(
> http://www.reuters.
> Millions of",-1,"",1)
>
> My file in attachment
>
Tue Oct 9, 2012 2:57 am (PDT) . Posted by:
"p²n" dlx_0lb
no luck, I got compile error message "Sub or Function not Defined" with your formula. maybe it's a VB string "" problem
anyway I tried to browse http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=GOOG.O via excel web query, I close and reopen my excel file, the result for Google interim income statement show up like a charm. The same result for another query.
but i don't want to open each ticker page via excel web query. any idea ?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Not sure what to tell you -- all of the sheets worked fine here...
>
> For the way you're doing the processing, it may make more sense to put
> values into the workbook, rather than the formula. For example, something
> like:
>
> Range("A1:F100") = RCHGetHTMLTable("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=YHOO.O ",
> "In Millions of", -1, "", 1, pDim1:=100, pDim2:=6)
anyway I tried to browse http://www.reuters.
but i don't want to open each ticker page via excel web query. any idea ?
--- In smf_addin@yahoogrou
>
> Not sure what to tell you -- all of the sheets worked fine here...
>
> For the way you're doing the processing, it may make more sense to put
> values into the workbook, rather than the formula. For example, something
> like:
>
> Range("A1:F100"
> http://www.reuters.
> "In Millions of", -1, "", 1, pDim1:=100, pDim2:=6)
Tue Oct 9, 2012 3:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to set up the add-in as a reference library in the VBA project in
order to use its functions...
On Tue, Oct 9, 2012 at 2:57 AM, p²n <dlx_0lb@yahoo.com > wrote:
> no luck, I got compile error message "Sub or Function not Defined" with
> your formula. maybe it's a VB string "" problem
>
> anyway I tried to browse
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=INT&symbol=GOOG.Ovia excel web query, I close and reopen my excel file, the result for
> Google interim income statement show up like a charm. The same result for
> another query.
>
> but i don't want to open each ticker page via excel web query. any idea ?
>
order to use its functions...
On Tue, Oct 9, 2012 at 2:57 AM, p²n <dlx_0lb@yahoo.
> no luck, I got compile error message "Sub or Function not Defined" with
> your formula. maybe it's a VB string "" problem
>
> anyway I tried to browse
> http://www.reuters.
> Google interim income statement show up like a charm. The same result for
> another query.
>
> but i don't want to open each ticker page via excel web query. any idea ?
>
Tidak ada komentar:
Posting Komentar