2 Messages

Digest #3874

smfForceRecalculation with smfUpdateDownloadTable by justy_sports

Re: smfForceRecalculation with smfUpdateDownloadTable by justy_sports

Messages

1a

smfForceRecalculation with smfUpdateDownloadTable

Thu Dec 29, 2016 9:04 am (PST) . Posted by:

justy_sports

I am using smfGetTagContent to retrieve data from the following URL - http://www.advfn.com/stock-market/NYSE/A/financials http://www.advfn.com/stock-market/NYSE/A/financials

I am doing so via the smfUpdateDownloadTable macro.

The table populates correctly when I first run the macro. The problem is, I then try to run smfForceRecalculation followed by smfUpdateDownloadTable and the data does not update (it still displays the old values; ex. Price).

If I close out of the workbook, re-open, and run smfUpdateDownloadTable the data updates correctly (ex. Price). This leads me to believe the smfForceRecalculation macro is not working correctly.

Any ideas?

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: smfForceRecalculation with smfUpdateDownloadTable

Thu Dec 29, 2016 12:29 pm (PST) . Posted by:

justy_sports

I tested similar functionality with another source (MSN) and it worked just fine.

Any thoughts on why smfForceReconciliation may not be working for items retrieved from AdvFN?

Thanks!