How to import "Live Feeds" to F Charts through excel.

[aniruddhadeshpande]

How to import live intraday data in F Charts from Excel,

1. Open an excel workbook. Name it Live Data.

2. Go to Data tab  Import External Data  New Web Query

3. A query window will open  Type www.nseindia.com in address bar  click on Nifty Stock Watch in right column  Click on Hide Icons button to display black arrows in yellow box for each table on the web page  select the Nifty Stock Watch table arrow  Click on Import.

4. The table will be copied to the excel sheet.

5. Go to sheet2  in the cell A1 type formula =left(select first company name in sheet1,9)  drag the formula down till the last company.

6. In cell B1 type formula =last traded price cell  Drag down till last price.

7. Do similar thing for volume in cell C1.

8. Use =today() formula for date and =now() formula for time in columns D and E  Drag down till last price. (Note: Use hh:mm:ss format for time.) Save the sheet.

9. Now go to sheet1 Data tab  Data Range Properties  Refresh Control  Set Refresh Every 1 Min  Click Ok. Save the sheet. (Note: Keep the sheet open all the time.)

10. Now open F Charts  Import/Export  Other  Copy all the company names in excel sheet2 to the Add Multiple Tickers Space  Add Tickers  Exit.

11. Go to Intraday  Source Excel  Refill list  Select Live Data and Sheet2.

12. 1st Data Row = Row of the first company  Put appropriate column names eg: A, B, C, etc for Ticker, Date, Time, etc  Select Subtract Volume  Open Feed At Startup.

13. Go to Filter  Select Monday Friday  Set time From 0955 to 1530.

14. Press Start.

15. Check for intraday prices updating for the tickers in the excel sheet in Intraday Data Option.

16. You have to keep the Excel Sheet  F Charts  Live Data open all the time as well as the Internet connection.

17. Enjoy free Intraday Feed for Nifty Stocks, similar process can be applied for F&O, Commodities etc.

Please feel free to ask any questions

Aniruddha Deshpande

 

[karthik_sri]

Dear Mr.Anirudhha,
Thanks for sharing this excellent note...i can able to plot the data in excel...but have one query where do we find filter in F charts?

13. Go to Filter  Select Monday Friday  Set time From 0955 to 1530.

Could u pls guide us on the 13th Point...i couldnt able to find out the filter and time tabe in F charts

Cheers,
Karthik

 

[muthalif]

sir can u please tell how to set in EXCEL 2007 ?
THANKS

 

[rajendrani]

How to import live intraday data in F Charts from Excel,

1. Open an excel workbook. Name it Live Data.

2. Go to Data tab  Import External Data  New Web Query

3. A query window will open  Type www.nseindia.com in address bar  click on Nifty Stock Watch in right column  Click on Hide Icons button to display black arrows in yellow box for each table on the web page  select the Nifty Stock Watch table arrow  Click on Import.

4. The table will be copied to the excel sheet.

5. Go to sheet2  in the cell A1 type formula =left(select first company name in sheet1,9)  drag the formula down till the last company.

6. In cell B1 type formula =last traded price cell  Drag down till last price.

7. Do similar thing for volume in cell C1.

8. Use =today() formula for date and =now() formula for time in columns D and E  Drag down till last price. (Note: Use hh:mm:ss format for time.) Save the sheet.

9. Now go to sheet1 Data tab  Data Range Properties  Refresh Control  Set Refresh Every 1 Min  Click Ok. Save the sheet. (Note: Keep the sheet open all the time.)

10. Now open F Charts  Import/Export  Other  Copy all the company names in excel sheet2 to the Add Multiple Tickers Space  Add Tickers  Exit.

11. Go to Intraday  Source Excel  Refill list  Select Live Data and Sheet2.

12. 1st Data Row = Row of the first company  Put appropriate column names eg: A, B, C, etc for Ticker, Date, Time, etc  Select Subtract Volume  Open Feed At Startup.

13. Go to Filter  Select Monday Friday  Set time From 0955 to 1530.

