Loading ...
Sorry, an error occurred while loading the content.

13523Re: [smf_addin] GetWebData can't update data timely [1 Attachment]

Expand Messages
  • Randy Harmelink
    Feb 17, 2011
      Another possible reason data is not refreshing is that you have your Internet Options set up to cache web pages. Since EXCEL and the add-in use the same Internet access engine as IE, it also utilizes IE's cookies and "Temporary Internet Files" folder.

      To check/change your page caching settings for the "Temporary Internet Files" folder:
      1. Click on your system's "Start" button.
      2. Click on the "Control Panel" option.
      3. Double-click on "Internet Options".
      4. In the "Browser settings" section, click on the "Settings" button.
      5. Under where it says "Check for newer versions of stored pages:", you want to toggle the "Every time I visit the web page" radio button. Without this, the add-in would just retrieve IE's stored copy of the web page instead of the Internet access engine getting a fresh copy of the web page from the Internet.
      6. Click "OK" to save the settings and exit
      7. Click "OK" to exit
      8. Close the "Control Panel" window.
      Did you need to change your setting there?

      On Thu, Feb 17, 2011 at 3:09 PM, dehua liu <ldhljljq@...> wrote:

      I used the Macro and still can't the data updated. Please see the attached file. For example, I requested to retrieve data for IWM at around 11am, so the data after 11am can't be obtained even after Macro. On the other hand, USO was just requested a moment ago, which returned a full day's data.
      Could you please give it a quick check?

      --- On Thu, 2/17/11, Randy Harmelink <rharmelink@...> wrote:

      From: Randy Harmelink <rharmelink@...>
      Subject: Re: [smf_addin] GetWebData can't update data timely
      To: smf_addin@yahoogroups.com
      Date: Thursday, February 17, 2011, 3:48 PM

      You need to run the smfForceRecalculation macro. See the "Links" area of the group for more info.

      On Thu, Feb 17, 2011 at 1:18 PM, ldhljljq <ldhljljq@...> wrote:

      As you advised, I was able to use GetWebData to retrieve intraday data from barcharts.com. However, it seems it can't get the most recent value and the price simply stays where it was last time requested. It seems GetTableCell has similiar situation. Is there something I could do wrong? Does it have a command like now() as the one used in GetYahooquotes?

      Attachment(s) from dehua liu

      1 of 1 File(s)

    • Show all 12 messages in this topic