Kamis, 20 November 2014

[smf_addin] Digest Number 3243

10 Messages

Digest #3243

Messages

Wed Nov 19, 2014 9:56 am (PST) . Posted by:

indinvestor111

Fantastic Work. Many Thanks!

Was hoping somebody could suggest a resource to help a non-engineer/programmer like me learn how and where to identify the various tags in these web pages.


Thanks!

Wed Nov 19, 2014 12:32 pm (PST) . Posted by:

ullikloeffel

Hello Randy!

Your work is great and I used it partially some years ago!

I used the RGH GetElement Number in conjunction by the RCH Stock Markets Function (2.1.2014 or before) since 2012 in order to see the prices of the ^gdaxi.

All was very good!

Now since 07.10.2014 I see by this function all prices, the close, the open the High and the Low. But the days before 07.10.2014 show only the Close.

I work with the DMI and need all this prices.

What is wrong?

Thanks for your time!

=RCHGetYahooHistory(B5;B6;B7;B8;B9;B10;B11;;;;1;1)

Ulli Kloeffel

Wed Nov 19, 2014 1:36 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I don't know what to tell you. When I do it here, everything works fine.
But I don't have all of your parameter values either. Although I doubt they
would make a difference.

Is there a reason you use the date parameters? They're not needed if you
are getting everything from the most current available date backward.

I notice you are using semi-colons as delimiters. It could be something
strange is going on with either date or amount conversions because of the
difference in regional settings (either at the EXCEL level, or the
operating system level).

