Search the web
Sign In
New User? Sign Up
smf_addin · EXCEL Stock Market Functions Add-in

Group Information

  • Members: 18839
  • Category: Software
  • Founded: Jun 18, 2006
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.
Try Yahoo! Groups Chat Beta! Now available on the left menu. Read more...

Home

 

Activity within 7 days:

Description

This group is the home base for the Stock Market Functions add-in developed by Randy Harmelink. This add-in contains a number of user defined functions for EXCEL that can allow data to be extracted and/or retrieved from the web and placed directly into EXCEL cells or ranges.

The "Files" area of this group contains the add-in, documentation on its functions, and a number of templates that have examples of how the various functions can be used. The "Links" area of the group has a number of tips and FAQs.

The add-in is maintained using EXCEL 2007 under a Vista operating system using U.S. regional settings, so other platforms and/or versions may have issues. No Mac. No Open Office.

If you're reporting a problem, remember that I'm not a mind reader -- "It doesn't work right" is not a helpful description of a problem. Please try to include relevant information, such as:

-- The specific function(s) or template(s) you are having problems with.
-- The parameter(s) you are using with the function(s).
-- The version of EXCEL you use.
-- The operating system you're running EXCEL under.
-- The steps you took to try to resolve the problem.
-- The ticker symbols or URLs that are being used.
-- The results you expect to get and what you actually get.

Most Recent Messages

  (View All)
(Group by Topic)
Advanced
   Start Topic
Income Statement Waterfall Chart
An interesting blog entry on creating some financial statement charts in EXCEL:
Posted - Tue Feb 14, 2012 9:49 am
Randy Harmelink
rharmelink
Offline Offline
Send Email Send Email
Re: AdvFN and UK Stocks
Thanks again for the replies Randy and all, it's appreciated. AdvFN have a banner on their UK website which invites users to "View Our New Historical
Posted - Mon Feb 13, 2012 9:54 pm
paul84j
Offline Offline
Send Email Send Email
Re: AdvFN and UK Stocks
Agreed. But, there was some limited annual financial data so it seems you could have GetAdvFnElement and GetElement return just the bits it could find (with
Posted - Mon Feb 13, 2012 8:51 pm
Mike McQuaid
mikemcq802
Offline Offline
Send Email Send Email
Re: AdvFN and UK Stocks
I don't see any LSE:TRI quarterly or annual financial statements web pages, so smfGetAdvFNElement() would always return "Error" for anything that is
Posted - Mon Feb 13, 2012 8:40 pm
Randy Harmelink
rharmelink
Offline Offline
Send Email Send Email
Re: AdvFN and UK Stocks
Can you point me to a ticker symbol that DOES have the data? I couldn't find an example.
Posted - Mon Feb 13, 2012 8:37 pm
Randy Harmelink
rharmelink
Offline Offline
Send Email Send Email
Add smf_addin to your personalized My Yahoo! page Add to My Yahoo! XML What's This?

Message History

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2012 420 175
2011 529 436 441 269 253 276 373 420 330 226 302 307
2010 548 350 309 317 275 252 442 341 229 333 426 282
2009 234 122 220 224 157 263 174 240 196 258 360 404
2008 53 75 293 215 312 167 251 217 160 160 239 144
2007 230 145 172 188 181 243 255 241 239 273 165 161
2006 9 133 173 209 158 67 195

Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help