Messages In This Digest (19 Messages)
- 1a.
- EXCEL 2010 Semi-Crash From: Ron
- 1b.
- Re: EXCEL 2010 Semi-Crash From: Randy Harmelink
- 2a.
- Re: How could I use RCHGetYahooQuotes to get quotes from Yahoo HK pa From: email_to_jeffrey
- 2b.
- Re: How could I use RCHGetYahooQuotes to get quotes from Yahoo HK pa From: Randy Harmelink
- 3a.
- hi From: Stephen Schneider
- 4a.
- Re: Using new file but still get errors From: ufdn16
- 4b.
- Re: Using new file but still get errors From: Randy Harmelink
- 4c.
- Re: Using new file but still get errors From: ufdn16
- 4d.
- Re: Using new file but still get errors From: ufdn16
- 4e.
- Re: Using new file but still get errors From: Randy Harmelink
- 5.
- add_in manager From: ufdn16
- 6.1.
- Re: RCHGetTableCell From: jothiramselvam
- 6.2.
- Re: RCHGetTableCell From: Randy Harmelink
- 6.3.
- Re: RCHGetTableCell From: jothiramselvam
- 6.4.
- Re: RCHGetTableCell From: Randy Harmelink
- 6.5.
- Re: RCHGetTableCell From: jothiramselvam
- 6.6.
- Re: RCHGetTableCell From: Randy Harmelink
- 6.7.
- Re: RCHGetTableCell From: jothiramselvam
- 6.8.
- Re: RCHGetTableCell From: Randy Harmelink
Messages
- 1a.
-        EXCEL 2010 Semi-CrashPosted by: "Ron" ronaldj309@cox.net ronaldj309Tue Jun 12, 2012 2:35 am (PDT)
 For two weeks or so I have been having a problem with EXCEL 2010 running on Windows 7, 64 bit, Service Pack 1, in conjunction with the smf-AddIn.
 What happens is that the copy and paste function stops operating properly. Specifically when a cell(s) are selected and ctrl-c is typed, the normal dashed, blinking outline is not present and pasting to another cell(s) will only paste either text or unicode text. After this happens, the only way I have found to recover is to reinstall EXCEL using the repair option. (Really getting tired of doing this, as you can imagine. I use the smf-AddIn a lot.) This may be an EXCEL problem, but I don't know how to isolate it and haven't found any clues using Google.
 
 This started after a time when as I opened a file in EXCEL I got an error message saying that the file was corrupted and EXCEL was repairing it.
 
 Any help would be appreciated. I can post an EXCEL file, but that might not be a friendly thing to do.
 
 Ron Johnson
 
 
- 1b.
-        Re: EXCEL 2010 Semi-CrashPosted by: "Randy Harmelink" rharmelink@gmail.com rharmelinkTue Jun 12, 2012 4:01 am (PDT)
 It's nothing I've heard of. I think you'll need to ask over in some of the
 Yahoo groups for EXCEL help.
 
 On Tue, Jun 12, 2012 at 2:28 AM, Ron <ronaldj309@cox.net > wrote:
 
 > For two weeks or so I have been having a problem with EXCEL 2010 running
 > on Windows 7, 64 bit, Service Pack 1, in conjunction with the smf-AddIn.
 > What happens is that the copy and paste function stops operating properly.
 > Specifically when a cell(s) are selected and ctrl-c is typed, the normal
 > dashed, blinking outline is not present and pasting to another cell(s) will
 > only paste either text or unicode text. After this happens, the only way I
 > have found to recover is to reinstall EXCEL using the repair option.
 > (Really getting tired of doing this, as you can imagine. I use the
 > smf-AddIn a lot.) This may be an EXCEL problem, but I don't know how to
 > isolate it and haven't found any clues using Google.
 >
 > This started after a time when as I opened a file in EXCEL I got an error
 > message saying that the file was corrupted and EXCEL was repairing it.
 >
 > Any help would be appreciated. I can post an EXCEL file, but that might
 > not be a friendly thing to do.
 >
 