On Wed, Nov 19, 2014 at 1:32 PM, ukloeffel@t-online.de [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hello Randy!
>
> Your work is great and I used it partially some years ago!
>
> I used the RGH GetElement Number in conjunction by the RCH Stock Markets
> Function (2.1.2014 or before) since 2012 in order to see the prices of
> the ^gdaxi.
>
> All was very good!
>
> Now since 07.10.2014 I see by this function all prices, the close, the
> open the High and the Low. But the days before 07.10.2014 show only the
> Close.
>
> I work with the DMI and need all this prices.
>
> What is wrong?
>
> Thanks for your time!
>
> =RCHGetYahooHistory(B5;B6;B7;B8;B9;B10;B11;;;;1;1)
>
> Ulli Kloeffel
>

Wed Nov 19, 2014 3:43 pm (PST) . Posted by:

"Ron Spruell" hashky

Randy -
I am back at the trough to beg and grovel again.  I had a great spreadsheet written that worked well, and then cefconnect.com changed their website to java script.  I would like to be able to put in a portfolio and pull data from cefconnect and morningstar.  But the cefconnect portion is broken.
I was pulling in

| Ticker | Fund Name | Strategy | ClosingPrice | PriceChange | NAV | Premium/Discount | DistributionRate |

using
=RCHGetHTMLTable("http://www.cefconnect.com/Pricing/DailyPricing.aspx",">Fund Name",-1,"",1)in an array.
Can you help?  I don't know where to go to look for the data.
Ron Spruell

Wed Nov 19, 2014 3:57 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

According to my FireFox HTTPFix extension, it looks like the data is here:

http://www.cefconnect.com/Resources/Funds/?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip

On Wed, Nov 19, 2014 at 4:43 PM, Ron Spruell hashky@...wrote:

>
> I am back at the trough to beg and grovel again. I had a great
> spreadsheet written that worked well, and then cefconnect.com changed
> their website to java script. I would like to be able to put in a
> portfolio and pull data from cefconnect and morningstar. But the
> cefconnect portion is broken.
>
> I was pulling in
>
> Ticker Fund Name Strategy ClosingPrice PriceChange NAV Premium/Discount
> DistributionRate
>
> using
> =RCHGetHTMLTable("http://www.cefconnect.com/Pricing/DailyPricing.aspx",">Fund
> Name",-1,"",1)
> in an array.
>
> Can you help? I don't know where to go to look for the data.
>
> Ron Spruell
>

Wed Nov 19, 2014 10:17 pm (PST) . Posted by:

zbgb952

Hello Randy,

It is currently 10:13 PM Pacific Time on 11/19/2014 and it appears that non of my spreadsheets
that have smf functions in them are working. OK..I just tried to open a few of them but I get the
same results for all. The spreadsheet opens but remains white/blank...with the cursor as an hour glass... in the lower right side of the spreadsheet, where it shows % of calculations complete, it continues to show 0%. When I click on the spreadsheet, in the upper left hand
side of the screen it says "Excel Not responding".

They won't close either...I have to cancel it.

Other spreadsheets that don't use smf function seem to open ok though

I also tried replacing smf with your most recent work-in-progress add in... same results.

Everything worked find yesterday...but not today!!!

Have you any idea as to the cause and/or what I can do about it? Thanks.


Wed Nov 19, 2014 10:35 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The most likely reason is that one of the websites you're retrieving data
from is down. When that happens, each function that accesses a web page
from that website needs to time out before the add-in can continue on to
the next function.

I've had it happen several times with the Zacks web site.

Another possibility is that you've added some type of firewall that is
preventing EXCEL (and the add-in) from accessing the Internet?

What happens when you start from a new worksheet and enter a new add-in
function to retrieve data?

On Wed, Nov 19, 2014 at 11:17 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> It is currently 10:13 PM Pacific Time on 11/19/2014 and it appears that
> non of my spreadsheets
> that have smf functions in them are working. OK..I just tried to open a
> few of them but I get the
> same results for all. The spreadsheet opens but remains white/blank...with
> the cursor as an hour glass... in the lower right side of the spreadsheet,
> where it shows % of calculations complete, it continues to show 0%. When I
> click on the spreadsheet, in the upper left hand
> side of the screen it says "Excel Not responding".
>
> They won't close either...I have to cancel it.
>
> Other spreadsheets that don't use smf function seem to open ok though
>
> I also tried replacing smf with your most recent work-in-progress add
> in... same results.
>
> Everything worked find yesterday...but not today!!!
>
> Have you any idea as to the cause and/or what I can do about it? Thanks.
>

Wed Nov 19, 2014 10:22 pm (PST) . Posted by:

zbgb952

I am using Windows 7 and Excel 2013. Again, everything worked yesterday but not today.

Also, I openned a blank Excel worksheet...OK so far...and typed



=RCHGetTableCell("https://finance.yahoo.com/q/co?s=IBM+Competitors",1,"Market Cap:")


in one of the cells, just as a test. I saw this function in one of your web site messages..the person said this worked...but I got the same results... nothing...



Wed Nov 19, 2014 10:31 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

That function worked fine for me just now when I tried it. According to my
log file, it took 4 seconds to respond. Usually, Yahoo web pages take a lot
less time -- a third of a second to a full second.

Can you access that URL using the EXCEL Web Query dialog (keyboard shortcut
alt+d+d+w)?

On Wed, Nov 19, 2014 at 11:22 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am using Windows 7 and Excel 2013. Again, everything worked yesterday
> but not today.
>
> Also, I openned a blank Excel worksheet...OK so far...and typed
>
> =RCHGetTableCell("https://finance.yahoo.com/q/co?s=IBM+Competitors",1,"Market
> Cap:")
>
> in one of the cells, just as a test. I saw this function in one of your
> web site messages..the person said this worked...but I got the same
> results... nothing...
>

Thu Nov 20, 2014 1:18 am (PST) . Posted by:

zbgb952

Hello Randy...

It seems like I have to answer you under a 'new topic' because my firefox browser won't let
me send you any reply to your message for some reason. The reply box comes up but I can't
type anything into it for some reason.

I don't know what the problem is...but I also noticed that Excel won't let me extract data
from websites either. This all started today for some reason..and since your program gets
data over the internet, it is probably related. My email works fine and my browser goes
to websites fine... but My excel 2013 stopped working right for some reason.

I may have to call a tech to come look at it.

Thanks.


For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar