+ Reply to Thread
Results 1 to 5 of 5

[YET TO RESOLVE] Need help in looping and displaying values

  1. #1
    Forum Contributor
    Join Date
    02-22-2015
    Location
    India
    MS-Off Ver
    MS Office 2007
    Posts
    100

    [YET TO RESOLVE] Need help in looping and displaying values

    Greetings to all.

    Attached Macro-enabled-Excel imports data and shows content for a single query (through manual operation).

    Can somebody change code (macro) so that Excel imports data for ALL the query elements available in the Excel sheet.

    Data has to import without manual intervention (not like giving each and every query names in the textbox and fetching data, but Excel macro has to take each and every query elements' names, fetch and store in the same Excel). This is initiated by clicking on a Button in the Excel (without giving any query element name manually).

    COMPLETE URL AS API (SAMPLE):
    http://www.google.com/finance/getprices?q=TAJGVK&x=NSE&i=1800&p=1d&f=d,c

    DESCRIPTION OF THE URL:
    http://www.google.com/finance/getprices?
    'q -> stock symbol on Google finance - ALL THE STOCK SYMBOL NAMES' DATA (GIVEN IN THE EXCEL) HAVE TO BE IMPORTED
    q=TAJGVK&
    'x -> exchange symbol
    x=NSE&
    'i -> interval (here 60 means 60 sec [1 minute interval])
    i=1800&
    'p -> period (here 5d denotes 5 days of data)
    p=1d&
    'f -> parameters (day [d], close [c], open [o], high [h], low [l] and volume [v]) - I TAKE VALUES OF 'D' & 'C' ALONE HENCE REMAINING SKIPPED (o, h, l, v)
    f=d,c

    Please see the attached image for what my expectation is and how I expect result to be: Excel format.png

    Thanks for your patience and attention.

    Eagerly waiting for a complete macro enabled Excel.
    Attached Files Attached Files
    Last edited by LesliePrabakar; 07-17-2016 at 10:41 AM.

  2. #2
    Forum Contributor
    Join Date
    02-22-2015
    Location
    India
    MS-Off Ver
    MS Office 2007
    Posts
    100

    Re: Automated data import through API - MACRO HELP

    If I miss-out any info or I'm unclear with my explanation kindly advice.

    Expecting some kind help on the query asked. Thanks in advance.

  3. #3
    Forum Contributor
    Join Date
    02-22-2015
    Location
    India
    MS-Off Ver
    MS Office 2007
    Posts
    100

    Re: Automated data import through API - MACRO HELP

    Any help providers there..

    I attached the Excel and image for assistance. Please help.

    If I'm not clear with my description, kindly let me know for better assistance.

  4. #4
    Forum Contributor
    Join Date
    02-22-2015
    Location
    India
    MS-Off Ver
    MS Office 2007
    Posts
    100

    Re: Automated data import through API - MACRO HELP

    Let me simplify the Query:
    There is a list. From the List, each and every list element has to be fetched and values need to get displayed.

    Please help.

  5. #5
    Forum Contributor
    Join Date
    02-22-2015
    Location
    India
    MS-Off Ver
    MS Office 2007
    Posts
    100

    Re: Automated data import through API - MACRO HELP

    Help appreciated!

    Anyone there..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Displaying multiple values based on several cell values (Sorry about the rubbish title!)
    By Sophie.Durrant in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-15-2015, 12:23 PM
  2. Pivot Chart displaying percentage values as decimal values
    By figo12 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-05-2013, 05:02 PM
  3. Looping for values ?
    By DoriBeE in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2011, 12:44 PM
  4. looping through and deleting row with certain values
    By longhorn23 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-02-2010, 04:54 PM
  5. Displaying larger values with smaller values in a Column Chart
    By Max9 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-20-2010, 11:59 PM
  6. [SOLVED] finding values and displaying adjacent values
    By willy3211 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-12-2005, 11:49 AM
  7. [SOLVED] Comparing values in two columns and displaying missing values in n
    By cpetta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2005, 11:29 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1