14. Press Start.

15. Check for intraday prices updating for the tickers in the excel sheet in Intraday Data Option.

16. You have to keep the Excel Sheet  F Charts  Live Data open all the time as well as the Internet connection.

17. Enjoy free Intraday Feed for Nifty Stocks, similar process can be applied for F&O, Commodities etc.

Please feel free to ask any questions

Aniruddha Deshpande

Aniruddha, if you can please upload the excel file itself with the setting, it would be of great help,

Anyway, thanks for explaining.

Regards,
rajendrani

 

[kharikumaar]

How to import live intraday data in F Charts from Excel,

1. Open an excel workbook. Name it Live Data.

2. Go to Data tab  Import External Data  New Web Query

3. A query window will open  Type www.nseindia.com in address bar  click on Nifty Stock Watch in right column  Click on Hide Icons button to display black arrows in yellow box for each table on the web page  select the Nifty Stock Watch table arrow  Click on Import.

4. The table will be copied to the excel sheet.

5. Go to sheet2  in the cell A1 type formula =left(select first company name in sheet1,9)  drag the formula down till the last company.

6. In cell B1 type formula =last traded price cell  Drag down till last price.

7. Do similar thing for volume in cell C1.

8. Use =today() formula for date and =now() formula for time in columns D and E  Drag down till last price. (Note: Use hh:mm:ss format for time.) Save the sheet.

9. Now go to sheet1 Data tab  Data Range Properties  Refresh Control  Set Refresh Every 1 Min  Click Ok. Save the sheet. (Note: Keep the sheet open all the time.)

10. Now open F Charts  Import/Export  Other  Copy all the company names in excel sheet2 to the Add Multiple Tickers Space  Add Tickers  Exit.

11. Go to Intraday  Source Excel  Refill list  Select Live Data and Sheet2.

12. 1st Data Row = Row of the first company  Put appropriate column names eg: A, B, C, etc for Ticker, Date, Time, etc  Select Subtract Volume  Open Feed At Startup.

13. Go to Filter  Select Monday Friday  Set time From 0955 to 1530.

14. Press Start.

15. Check for intraday prices updating for the tickers in the excel sheet in Intraday Data Option.

16. You have to keep the Excel Sheet  F Charts  Live Data open all the time as well as the Internet connection.

17. Enjoy free Intraday Feed for Nifty Stocks, similar process can be applied for F&O, Commodities etc.

Please feel free to ask any questions

Aniruddha Deshpande

dear aniruddha,

like mentioned by another member earlier , got till the point 12. part. unable to process 13 --the "filter and time" .

please guide

 

[MARUTIMANE]

Thanks a lot Sir, Very nice utility you provided to forum,
Thanks and regards,

Maruti Mane

 

[RANJITSINGH66]

Dear friends,

will anyone especially MARUTIMANE/KHARIKUMARR UPLOAD the said excel file here so that non techie people like us get benefit?
thanks and regards
RANJITSINGH66

 

[murthymsr]

How to import live intraday data in F Charts from Excel,

............................................

17. Enjoy free Intraday Feed for Nifty Stocks, similar process can be applied for F&O, Commodities etc.

Please feel free to ask any questions

Aniruddha Deshpande

Dear aniruddha,

Thanks for the idea.

It may be possible for the user to create his own portfolio through 'My NSE' after log-in and use the scheme proposed by you. This may allow the user to use his own selected list of stocks.

If so, You or any other member may think of making such XL sheet and post it for the benefit of other users.

Hope to see further contributions in this direction.

murthymsr

 

[MARUTIMANE]

Dear All

I have made exl file as per mr. deshpande's instructions, It gets Data from NSE but I have not tried in realtime. with in 2 days I will try this utility in realtime in Fchart and will revert back to forum. If it works without lagging then it is boon to forum. If it works will post exl sheet also for forum use.

Thanks and regards,

Maruti Mane

 

[buccas13]

Can anyone please post the excel file