Kamis, 14 Juli 2016

[smf_addin] Digest Number 3743

6 Messages

Digest #3743

Messages

Wed Jul 13, 2016 7:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

What do you get with:

=RCHGetElementNumber("Version")

=smfGetAdvFNElement("MMM","A",999)
=smfGetAdvFNElement("NYSE:MMM","A",999)

=smfGetAdvFNElement("MMM","A",1,">year end date<")
=smfGetAdvFNElement("NYSE:MMM","A",1,">year end date<")

=RCHGetElementNumber("MMM",5204)
=RCHGetElementNumber("NYSE:MMM",5204)

=RCHGetWebData("http://www.advfn.com/exchanges/NYSE/MMM/financials",
"/exchanges/", 50)
=RCHGetWebData("http://uk.advfn.com/exchanges/NYSE/MMM/financials",
"/exchanges/", 50)

On Wed, Jul 13, 2016 at 6:55 PM, pmanz@
​...wrote:

>
> For the record: can't get AdvFN to work after creating the Txt file
> containing "UK" (no"" in file) - my add in is dated 2015-03-05 01:04 PM and
> thus should incorporate the necessary AdvFN URL changes (?) - also tried
> the IE changes.
>
> There is some data I would like to pull in from AdFN so if there is
> anything else I should do please advise.
>

Wed Jul 13, 2016 8:35 pm (PDT) . Posted by:

mokwit

Cutting and pasting I get the followwing in same order as yours above

Stock Market Functions add-in, Version 2.1.2011.04.03 (C:\Program Files\SMF Add-in; 1)
Error Error
Error Error
Error Error
/exchanges/NASDAQ'"><a href="/exchanges/NASDAQ" cl

/exchanges/LSE'"><a href="/exchanges/LSE" class="l





3M Company Financial Information http://www.advfn.com/exchanges/NYSE/MMM/financials

http://www.advfn.com/exchanges/NYSE/MMM/financials

3M Company Financial Information http://www.advfn.com/exchanges/NYSE/MMM/financials 3M Co. financial information, fundamentals and company reports including full balance sheet, profit and Loss, debtors, creditors, financial ratios, rates, margins, ...



View on www.advfn.com http://www.advfn.com/exchanges/NYSE/MMM/financials
Preview by Yahoo



/exchanges/LSE&#39;"><a href="/exchanges/LSE" class="l
Note: The 3M company financial information is a as it is in your example above - my Cell does not return '3M Company Financial information&#39; The cut and paste appears as a blue hyperlink but I note that the top one has'NASDAQ"; in the string and the bottom (uK) one has LSE class=
i.e both are different from what was pasted and are returning NASDAQ and LSE Class respectively

Wed Jul 13, 2016 8:43 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You have a very, very, very old version of the add-in. I've had to make
coding changes for AdvFN several times since 2011.

On Wed, Jul 13, 2016 at 8:34 PM, pmanz@
​...wrote:

>
> Cutting and pasting I get the followwing in same order as yours above
>
> Stock Market Functions add-in, Version 2.1.2011.04.03 (C:\Program
> Files\SMF Add-in; 1)
>
> Error
> Error
>
> Error
> Error
>
> Error
> Error
>
> /exchanges/NASDAQ'"><a href="/exchanges/NASDAQ" cl
>
> /exchanges/LSE'"><a href="/exchanges/LSE" class="l
>
>
>
>
>
> 3M Company Financial Information
> <http://www.advfn.com/exchanges/NYSE/MMM/financials>
> [image: image] <http://www.advfn.com/exchanges/NYSE/MMM/financials>
> 3M Company Financial Information
> <http://www.advfn.com/exchanges/NYSE/MMM/financials>
> 3M Co. financial information, fundamentals and company reports including
> full balance sheet, profit and Loss, debtors, creditors, financial ratios,
> rates, margins, ...
> View on www.advfn.com <http://www.advfn.com/exchanges/NYSE/MMM/financials>
> Preview by Yahoo
>
>
> /exchanges/LSE'"><a href="/exchanges/LSE" class="l
> <http://uk.advfn.com/exchanges/NYSE/MMM/financials>
> Note: The 3M company financial information is a as it is in your example
> above - my Cell does not return '3M Company Financial information&#39; The cut
> and paste appears as a blue hyperlink but I note that the top one
> has'NASDAQ"; in the string and the bottom (uK) one has LSE class=
> i.e both are different from what was pasted and are returning NASDAQ and
> LSE Class respectively
>
>

Wed Jul 13, 2016 8:47 pm (PDT) . Posted by:

mokwit

Maybe I have spotted the issue:
Stock Market Functions add-in, Version 2.1.2011.04.03 (C:\Program Files\SMF Add-in; 1)
suggest that the smf in the location the addin is actually using is 2011 version and I have updated in locations that are not actually the ones being used - will try update in folder above and revert.

Wed Jul 13, 2016 8:51 pm (PDT) . Posted by:

mokwit

Yep you are right - seems I have been updating in the directories other than the one Excel is looking for. From spreadsheet it looks like now retrieveing data - do i need to insert the UK containing text file or just leave as is.

Apologies for taking up your time with this through not checking dilliigently enough

Now get:
Stock Market Functions add-in, Version 2.1.2016.06.20 (C:\Program Files\SMF Add-in; Windows (32-bit) NT 5.01; 11.0; ; ; 1)
23 23
2015/12 2015/12
2007/12 2007/12
3M Company Financial Information http://www.advfn.com/exchanges/NYSE/MMM/financials

http://www.advfn.com/exchanges/NYSE/MMM/financials

3M Company Financial Information http://www.advfn.com/exchanges/NYSE/MMM/financials 3M Co. financial information, fundamentals and company reports including full balance sheet, profit and Loss, debtors, creditors, financial ratios, rates, margins, ...



View on www.advfn.com http://www.advfn.com/exchanges/NYSE/MMM/financials
Preview by Yahoo



/exchanges/LSE&#39;"><a href="/exchanges/LSE" class="l
But it actually appears in my spreadsheet as
Stock Market Functions add-in, Version 2.1.2016.06.20 (C:\Program Files\SMF Add-in; Windows (32-bit) NT 5.01; 11.0; ; ; 1)

23
23

2015/12
2015/12

2007/12
2007/12

/exchanges/NASDAQ&#39;"><a href="/exchanges/NASDAQ" cl
/exchanges/LSE&#39;"><a href="/exchanges/LSE" class="l

Wed Jul 13, 2016 8:17 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sounds like you have a location error. That can happen if you move the
location of the add-in, or open and close the workbook on another machine
where the add-in is located somewhere else. If you haven't done any of
those, I'm at a loss as to why the link is incorrect. It might even be
unrelated to the add-in.

I've found the "Update" process on that message box to be unreliable. It
just marks the links as unresolved and they won't update.

Choose "Don't Update" and then run the smfFixLinks macro.

If that doesn't work, I'll need to see a specific formula that isn't
working, including all of the parameter values.

On Wed, Jul 13, 2016 at 7:43 PM, dr_henning@
​...wrote:

> My Excel files that use RCHGetYahooHistory to get daily historical data
> stopped working for me
>
> this morning, same day Yahoo changed yahoo finance. When I open one of my
> excel files it prompts "This workbook contains links to other data sources
> ......... Then box to Update or Don't Update. Click on update and new
> days data not loaded.
>
> I've been using these excel files for years no problem. Thanks Yahoo!
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar