excel

  1. A

    How to make excel sheet with stock financials

    I want to make a excel sheet of stocks along with their cmp, financial ratios like roe, roce, pledged shares, etc. but doing it manually for all 5000+ stocks is almost impossible. So can anyone help me how to do it. Most screeners out there mostly doesn’t cover all BSE stocks. If they do, then...
  2. A

    nseindia to Amibroker

    Hi Members, Please help me plot IV data for call and put in amibroker. I want the data to be pulled up from www.nseindia.com. https://www1.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?segmentLink=17&instrument=OPTIDX&symbol=NIFTY&date=28APR2016 Thanks...
  3. I

    Help with Nest

    Hi guys, i am using Nest Terminal for Zerodha and also for Karvy. I have been having difficulty to get the real time data from Nest to link to Excel (No Aibroker or FCharts) I have been working on an option Valuation model for which i just want RTD in Excel. I have tried everything but "#N/A"...
  4. A

    Nifty auto refreshing Excel sheet to Amibroker - Help Needed

    Hi Member, I have an excel sheet that fetches Call Put data from nifty every one minute. That is auto refreshing. I want to plot OI of a current strike price in one chart in amibroker. Please guide. Thanks Aman
  5. A

    Excel Copying

    Hi All, I have attached an auto refreshing excel sheet of HCL tech. I am able to get the max volume using MAX formula. I want to copy the related strike price where max volume falls for CALL & PUT. Max volume in call put change on every refresh, so cannot use simple copy paste. please help...
  6. V

    Need help... access data from Excel Sheet

    Hi All, Successfully configured RT data(Trade Tiger) to amibroker using Excel, as per previous Threads of Josh1 & sr114... Thanks alot for the help. I'm new to Amibroker programming... I got data into Excel, but I dont know how to lookup for the data... particular column like Upper Circuit...
  7. A

    Excel 2007 - Need help with conditional formatting

    Hi members, I am trying to apply conditional formatting to an excel sheet in excel 2007, but not successful. please help. 1. When column A says BUY to corresponding cell in column D should remain +ve number. 2. 1. When column A says SELL to corresponding cell in column D should...
  8. A

    Excel Sheet - Options

    Hi All, I am search an excel sheet that can pull up options data from nseindia.com Please advise if such an excel sheet be formed that can pull such data automatically or at a single click. I want to include Nifty and all stocks having options. Screenshot Example: Thanks mates.....
  9. S

    Financial reports in excel for fundamental analysis

    Hi All, I managed to get P&L, Balance sheet, Cash flow statement into excel for more than 1000 nse listed stocks (using python script :thumb:) How useful are financial reports on moneycontrol for fundamental analysis Is it possible to automate fundamental analysis (at least for screening) Is...
  10. K

    Best Excel Formula file for MCX Base Metals

    Hi All, I am a newbie trader in MCX. Can somebody, please post the links for the best EXCEL Formula file which works for MCX Base Metals? Also, if you could also upload best working Amibroker formula, that would be useful for all. Thanks in Advance. Regards, kacraj.
  11. D

    How can I export explore to csv using AFL code?

    As title, I know how to do it in amibroker by clicking "File -> Export HTML/CSV". However, if I want to perform the action in afl, what should I do? Here is the code that I output the daily return in explore, Filter=1; NumColumns=1; rp = ROC(C); Column0=rp; Column0Name="Daily Return"...
  12. K

    FNO data in excel

    Hello Friends, Can someone help me find NSE FNO data for past 3 months(or more) in excel sheet. All I want is EOD open, high, low, close for the past 3 months or more. Your help will be greatly appreciated. Thank you.
  13. P

    Data Feed (EOD & Intraday) for Excel

    Hi, Is there any data provider who can provide data that can be extracted to MS Excel instead of extracting the same to some charting software like AmiBroker, MetaStock, etc. I have coded ADX, EMA, MACD & Stochastics in excel and use the same to generate signals. Hence, I need some reliable &...
  14. E

    Stocks and F&O Data on Excel?

    I have seen some tools that feed data from Yahoo and Google to Excel. Or tools that have scraped data from NSE/BSE website or other sites. But pretty much all these tools give data for Equities only. None have Futures and Options data. For F&O, pretty much the only options are expensive...
  15. S

    Configuring Amibroker

    I have Amibroker 5.4 I tried to play around and configure it myself but I donot understand anything about it :confused:. I would request someone to do the same for me and help me setup the system so that I am able to generate buy-sell signals for stocks in Nifty and Sensex. Alternatively...
  16. P

    Solving Developing Functions 4 trading EXCEL sheet.

    Here this thread can be utilized for solving your queries or giving some knowledge about the functioning of EXCEL workouts, which can be useful for trading and updating the issues in related like screening, calculations, functions, data, download, auto updating etc. here I am providing...
  17. G

    Google Docs to track Indian MF NAV

    Just thought of sharing it https://docs.google.com/spreadsheet/ccc?key=0Ah16IsF681SudFJVdGNEbmVTRjFWOUUwLVo4RHRaYUE&hl=en_GB It gets data from http://amfiinda.com/spages/NAV0.txt. Just enter Fund Name, NAV price ,Quantity ,Date( optional ). It will do the rest. Please find correct...
  18. Debarghya Mukherjee

    Free Customized Trading Platform with Real time data

    Hello all my Trading friends, I wanted to make a free of cost trading platform for the traderji Users, who doesn't have real time data feed. I saw some threads are there, but there was no solution. I have computer science background. So I decided to make one for myself first. So here in this...
  19. V

    [Tutorial] Using Excel web query

    Hi, I am new to this forum. I found this article online on importing web data into excel sheets, I was hoping this would be of some use to other traders out here. http://articles.techrepublic.com.com/5100-10878_11-6115870.html?part=rss&tag=feed&subj=tr Hope this helps
  20. K

    Import from Y A H O O into Excel using Web-query!

    I'm making an excel to keep updating my current portfolio with the latest rates. For this I'm using web-query in excel to pull the LTP of the stock in the portfolio. Now, I'm able to pull the necessary data properly in the required cell. But the problem is that the cell below becomes blank...