|
| Discuss Excel Sheet at the Software within the Traderji.com - Discussion forum for Stocks Commodities & Forex; I have a query in ms excel. I am downloading the data through web query ... |
|
|||||||
| Register | Blogs | FAQ | Chat Room [1] | Search | Today's Posts | Mark Forums Read |
| Software Charting, trading & technical analysis software, trading system development and backtesting. |
|
Welcome to the Traderji.com - Discussion forum for Stocks Commodities & Forex. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please read the FAQ. |
 |
|
|
Thread Tools |
| Sponsored Links |
|
#1
15th September 2006, 09:26 AM
|
|||
|
|||
Excel Sheet
I have a query in ms excel.
I am downloading the data through web query NAV from AMFI india the data gets download in one single col. then i use Data > Text to col. to sepreate the data, it is done, but when it gets refresh it is again in the same col. what shall i do. Regards, Chand 
|
|
#2
15th September 2006, 11:26 AM
|
|||
|
|||
Re: Excel Sheet
Quote:
Best Regards, --Ashish
|
|
#4
30th April 2007, 09:11 PM
|
|||
|
|||
|
Re: Excel Sheet
hello friends in trade,
can any one enlighten me on excel sheet, its use, formation, etc.,? enquiringly yours, instaalert.
|
|
#5
1st May 2007, 06:39 AM
|
|||
|
|||
|
Re: Excel Sheet
Dear Instaalert
Please get the excel file from ************ link http://www.************/file/15056057.../Amfi-Nav.html After opening the file right click a cell & click refresh button. he data will be updated. Be patient as it takes some time to download data. Regards.
|
|
#6
1st May 2007, 08:38 AM
|
|||
|
|||
|
Re: Excel Sheet
hi ger06,
thanks for your reply. i downloaded the file, which shows the nav of all mf-s. the xl sheet is only to findout the nav or what are the other uses? can you pl enlighten me?
|
|
#8
1st May 2007, 08:07 PM
|
|||
|
|||
|
Re: Excel Sheet
Quote:
GER06, Great Excell sheet man! it really amazing !! Thanx for your post. Would u plz tell me how we can plot chart with this data? As I know to plot a chart u have at least 4 fields (Open, high,Low,close) for each day but here no such fileds are there. Is it possible to plot line chart in amibroker with the latest NAV of every day(ie. equivalent to closing price???).Do u have the Historical Data for those Funds? Please reply me . I am very much eager to have the chart of those funds in Metastock and Amibroker. Please Help!!!!!!!!! thanx once again.  Debdulal Bhattacharyya Kolkata
|
|
#9
2nd May 2007, 12:35 PM
|
|||
|
|||
|
Re: Excel Sheet
Dear Debudulal
Pl. find herewith txt file. Copy & save them as .afl file in format folder of Amibroker ( give any name as u like). This is for importing of csv file. Import the amfi.csv using this format file. If u have more than 3 files u will get the charts. I hope u know hoe to creat new data base & import the data. If not please search in software section of traderji. U will get lot of information posted by our senior & valued members. Regards.
|
|
#10
2nd May 2007, 07:02 PM
|
|||
|
|||
|
Re: Excel Sheet
Quote:
Thanx again for your help.I have done already all those job what you have told.The afl you posted is good.But My question is that those data of amfi ca't plot bar or candle chart as it has only closing price, is not it? Any way, do u have the historical database of amfi data format? otherwise I have to wait for another three days to get charts and I have to wait another 2months(atleast) to get a readable chart in Amibroker. Can I get it from you? Plz reply. Debdulal Bhattacharyya
|
| Sponsored Links |
|
|
|
| Thread Tools | |
|
|
Similar Threads for: Excel Sheet
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Spreadsheets | CreditViolet | Software | 8 | 4th September 2006 08:12 PM |
| CGTax calculation spred sheet | akh024 | Taxation Matters | 0 | 30th August 2006 06:24 PM |
| exporting to excel | cmlee | MetaStock | 5 | 3rd October 2005 04:34 PM |
| excel help | vvn | Introductions | 4 | 8th August 2005 08:06 PM |
| datas in excel sheet | gopu | General Chit Chat | 1 | 28th October 2004 08:46 AM |
Indemnity, Disclaimer & Disclosure
Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum
Rules Disclaimer & Disclosure and indemnify Traderji.com, its
associates and related parties of all claims howsoever resulting from
the usage of the forum.
• Disclaimer: Trading or investing in stocks & commodities
is a high risk activity. Any action you choose to take in the markets
is totally your own responsibility. Traderji.com will not be liable for
any, direct or indirect, consequential or incidental damages or loss
arising out of the use of this information.
• Disclosure: The information in this forum is neither an offer
to sell nor solicitation to buy any of the securities mentioned herein.
The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