- 2a.
-        Re: How could I use RCHGetYahooQuotes to get quotes from Yahoo HK paPosted by: "email_to_jeffrey" email_to_jeffrey@yahoo.com.hk email_to_jeffreyTue Jun 12, 2012 2:58 am (PDT)
 Thanks for your tips.
 
 I can now extract the real time last trade price from the Yahoo HK website with this function:
 
 =smfGetTagContent(http://hk.finance.yahoo.com/ "span",-11,"q?s=5&ql= 1, yui-u first yfi-start-content" ) 
 
 How could I build a refresh/update element into this? Say the spreadsheet refresh every 3mins so that I can have a sort of streaming spreadsheet to monitor my holdings.
 
 Thanks
 
 --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote: 
 >
 > The RCHGetYahooQuotes() function uses their CSV file interface. Not from 
 > the web pages.
 >
 > But, yes, you can use other add-in functions to get the data from the web
 > pages. You need to examine the source code of the web page to determine how
 > to extract data. I suspect the Last Trade Price is not within a table,
 > since it isn't on the U.S. site. Take a look at the source code and see
 > what tags the last traded price is between, and then use the
 > smfGetTagContent() function to extract it. 
 >
 > On Tue, Jun 12, 2012 at 12:46 AM, email_to_jeffrey <
 > email_to_jeffrey@...> wrote: 
 >
 > > But you can get real time quote for HK stocks from their website:
 > > http://hk.finance.yahoo.com/ q?s=5&ql= 1 
 > >
 > > Could I use other functions to get the realtime quote?
 > >
 > > I tried the RCHGetTableCell() but it doesnt seem to recognize the cell 
 > > with the Last Trade Price.
 > >
 > > Thank you again.
 > >
 >
 
 
- 2b.
-        Re: How could I use RCHGetYahooQuotes to get quotes from Yahoo HK paPosted by: "Randy Harmelink" rharmelink@gmail.com rharmelinkTue Jun 12, 2012 4:02 am (PDT)
 You would need to write your own VBA routine to run the
 smfForceRecalculation macro every 3 minutes. Do a Google search on "VBA 
 onTime" and you should find a number of examples.
 
 On Tue, Jun 12, 2012 at 2:58 AM, email_to_jeffrey <
 email_to_jeffrey@yahoo.com. > wrote:hk 
 
 >
 > I can now extract the real time last trade price from the Yahoo HK website
 > with this function:
 >
 > =smfGetTagContent(http://hk.finance.yahoo.com/ "span",-11,"q?s=5&ql= 1, yui-u 
 > first yfi-start-content") 
 >
 > How could I build a refresh/update element into this? Say the spreadsheet
 > refresh every 3mins so that I can have a sort of streaming spreadsheet to
 > monitor my holdings.
 >
 
- 3a.
-        hiPosted by: "Stephen Schneider" stephens241@yahoo.com stephens241Tue Jun 12, 2012 3:22 am (PDT)
 
 you should definitely check this out /biz/?read=9189633
 
 
- 4a.
-        Re: Using new file but still get errorsPosted by: "ufdn16" ufdn16@yahoo.com ufdn16Tue Jun 12, 2012 4:46 am (PDT)
 step1. I don't know how to go to the add_in manager, help
 step4. Is this new copy the same as in step 6., help
 
 We're getting real close. Thanks, David
 
 --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote: 
 >
 > If the add-in was still working, it implies to me you still had an instance
 > of the add-in on your machine.
 >
 > The process to fix things should have been:
 >
 > 1. Go to add-in manager and uncheck the add-in, so it's no longer
 > pointed to by EXCEL
 > 2. Exit EXCEL
 > 3. Remove all instances of the add-in you have unzipped
 > 4. Download a new copy of the add-in
 > 5. Unzip the contents of the ZIP file into the folder you plan to use
 > 6. Download a new copy of the smf-elements-1 file to use and put it into 
 > that folder, replacing the one from the ZIP file
 > 7. Restart EXCEL
 > 8. Go to the add-in manager and point it to the correct folder
 >
 > In any case, with a NEW workbook, what do you get with:
 >
 > =RCHGetElementNumber("Version" ) 
 > =RCHGetElementNumber("MMM",25) 
 > =smfGetAParms(25) 
 >
 > On Mon, Jun 11, 2012 at 4:07 PM, ufdn16 <ufdn16@...> wrote:
 >
 > >
 > > Here's where I'm at now. As you suggested, I had more than one incident of
 > > smf and in different locations. So, I decided I would delete all files
 > > associated with this function and start over.
 > >
 > > I deleted all files. The funny thing is, that after I deleted the files
 > > and rebooted my machine and then loaded the worksheet with function
 > > formulas in it, I thought I would have errors all over the worksheet. But,
 > > in fact, everything was still in tact. That's just crazy.
 > >
 > > I then downloaded the correct file , unzipped it and let default to the
 > > directory suggested by the unzip function.
 > >
 > > I opened my worksheet and I still had all the original formulas still
 > > working but still can't get function 25.
 > >
 > > What do you think. David
 > >
 >
 
 
- 4b.
-        Re: Using new file but still get errorsPosted by: "Randy Harmelink" rharmelink@gmail.com rharmelinkTue Jun 12, 2012 8:33 am (PDT)
 The ZIP file from Step4 will contain an outdated version of
 smf-elements-1.txt, which is why you need to download the updated one after 
 unzipping the ZIP file.
 
 On Tue, Jun 12, 2012 at 4:46 AM, ufdn16 <ufdn16@yahoo.com > wrote:
 
 > step1. I don't know how to go to the add_in manager, help
 > step4. Is this new copy the same as in step 6., help
 >
 > We're getting real close. Thanks, David
 >
 > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote: 
 > >
 > > If the add-in was still working, it implies to me you still had an
 > instance
 > > of the add-in on your machine.
 > >
 > > The process to fix things should have been:
 > >
 > > 1. Go to add-in manager and uncheck the add-in, so it's no longer
 > > pointed to by EXCEL
 > > 2. Exit EXCEL
 > > 3. Remove all instances of the add-in you have unzipped
 > > 4. Download a new copy of the add-in
 > > 5. Unzip the contents of the ZIP file into the folder you plan to use
 > > 6. Download a new copy of the smf-elements-1 file to use and put it 
 > into
 > > that folder, replacing the one from the ZIP file
 > > 7. Restart EXCEL
 > > 8. Go to the add-in manager and point it to the correct folder
 > >
 > > In any case, with a NEW workbook, what do you get with:
 > >
 > > =RCHGetElementNumber("Version" ) 
 > > =RCHGetElementNumber("MMM",25) 
 > > =smfGetAParms(25) 
 >
 
- 4c.
-        Re: Using new file but still get errorsPosted by: "ufdn16" ufdn16@yahoo.com ufdn16Tue Jun 12, 2012 8:55 am (PDT)
 Thanks, I'm going to give it a try. Thanks for being patient. David
 
 --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote: 
 >
 > The ZIP file from Step4 will contain an outdated version of
 > smf-elements-1.txt, which is why you need to download the updated one after 
 > unzipping the ZIP file.
 >
 > On Tue, Jun 12, 2012 at 4:46 AM, ufdn16 <ufdn16@...> wrote:
 >
 > > step1. I don't know how to go to the add_in manager, help
 > > step4. Is this new copy the same as in step 6., help
 > >
 > > We're getting real close. Thanks, David
 > >
 > > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote: 
 > > >
 > > > If the add-in was still working, it implies to me you still had an
 > > instance
 > > > of the add-in on your machine.
 > > >
 > > > The process to fix things should have been:
 > > >
 > > > 1. Go to add-in manager and uncheck the add-in, so it's no longer
 > > > pointed to by EXCEL
 > > > 2. Exit EXCEL
 > > > 3. Remove all instances of the add-in you have unzipped
 > > > 4. Download a new copy of the add-in
 > > > 5. Unzip the contents of the ZIP file into the folder you plan to use
 > > > 6. Download a new copy of the smf-elements-1 file to use and put it 
 > > into
 > > > that folder, replacing the one from the ZIP file
 > > > 7. Restart EXCEL
 > > > 8. Go to the add-in manager and point it to the correct folder
 > > >
 > > > In any case, with a NEW workbook, what do you get with:
 > > >
 > > > =RCHGetElementNumber("Version" ) 
 > > > =RCHGetElementNumber("MMM",25) 
 > > > =smfGetAParms(25) 
 > >
 >
 
 
- 4d.
-        Re: Using new file but still get errorsPosted by: "ufdn16" ufdn16@yahoo.com ufdn16Tue Jun 12, 2012 9:25 am (PDT)
 Still no luck Randy,
 I have followed the procedure you have laid out for me. Maybe the answers to the following questions might reveal something.
 
 I have two questions:
 
 1. The element function text file's date is 2/12/12. Is this correct?
 2. The path to my smf_addin folder is: c:\users\owner\documents 
 Is this path ok? Or, not.
 
 --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote: 
 >
 > The ZIP file from Step4 will contain an outdated version of
 > smf-elements-1.txt, which is why you need to download the updated one after 
 > unzipping the ZIP file.
 >
 > On Tue, Jun 12, 2012 at 4:46 AM, ufdn16 <ufdn16@...> wrote:
 >
 > > step1. I don't know how to go to the add_in manager, help
 > > step4. Is this new copy the same as in step 6., help
 > >
 > > We're getting real close. Thanks, David
 > >
 > > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote: 
 > > >
 > > > If the add-in was still working, it implies to me you still had an
 > > instance
 > > > of the add-in on your machine.
 > > >
 > > > The process to fix things should have been:
 > > >
 > > > 1. Go to add-in manager and uncheck the add-in, so it's no longer
 > > > pointed to by EXCEL
 > > > 2. Exit EXCEL
 > > > 3. Remove all instances of the add-in you have unzipped
 > > > 4. Download a new copy of the add-in
 > > > 5. Unzip the contents of the ZIP file into the folder you plan to use
 > > > 6. Download a new copy of the smf-elements-1 file to use and put it 
 > > into
 > > > that folder, replacing the one from the ZIP file
 > > > 7. Restart EXCEL
 > > > 8. Go to the add-in manager and point it to the correct folder
 > > >
 > > > In any case, with a NEW workbook, what do you get with:
 > > >
 > > > =RCHGetElementNumber("Version" ) 
 > > > =RCHGetElementNumber("MMM",25) 
 > > > =smfGetAParms(25) 
 > >
 >
 
 
- 4e.
-        Re: Using new file but still get errorsPosted by: "Randy Harmelink" rharmelink@gmail.com rharmelinkTue Jun 12, 2012 9:39 am (PDT)
 The smf-elements-1.txt file should be from 2012-05-10. 
 
 You can locate the add-in almost anywhere, but using such an unusual path
 will mean you are going to have to manually fix location errors if you get
 a file from someone else (e.g. a template).
 
 On Tue, Jun 12, 2012 at 9:25 AM, ufdn16 <ufdn16@yahoo.com > wrote:
 
 > Still no luck Randy,
 > I have followed the procedure you have laid out for me. Maybe the answers
 > to the following questions might reveal something.
 >
 > I have two questions:
 >
 > 1. The element function text file's date is 2/12/12. Is this correct?
 > 2. The path to my smf_addin folder is: c:\users\owner\documents 
 > Is this path ok? Or, not.
 >
 
- 5.
-        add_in managerPosted by: "ufdn16" ufdn16@yahoo.com ufdn16Tue Jun 12, 2012 4:56 am (PDT)
 I just remembered how to get to the add_in manager. So, I'm ok with that part of the instruction. Please respond to my other reply and I'll be good to go. Thanks, David
 
 
- 6.1.
-        Re: RCHGetTableCellPosted by: "jothiramselvam" jothiram.s@gmail.com jothiramselvamTue Jun 12, 2012 6:49 am (PDT)
 Great. Thanks Randy Harmelink. This works.
 
 One more question:
 
 From this link
 
 http://www.moneycontrol.com/ financials/ patnicomputersys tems/ratios/ PCS02#PCS02 
 
 I'm trying to collect the "Book Value" for the years, 2008,2009, 2010, 2011 and 2012
 
 So in my excel sheet, I do
 
 =RCHGetTableCell("http://www.moneycon trol.com/ ",5,">Book Value")financials/ patnicomputersys tems/ratios/ PCS02#PCS02 
 
 =RCHGetTableCell("http://www.moneycon trol.com/ ",4,">Book Value")financials/ patnicomputersys tems/ratios/ PCS02#PCS02 
 
 etc. For every year. So in total, I do 5 requests for 5 years.
 
 Similarly, I want to also collect "Earnings Per Share" and "Adjusted Return on Net Worth" from the same link.
 
 =RCHGetTableCell("http://www.moneycon trol.com/ ",5,">Earnings Per Share")financials/ patnicomputersys tems/ratios/ PCS02#PCS0 
 
 =RCHGetTableCell("http://www.moneycon trol.com/ "&MC&"/ratios/financials/ "&MS,5,"> Adjusted Return on Net Worth") 
 
 And currently I do that also 5 requests each. So totally, I do 15 requests to the same link.
 
 Is it possible to combine all of them and collect this data into the excel cells by a single request.
 
 Thanks
 Joe.
 
 --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote: 
 >
 > That's because the data is not display within a table. Instead, try:
 >
 > =smfConvertData(smfGetTagContent (" 
 > http://www.moneycontrol.com/ india/stockprice quote/computerss oftware/patnicom putersystems/ PCS02 
 > ","div",1,">P/E")) 
 >
 > On Mon, Jun 11, 2012 at 5:34 AM, jothiramselvam <jothiram.s@...>wrote: 
 >
 > >
 > > From the link
 > >
 > >
 > > http://www.moneycontrol.com/ india/stockprice quote/computerss oftware/patnicom putersystems/ PCS02 
 > >
 > > I'm trying to get P/E value
 > >
 > > =RCHGetTableCell(" 
 > > http://www.moneycontrol.com/ india/stockprice quote/computerss oftware/patnicom putersystems/ PCS02 
 > > ",1,">P/E")
 > >
 > > However, this is not working. Can you please let me know what I'm missing
 > > here.
 > >
 >
 
 
- 6.2.
-        Re: RCHGetTableCellPosted by: "Randy Harmelink" rharmelink@gmail.com rharmelinkTue Jun 12, 2012 8:38 am (PDT)
 On Tue, Jun 12, 2012 at 6:49 AM, jothiramselvam <jothiram.s@gmail.com >wrote:
 
 >
 > One more question:
 >
 > From this link
 >
 >
 > http://www.moneycontrol.com/ financials/ patnicomputersys tems/ratios/ PCS02#PCS02 
 >
 > I'm trying to collect the "Book Value" for the years, 2008,2009, 2010,
 > 2011 and 2012
 >
 > So in my excel sheet, I do
 >
 > =RCHGetTableCell(" 
 > http://www.moneycontrol.com/ ",5,">Bookfinancials/ patnicomputersys tems/ratios/ PCS02#PCS02 
 > Value")
 >
 > =RCHGetTableCell(" 
 > http://www.moneycontrol.com/ ",4,">Bookfinancials/ patnicomputersys tems/ratios/ PCS02#PCS02 
 > Value")
 >
 > etc. For every year. So in total, I do 5 requests for 5 years.
 >
 
 Correct. But you can drop everything in the URL after and including the
 "#". That is a browser locational directive. In some cases, it can cause
 XMLHTTP problems (the method that retrieves the web pages for the add-in).
 
 > Similarly, I want to also collect "Earnings Per Share" and "Adjusted
 > Return on Net Worth" from the same link.
 >
 > =RCHGetTableCell(" 
 > http://www.moneycontrol.com/ ",5,">Earningsfinancials/ patnicomputersys tems/ratios/ PCS02#PCS0 
 > Per Share")
 >
 > =RCHGetTableCell("http://www.moneycon trol.com/ "&MC&"/ratios/financials/ "&MS,5,"> Adjusted 
 > Return on Net Worth")
 >
 > And currently I do that also 5 requests each. So totally, I do 15 requests
 > to the same link.
 >
 > Is it possible to combine all of them and collect this data into the excel
 > cells by a single request.
 >
 
 No. You need 15 individual formulas.
 
- 6.3.
-        Re: RCHGetTableCellPosted by: "jothiramselvam" jothiram.s@gmail.com jothiramselvamTue Jun 12, 2012 8:56 am (PDT)
 Oh. Can't we get it using
 
 RCHGetHTMLTable or RCHGetWebData
 
 Thanks
 Joe.
 
 --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote: 
 >
 > On Tue, Jun 12, 2012 at 6:49 AM, jothiramselvam <jothiram.s@...>wrote: 
 >
 > >
 > > One more question:
 > >
 > > From this link
 > >
 > >
 > > http://www.moneycontrol.com/ financials/ patnicomputersys tems/ratios/ PCS02#PCS02 
 > >
 > > I'm trying to collect the "Book Value" for the years, 2008,2009, 2010,
 > > 2011 and 2012
 > >
 > > So in my excel sheet, I do
 > >
 > > =RCHGetTableCell(" 
 > > http://www.moneycontrol.com/ ",5,">Bookfinancials/ patnicomputersys tems/ratios/ PCS02#PCS02 
 > > Value")
 > >
 > > =RCHGetTableCell(" 
 > > http://www.moneycontrol.com/ ",4,">Bookfinancials/ patnicomputersys tems/ratios/ PCS02#PCS02 
 > > Value")
 > >
 > > etc. For every year. So in total, I do 5 requests for 5 years.
 > >
 >
 > Correct. But you can drop everything in the URL after and including the
 > "#". That is a browser locational directive. In some cases, it can cause
 > XMLHTTP problems (the method that retrieves the web pages for the add-in).
 >
 >
 > > Similarly, I want to also collect "Earnings Per Share" and "Adjusted
 > > Return on Net Worth" from the same link.
 > >
 > > =RCHGetTableCell(" 
 > > http://www.moneycontrol.com/ ",5,">Earningsfinancials/ patnicomputersys tems/ratios/ PCS02#PCS0 
 > > Per Share")
 > >
 > > =RCHGetTableCell("http://www.moneycon trol.com/ "&MC&"/ratios/financials/ "&MS,5,"> Adjusted 
 > > Return on Net Worth")
 > >
 > > And currently I do that also 5 requests each. So totally, I do 15 requests
 > > to the same link.
 > >
 > > Is it possible to combine all of them and collect this data into the excel
 > > cells by a single request.
 > >
 >
 > No. You need 15 individual formulas.
 >
 
 
- 6.4.
-        Re: RCHGetTableCellPosted by: "Randy Harmelink" rharmelink@gmail.com rharmelinkTue Jun 12, 2012 8:57 am (PDT)
 Not those specific 15 items.
 
 On Tue, Jun 12, 2012 at 8:56 AM, jothiramselvam <jothiram.s@gmail.com >wrote:
 
 > Oh. Can't we get it using
 >
 > RCHGetHTMLTable or RCHGetWebData
 >
 
- 6.5.
-        Re: RCHGetTableCellPosted by: "jothiramselvam" jothiram.s@gmail.com jothiramselvamTue Jun 12, 2012 9:17 am (PDT)
 Okay. Is it possible to atleast reduce them to 3 requests - as the entires for each of the three are continues - for eg. Book Value of all years are continuous.
 
 One request for Book Value - which can get all the values of the 5 years.
 
 Thanks
 Joe
 
 --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote: 
 >
 > Not those specific 15 items.
 >
 > On Tue, Jun 12, 2012 at 8:56 AM, jothiramselvam <jothiram.s@...>wrote: 
 >
 > > Oh. Can't we get it using
 > >
 > > RCHGetHTMLTable or RCHGetWebData
 > >
 >
 
 
- 6.6.
-        Re: RCHGetTableCellPosted by: "Randy Harmelink" rharmelink@gmail.com rharmelinkTue Jun 12, 2012 9:24 am (PDT)
 Nope. Why the obsession with a single request?
 
 On Tue, Jun 12, 2012 at 9:17 AM, jothiramselvam <jothiram.s@gmail.com >wrote:
 
 > Okay. Is it possible to atleast reduce them to 3 requests - as the entires
 > for each of the three are continues - for eg. Book Value of all years are
 > continuous.
 >
 > One request for Book Value - which can get all the values of the 5 years.
 >
 
- 6.7.
-        Re: RCHGetTableCellPosted by: "jothiramselvam" jothiram.s@gmail.com jothiramselvamTue Jun 12, 2012 9:58 am (PDT)
 :) Not an obsession. I collect many stocks in my excel sheet. And when I open, it takes around 5-10 mins, because of so many requests being sent. Hence, I thought that if I could minimize, then it will be faster.
 
 No worries. If it is not possible, then that's fine.
 
 Thanks for your patient replies to all my queries.
 
 --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote: 
 >
 > Nope. Why the obsession with a single request?
 >
 > On Tue, Jun 12, 2012 at 9:17 AM, jothiramselvam <jothiram.s@...>wrote: 
 >
 > > Okay. Is it possible to atleast reduce them to 3 requests - as the entires
 > > for each of the three are continues - for eg. Book Value of all years are
 > > continuous.
 > >
 > > One request for Book Value - which can get all the values of the 5 years.
 > >
 >
 
 
- 6.8.
-        Re: RCHGetTableCellPosted by: "Randy Harmelink" rharmelink@gmail.com rharmelinkTue Jun 12, 2012 10:03 am (PDT)
 The 15 different formulas will only use one web page retrieval.
 RCHGetTableCell() extracts data from a saved copy of a web page. So, if the 
 web page has already been retrieved, it doesn't need to retrieve it again.
 
 On Tue, Jun 12, 2012 at 9:58 AM, jothiramselvam <jothiram.s@gmail.com >wrote:
 
 > :) Not an obsession. I collect many stocks in my excel sheet. And when I
 > open, it takes around 5-10 mins, because of so many requests being sent.
 > Hence, I thought that if I could minimize, then it will be faster.
 >
 > No worries. If it is not possible, then that's fine.
 >
 > Thanks for your patient replies to all my queries.
 >
 
Need to Reply?
                Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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