I wouldn't use the smfGetTagContent() that way, because you have no idea if the last data will always be the 12th item in the list. Also, I found I was doing...
18340
smf_addin@yahoogroups...
May 1, 2012 9:21 am
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the smf_addin group. File : /Templates...
18341
Randy H
rharmelink
May 1, 2012 9:31 am
I just uploaded a little template to give an example of extracting data from the Google Quotes API: smfGetTagContent-Google-API-Quotes.xls Like Yahoo, it can...
18342
bob_cutillo
May 1, 2012 2:02 pm
Elements 4 for Industry and 13862 for Name stopped returning the info I want and now return Error when used with the download and rchgetelement functions. Do...
18343
Randy Harmelink
rharmelink
May 1, 2012 3:23 pm
Both of those elements are working fine for me. You probably just need the new element definitions -- smf-elements-1.txt from the "Works in Progress" folder of...
18344
Ken
kenc_7_21
May 1, 2012 3:26 pm
It displays "#NAME?" and says unable to conncet. How do i fix it?...
18345
Randy Harmelink
rharmelink
May 1, 2012 3:27 pm
Without more specifics about what is returning #NAME?, it's hard to help. There are several reasons it could occur. "Unable to connect" sounds like you have a...
18346
bob_cutillo
May 1, 2012 4:19 pm
I read the other messages and posted the works in progress file. Thank you...
18347
B B
kokdari82
May 1, 2012 5:01 pm
Awesome. I didn't realize the functions could be used like this. Thank you very much....
18348
Subu S
mail_to_subu
May 1, 2012 6:33 pm
Hi Randy Good day to you... Here's what I've done ... - I've tried to use the latest Add in from http://bit.ly/Inmrc9 i.e. downloaded and extracted files to...
18349
MikeM
mikemcq802
May 1, 2012 6:40 pm
All of those elements are from MSN. MSN recently changed its website. You need to get the latest smf-elements-1.txt file from the Works In Progress folder in...
18350
bizmark_ee
May 1, 2012 9:06 pm
Just checking: Is element 25 supposed to be working yet? I tried using latest definition file, and the formula, =RCHGetElementNumber("CHK";,25), returns a...
18351
Randy Harmelink
rharmelink
May 1, 2012 9:09 pm
That's what MSN is posting as "Last Price"....
18352
bizmark_ee
May 1, 2012 9:15 pm
OK, but when I go to http://investing.money.msn.com/investments/stock-price?Symbol=chk&ocid=qbeb, it shows the correct last price ($19.60) at the top. Is your...
18353
Randy Harmelink
rharmelink
May 1, 2012 9:40 pm
Most MSN elements come from the print report page, so that only one web page needs to be retrieved: ...
18354
ccsjeba
May 1, 2012 9:57 pm
This is great. Thanks a lot Mike...
18355
ken
mustang66.7599
May 2, 2012 12:43 am
I see how the first extraction will get the last price for MSFT - how do I set it up to get the last price of whatever symbol I enter in A2? _____ From:...
18356
Randy Harmelink
rharmelink
May 2, 2012 12:55 am
Take a look at the template. It uses smfGetTagContent() to get the <finance> tag for the particular ticker symbol, and then uses smfStrExtr() to extract the...
18357
Lawrence
lawleesh
May 2, 2012 7:07 am
Hi Is there a way to download info from ft.markets.com? They have a lot of good fundamental info on companies. regards LL...
18358
Randy Harmelink
rharmelink
May 2, 2012 8:43 am
Site not found... When you have the correct domain, try a search of the message archives to see if earlier examples can be found....
18359
talgg
May 2, 2012 3:00 pm
Randy, thanks for taking the time to fix problems with MSN. Would you mind please writing specific directions as to what we are supposed to do, which files to...
18360
rainerglobal@...
rainerglobal...
May 2, 2012 4:50 pm
Hello, just wondering what would be the best way to extract data from http://www.forexpros.com/indices/indices-futures without having to write code. For...
18361
Randy Harmelink
rharmelink
May 2, 2012 5:26 pm
Best practice when updating add-in files: 1. Exit EXCEL 2. Download new file(s), replacing the old one(s) 3. Restart EXCEL In this case, you want the...
18362
Randy Harmelink
rharmelink
May 2, 2012 5:28 pm
You can get the first table with: =RCHGetHTMLTable("http://www.forexpros.com/indices/indices-futures",">Chg. %",-1,"",1) I don't see any bid prices. On Wed,...
18363
talgg
May 2, 2012 5:33 pm
thanks...but where do i put the file smf-elements-1.txt once i download it? i did a search on my computer and i don't think i have that file on my computer...
18364
Randy Harmelink
rharmelink
May 2, 2012 6:00 pm
It should be in the folder on your computer where the add-in files are located. It's a necessary file for the add-in, if you want to use the ...
18365
Stefn Rai
rainerglobal...
May 2, 2012 8:19 pm
Hi Randy, and thank you for your quick response. I was actually looking for the last price, high and low which they show on that page. I do not seem to get the...
18366
front.paige
May 2, 2012 8:30 pm
I have a new office suite. I am trying pull info from the web. But, it seems to have changed from previous versions. Any Mac user know how to get info to...
The old file is in the SMF Add-In folder in your computer. You have to replace that old file with the new file (smf-elements-1.txt) from the "Work in Progress"...
