Minggu, 22 April 2012

[smf_addin] Digest Number 2184

Messages In This Digest (8 Messages)

Messages

1.

SMF Addins for reporting on web

Posted by: "Ishaque Ketekar" ishaqueketekar@gmail.com   ishaqueketekar

Sat Apr 21, 2012 2:29 am (PDT)



Hello Group

I am looking to save master excel as template on web server where we have formulas, RCH functions and supply input for specific cells in worksheet and leverage Excel to do the calculation. Also using PHPExcel class retrieve the calculated values to display on web and generate graphs like line/chart etc.

Currently what have done is replicated RCH Stock Market functions in PHP and instead we would like to leverage the excel itself if possible.

appreciate your help in advance.

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

Re: Using SMF Add-in over multiple worksheets

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

Sat Apr 21, 2012 4:12 am (PDT)



I use a lot of Tabs (multiple worksheets). I also use single worksheets. The main reason is to use multiple is to separate the slow retrievals from the fast. If you combine both fast and slow on one worksheet, then when you have problems with Internet Timeouts it really shows up. Yahoo limits the data feeds (IMO).

If I use multiple worksheets, I can go to the Tab and hit <Shift-F9> and recalculate just that sheet.

There are times, using Yahoo, that I have to run SMFForceCalculation several times to update all the data.

Ron Spruell

--- In smf_addin@yahoogroups.com, "codyklein" <codyklein@...> wrote:
>
> I've been having the same problem. It started about a month ago +- and only effects yahoo (so far). It seems to be random and you must run the force recalc function until it all comes in. Sometimes its a yahoo problem but most of the time when I check the yahoo webpage all the data is there. It usually happens with yahoo's Income statement, balance sheet and cash flow statements when pulling in both yearly and quarterly data. I've noticed it doesn't happen as much if you go to the problem worksheet then force reclac although this could be wishful thinking on my part because it doesn't always work. It is strange but eventually it all come in.
>
> Maybe it has something to do with the 1000 limit but I'm pretty sure I don't come close. I pull data for some 20-40 tickers from several sources but I don't know if there is a way to check the number of webpages it pulls from for the entire workbook.
>
> So far its not a problem since I can get all the data with a few force reclacs.
>
> --- In smf_addin@yahoogroups.com, "thomas91112" <thomas91112@> wrote:
> >
> > I currently have multiple Excel workbooks (one workbook for each stock plus some analytics) using RCHGetYahooHistory and RCHGetYahooQuotes to retrieve High, Low and Close values. Would like to combine these numerous workbooks into a single workbook but with separate worksheets, one for each of the current workbooks - that way each worksheet will contain the price history and analytics for each stock.
> >
> > As individual workbooks the data updated just fine, but when I combined these workbooks as described above, have begun encountering problems with the data when updating. Sometimes data items would not fully update leaving off the last two months of data but it seemed random, you never know when a worksheet will update fully...have to keep hitting ForceReCalc until the full update occurs.
> >
> > Is there a problem using SMF throughout multiple worksheets?
> >
> > Thanks
> > Mike
> >
>

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

Re: Using SMF Add-in over multiple worksheets

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

Sat Apr 21, 2012 5:59 am (PDT)



For most add-in functions, <Shift-F9> is not going to update the data. It
should work for RCHGetYahooQuotes() and RCHGetYahooHistory(), but it won't
work for RCHGetElementNumber(), RCHGetTableCell(), RCHGetHTMLTable(),
smfGetOptionQuotes(), etc.

On Sat, Apr 21, 2012 at 4:12 AM, hashky <hashky@yahoo.com> wrote:

>
> If I use multiple worksheets, I can go to the Tab and hit <Shift-F9> and
> recalculate just that sheet.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3a.

RCHGetTableCell() function

Posted by: "Jason" xxjaysonxx@aol.com   g3m1n1980

Sat Apr 21, 2012 9:40 am (PDT)



Can someone troubleshoot my quick table for grabbing the all stat scordcard at nasdaq

http://www.nasdaq.com/symbol/goog/guru-analysis/lynch

I have 4 columns and 8 rows

Formula
=RCHGetTableCell("http://www.nasdaq.com/symbol/ko/guru-analysis/lynch="&TICKER,1,"Source",,,,1,"</table",,"--")

I also uploaded for help.

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

Re: RCHGetTableCell() function

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

Sat Apr 21, 2012 9:58 am (PDT)



Two issues -- bad URL and bad choice of a search string. Instead, try:

