We need some VBA code that, collects and filters XML from a range of Google RSS feeds that we query. Inputs and filters are user-defined in the excelsheet through appropriate news search keywords.
There will be four sheets.
1) Sources
Column A: Symbols, user-defined (Example: FTT)
Column B: Keywords, coupled to symbols (Example: "finning international -shark") (keywords are variables for XML/RSS request from google news)
Example google RSS link: [login to view URL]
2) All news
Column A: Time ("pubDate6" from XML, ordered from now to past)
Column A: Symbols (Example: FTT)
Column B: "title4" from XML
Column C: the http hyperlink in "guid" from XML
3) Filtered news:
There is a button on this sheet that activates the VBA module to download/filter/process the RSS results.
Same as 2, but had to pass filter and processing to be placed on this sheet:
News must have been published (according to "pubDate6" from XML) *after* 4pm EST of the last workday. (So, if today is Friday, that means Thursday 4pm. If today is Sunday or Monday, that means Friday 4pm.)
In addition, there will be a column D. Column D gives a letter to each news item that passed the time test. This is based on the filter definition on sheet 4:
4) Keywords for filters
Column A: Cell A1, letter "R", if any of the keywords in A2 through A5 is present
Column B: Cell B1, "G", if ... B2 through B5
Column C: Cell C1, "N", if no keywords apply
Column D: Cell D1, "M", if multiple categories apply (e.g. any kewords for G and R at the same time)
Please mention your favourite fruit and/or your favourite colour of M&Ms when bidding for this project. That way I will know you took the time to read this description. Thanks!
Apple!
Hi, I can do it. Can you send sample XLM file you got from google. I propose simple workflow.
1/ User click on a button/run a macro
2/ The macro display a select/open file dialog to select the raw xml data file, which you get from Google
3/ Do what you need: put all data in a worksheet, filtering/categorize the raw data etc
Best regards,
Cuong NH