Kamis, 18 Februari 2016

[smf_addin] Digest Number 3642

7 Messages

Digest #3642

Messages

Wed Feb 17, 2016 4:51 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I don't do anything with GICS, at least not knowingly.

On Wed, Feb 17, 2016 at 4:38 PM, zellabettic@... wrote:

>
> Ok - thanks. Are you aware of any other free source to download GICs data
> if the Fidelity site is blocking the addin?
>

Wed Feb 17, 2016 4:57 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

They're returning error for you because the cell reference isn't referring
to the ticker symbol...

When I pointed them to the correct cell, it worked fine.

On Wed, Feb 17, 2016 at 4:47 PM, perseuslim11@... wrote:

>
> This is working fine for me:
>
> =smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",4,">Last
> Price")
>
> BTW, this will have the function convert it into a number:
>
> =smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",4,">Last
> Price",,,,1)
>
> This also worked for me:
>
> =smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",3,">Today's
> Change",,,,1)
>
>
> the 3 functions above doesnt work, still returning a "Error" word only ,
> hmm..
> I'm attaching my input page here, maybe that will be easier to diagnose
> the problem?
> btw, all 3 functions above work for many other stocks I've tested with,
> only this CCB (2925)
> is weird
>
>

Wed Feb 17, 2016 8:22 pm (PST) . Posted by:

"joo zhi" perseuslim11

Randy, the one I sent u might be the wrong version of my template. Coz I forgot to chg back the cell reference, but in my own the cell reference refers to TickerNo , which is the cell with the four digit ticker number  :)

Sent from Yahoo Mail on Android

On Thu, 18 Feb, 2016 at 8:57, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:  

They're returning error for you because the cell reference isn't referring to the ticker symbol...

When I pointed them to the correct cell, it worked fine.

On Wed, Feb 17, 2016 at 4:47 PM, perseuslim11@... wrote:

This is working fine for me:

=smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",4,">Last Price")

BTW, this will have the function convert it into a number:

=smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",4,">Last Price",,,,1)

This also worked for me:

=smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",3,">Today&#39;s Change",,,,1)

the 3 functions above doesnt work, still returning a "Error" word only , hmm..I'm attaching my input page here, maybe that will be easier to diagnose the problem?btw, all 3 functions above work for many other stocks I've tested with, only this CCB   (2925) is weird 

Wed Feb 17, 2016 8:54 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Have you tried smfForceRecalculation? It could be you just had a
communication problem and got a bad copy of the web page.

On Wed, Feb 17, 2016 at 9:22 PM, joo zhi perseuslim11@...wrote:

>
> Randy, the one I sent u might be the wrong version of my template. Coz I
> forgot to chg back the cell reference, but in my own the cell reference
> refers to TickerNo , which is the cell with the four digit ticker number :)
>
> Sent from Yahoo Mail on Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
> On Thu, 18 Feb, 2016 at 8:57, Randy Harmelink rharmelink@gmail.com
> [smf_addin]
> <smf_addin@yahoogroups.com> wrote:
>
>
> They're returning error for you because the cell reference isn't referring
> to the ticker symbol...
>
> When I pointed them to the correct cell, it worked fine.
>
> On Wed, Feb 17, 2016 at 4:47 PM, perseuslim11@... wrote:
>
>>
>> This is working fine for me:
>>
>> =smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",4,">Last
>> Price")
>>
>> BTW, this will have the function convert it into a number:
>>
>> =smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",4,">Last
>> Price",,,,1)
>>
>> This also worked for me:
>>
>> =smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",3,">Today&#39;s
>> Change",,,,1)
>>
>>
>> the 3 functions above doesnt work, still returning a "Error" word only ,
>> hmm..
>> I'm attaching my input page here, maybe that will be easier to diagnose
>> the problem?
>> btw, all 3 functions above work for many other stocks I've tested with,
>> only this CCB (2925)
>> is weird
>>
>>
>

Wed Feb 17, 2016 9:06 pm (PST) . Posted by:

perseuslim11

nope, that I didnt try before, currently still at university, will go try it out when i reach home, and will ket you jnow of the results Randy ^^

i will repost a correct version of my template input page if it still doesnt work after force recalculation :)

Thu Feb 18, 2016 1:26 am (PST) . Posted by:

perseuslim11

it worked after the forced recalculation, it appears that it really is due to a bad copy of the webpage as you've mentioned ^_^ thanks Randy



oh ya, it it advisable to tie the force recalculation macro to keyboard if i usually open several copies of xlsm but all are using only one type of add-in, which is your RCH add-in?


How do I run the smfForceRecalculation macro?

You can use the keyboard shortcut alt-F8 to bring up EXCEL's macro dialog window. Unfortunately, this window does NOT list macros that are part of an add-in. That means you need to type in the macro name. When you complete entering the macro name, you should see the various buttons activate. You then click "Run" to run the macro.

I have actually assigned the macro to a keyboard shortcut (done from the "Options..." button, which is located several buttons below the "Run" button used above). I also have added a button to my Quick Access Toolbar in EXCEL 2007 that runs the macro. It is what I use most often. In fact, I usually click on it each time before I open a new workbook, to reset the "saved array" of web pages for that workbook. But you probably don't want to do that if you have a number of workbooks open that use add-in functions, since the macro will force ALL add-in functions in ALL workbooks to recalculate.



you've mentioned that you tie them to keyboard, but dont encourage if several workbooks use add-in functions, but i assume you mean several workbooks, all of which are using different add-ins (instead of the same add-in?)

Wed Feb 17, 2016 6:47 pm (PST) . Posted by:

gsimon408

As noted by Randy in several posts, RCHGetElementNumber functions that relied on Morningstar "printreport" pages stopped working for awhile. As of today, they are working again. Morningstar "quicktake" pages were also not working and are now OK.


I had started reworking my spreadsheet using Randy's tip in post 29895, but also found some other pages that might be useful to anyone using Morningstar "quicktake syndication" pages for trailing returns etc.


Links to Google quicktake pages:
http://quicktake.morningstar.com/


From above, the syndication index:

http://quicktake.morningstar.com/syndication/index.htm http://quicktake.morningstar.com/syndication/index.htm


Not sure if it's a coincidence or not, but I reported to Google this morning that their mutual fund links that used quicktake.morningstar.com were broken (error 403) and this afternoon all is working. Even when our son worked at Google, I could never get anything fixed.

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.02

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)