=RCHGetTableCell("http://www.nasdaq.com/symbol/
"&TICKER&"/guru-analysis/lynch",1,">Source",,,,1,"</table",,"--")

On Sat, Apr 21, 2012 at 9:39 AM, Jason <xxjaysonxx@aol.com> wrote:

> Can someone troubleshoot my quick table for grabbing the all stat
> scordcard at nasdaq
>
> http://www.nasdaq.com/symbol/goog/guru-analysis/lynch
>
> I have 4 columns and 8 rows
>
> Formula
> =RCHGetTableCell("http://www.nasdaq.com/symbol/ko/guru-analysis/lynch=
> "&TICKER,1,"Source",,,,1,"</table",,"--")
>
> I also uploaded for help.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
3c.

Re: RCHGetTableCell() function

Posted by: "J@Y" xxjaysonxx@aol.com   g3m1n1980

Sat Apr 21, 2012 10:15 am (PDT)




Randy,

Thanks for the quick response. I tried the new string and URL and Im still returning -- in all my cells.

=RCHGetTableCell("http://www.nasdaq.com/symbol/"&TICKER&"/guru-analysis/lynch",1,">Source",,,,1,"</table",,"--")

I have the Prow and Pcell change depending on cell location.

Any more helpful ideas?

=RCHGetTableCell("http://www.nasdaq.com/symbol/"&TICKER&"/guru-analysis/lynch",1,">Source",,,,1,"</table",,"--")

-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Sat, Apr 21, 2012 12:58 pm
Subject: Re: [smf_addin] RCHGetTableCell() function

Two issues -- bad URL and bad choice of a search string. Instead, try:

=RCHGetTableCell("http://www.nasdaq.com/symbol/"&TICKER&"/guru-analysis/lynch",1,">Source",,,,1,"</table",,"--")

On Sat, Apr 21, 2012 at 9:39 AM, Jason <xxjaysonxx@aol.com> wrote:

Can someone troubleshoot my quick table for grabbing the all stat scordcard at nasdaq

http://www.nasdaq.com/symbol/goog/guru-analysis/lynch

I have 4 columns and 8 rows

Formula
=RCHGetTableCell("http://www.nasdaq.com/symbol/ko/guru-analysis/lynch="&TICKER,1,"Source",,,,1,"</table",,"--")

I also uploaded for help.

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

Re: RCHGetTableCell() function

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

Sat Apr 21, 2012 10:20 am (PDT)



Not sure what to tell you, here's what I'm getting back:

1 4 GOOG 1 Peter Lynch 72% 2 Benjamin Graham 57% 3 Validea
71% 4 Motley
Fool 59% 5 David Dreman 57% 6 Martin Zweig 77% 7 Kenneth Fisher 40% 8 James
P. O'Shaughnessy 60% 9 -- -- 10 -- --
For the formula, I just have this copied over the 20 cells:

=RCHGetTableCell("http://www.nasdaq.com/symbol/
"&Ticker&"/guru-analysis/lynch",D$3,">Source",,,,$C5,"</table",,"--")

On Sat, Apr 21, 2012 at 10:15 AM, J@Y <xxjaysonxx@aol.com> wrote:

>
> Thanks for the quick response. I tried the new string and URL and Im
> still returning -- in all my cells.
>
> =RCHGetTableCell("
> http://www.nasdaq.com/symbol/"&TICKER&"/guru-analysis/lynch",1,">Source",,,,1,"</table
> ",,"--")
>
> I have the Prow and Pcell change depending on cell location.
>
> Any more helpful ideas?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
4a.

Re: Use of SMF Formulas in Excel 2010 Tables

Posted by: "digsupply" picsound@gmail.com   digsupply

Sat Apr 21, 2012 10:12 am (PDT)



LOOK THIS
http://f1.grp.yahoofs.com/v1/kOeST6Wfzm8K9CeVViTfpdThpBm6fLNRsZiZ4uRUhWApjeIjiRjPdihMlmyZPo-nS3HwL5N3t5hSRDHTjyCgxacszSiBbUBR/Uploads%20by%20forum%20members/Money%20making%20worksheets/Barchart%20What%20Not%20and%20What%20Hot%20.xlsm

--- In smf_addin@yahoogroups.com, Ron Spruell <hashky@...> wrote:
>
> This was my experience also.  I didn't name the table.  I just put the Ticker Symbols in C5:C107. I highlighted C5:F107 and then from the Ribbon (which I hate), Insert->Table. Excel Added a header row C5:F5 and named the headers Column1,Column2, etc.  The new table was C5:F108. I didn't name the table.
>
>
> In D6, I wrote the equation 
> =RCHGetElementNumber(
> Then moused to Col C which has the ticker value (MMM).  Then I typed in 13862, the code for the company name.  Excel populated Column D.  It was NOT fast. 
>
>
> The equation in Cell D9, for example, was
> =RCHGetElementNumber(C9,13862)
>
> Similar for the rest of the Column, D10 had C10, D11 had C11, etc.
>
> I don't know where the @Ticker came from in Pete's spreadsheet.
>
>
> Ron
>
>
>
>
> >________________________________
> > From: Ron <rlcarr71@...>
> >To: smf_addin@yahoogroups.com
> >Sent: Thursday, April 19, 2012 12:50 PM
> >Subject: [smf_addin] Re: Use of SMF Formulas in Excel 2010 Tables
> >
> >
> > 
> >When I created my table (excel called it Table1, rather than TICKER).
> >I'm assuming maybe before you where using the named range TICKER for the smfUpdateDownloadTable macro.
> >I also experienced the nice results where it automatically applies the formula down every row in the column.
> >However, mine was not lightning fast, possibly you had run some Gets earlier and those symbols where still in your cache.
> >
> >Nice find.
> >Ron
> >
> >
> >
> >
> >
>

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

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

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
Diposting oleh EXCEL FEED LEARNING di 01.19

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)