Jumat, 06 Maret 2015

[smf_addin] Digest Number 3346

9 Messages

Digest #3346

Messages

Thu Mar 5, 2015 8:58 am (PST) . Posted by:

freefaller6

Hi Randy, I look into the regional prefix issue through the various threads in the forum. I am in the US so I doubt that's the issue. Regardless, I did create a file smf-AdvFN-Prefix.txt with the letters "www" in it, saved it, and opened my spreadsheet. I am still getting the same errors and successes. Very strange...not sure what to do.

Thanks,
Brent

Thu Mar 5, 2015 9:14 am (PST) . Posted by:

"Randy Harmelink" rharmelink

My apologies. It appears AdvFN has changed their website again. I need to
make a change to the add-in code so that it can extract from their new web
page structure.

I'll upload a new beta version to the "Works in Progress" folder shortly.

On Thu, Mar 5, 2015 at 9:58 AM, freefaller6@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi Randy, I look into the regional prefix issue through the various
> threads in the forum. I am in the US so I doubt that's the issue.
> Regardless, I did create a file smf-AdvFN-Prefix.txt with the letters
> "www" in it, saved it, and opened my spreadsheet. I am still getting the
> same errors and successes. Very strange...not sure what to do.
>

Thu Mar 5, 2015 10:41 am (PST) . Posted by:

freefaller6

Much obliged good sir. Thanks for saving me a lump on my forehead from banging it against the wall!

Brent


Thu Mar 5, 2015 1:02 pm (PST) . Posted by:

freefaller6

BINGO!!!!!! The update worked Randy, thanks a ton!

Brent

Thu Mar 5, 2015 12:15 pm (PST) . Posted by:

rharmelink

Some updated files on the "Works in Progress" web page (http://ogres-crypt.com/SMF/Works-In-Progress/ http://ogres-crypt.com/SMF/Works-In-Progress/):

Filename Size Last Uploaded Description 0-Change-log.html http://ogres-crypt.com/public/0-Change-log.html 11269 2015-03-05 01:04 PM
Log of changes made to the add-in or other files. RCH_Stock_Market_Functions-2.1.2015.03.15.zip http://ogres-crypt.com/public/RCH_Stock_Market_Functions-2.1.2015.03.15.zip 906486 2015-03-05 01:04 PM
Beta copy of the add-in. This contains all the add-in files that I am currently using in my day-to-day processing.

The add-in was changed to reflect web page changes on AdvFN. If you use RCHGetElementNumber() for AdvFN data items, or use smfGetAdvFNElement() to get AdvFN data, you'll need this update in order for them to continue working.


They changed their web page addresses from something like:


http://www.advfn.com/exchanges/NYSE/MMM/financials http://www.advfn.com/stock-market/NYSE/MMM/financials


...to something like:


http://www.advfn.com/stock-market/NYSE/MMM/financials http://www.advfn.com/stock-market/NYSE/MMM/financials


Thu Mar 5, 2015 4:07 pm (PST) . Posted by:

jsawyermib

Hi Randy

Has there been a change in the past month to restrict access to the advfn data as the worksheet I am using to retrieve historic accounts data for companies is now only returning errors. The url used is

="http://www.advfn.com/exchanges/"&smfstrExtr(RCHGetWebData("http://www.advfn.com/p.php?pid=financials&symbol="&Ticker,"canonical&quot;,150),"/exchanges/","/financials")&"/financials?btn="&IF(rAQ="A","annual","quarterly")&"_reports"


John


Thu Mar 5, 2015 6:26 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Posted earlier today:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/28118

On Thu, Mar 5, 2015 at 5:07 PM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Has there been a change in the past month to restrict access to the advfn
> data as the worksheet I am using to retrieve historic accounts data for
> companies is now only returning errors. The url used is
>
> ="http://www.advfn.com/exchanges/"&smfstrExtr(RCHGetWebData("
> http://www.advfn.com/p.php?pid=financials&symbol=
> "&Ticker,"canonical&quot;,150),"/exchanges/","/financials")&"/financials?btn="&IF(rAQ="A","annual","quarterly")&"_reports"
>

Fri Mar 6, 2015 1:23 am (PST) . Posted by:

jsawyermib

Thanks Randy. I downloaded the latest addin, but I think the problem seems to be changes to the advfn url for annual company accounts data and unfortunately replacing the "exchanges" with "stock-markets" as suggested by your link did not fix the problem. Would you or others on this forum perhaps have any suggestions on how I could amend my url code to again be able to retrieve the historical accounts data?

="http://www.advfn.com/exchanges/"&smfstrExtr(RCHGetWebData("http://www.advfn.com/p.php?pid=financials&symbol="&Ticker,"canonical&quot;,150),"/exchanges/","/financials")&"/financials?btn="&IF(rAQ="A","annual","quarterly")&"_reports"

best

John

Thu Mar 5, 2015 7:23 pm (PST) . Posted by:

almondtree

Randy do you plan to remove xls that use MSN obsolete numbers?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar