Search:

Type: Posts; User: vks64

1. Question: how to draw a single candlestick in excel

by vks64
1
Views
218

how to draw a single candlestick in excel

sir,
I have enclosed a sample data in excel sheet.
I want to draw a single candle stick for the data in each of the row (open, High, Low Close)
Additionally, it is preferred that the candle stick...
2. Question: extract data from one excel worksheet to another worksheet

by vks64
0
Views
1,038

extract data from one excel worksheet to another worksheet

Sir,
Sub: extract data from one excel worksheet to another worksheet
I have a model excel sheet enclosed. The table has a list of shares and their price range for a single day split into various...
3. Question: Sub: data to be Updated automatically under the respective heads in an excel sheet

by vks64
0
Views
743

Sub: data to be Updated automatically under the respective heads in an excel sheet

Sir,
I have enclosed a Question Summary in MS word to describe the question in detail
I have also enclosed one excel table to describe the question and answer required in data format.
I want a...
4. Question: How to calculate the angle between two lines formed by connecting any set of numbers?

by vks64
4
Views
736

Sir, In the above illustration all the numbers...

Sir,
In the above illustration all the numbers lie on the same plane and the given numbers may be taken to represent anyone of axis, (in the given example may please be taken to represent the Y...
5. Question: How to calculate the angle between two lines formed by connecting any set of numbers?

by vks64
4
Views
736

How to calculate the angle between two lines formed by connecting any set of numbers?

How to calculate the angle between two lines formed by connecting any set of numbers, For Example Line1 formed by connecting numbers 125, 132 and Line 2 formed by connecting numbers 110, 112 in a...

by vks64
2
Views
708

Yes sir
vks64
7. Question: Convert time into decimals in excel worksheet

by vks64
2
Views
1,295

Thank You Sir!

Thank You Sir!
8. Question: Convert time into decimals in excel worksheet

by vks64
2
Views
1,295

Convert time into decimals in excel worksheet

Sir

How to convert the time factor into decimals in the excel sheet?

For example

When the Time duration is 1:30:00 ( Time is 1 hour,30 minutes and 0...
9. Question: Delete blank rows and columns in excel worksheet

by vks64
12
Views
1,522

Sir, The problem is regarding deleting...

Sir,

The problem is regarding deleting numerous rows under Data>connections>workbook connections of MS Excel 2010. i.e.. removeal of existing data connections. The MS Excel 2010 does not allow for...
10. Question: Delete blank rows and columns in excel worksheet

by vks64
12
Views
1,522

Sir, As suggested, I have checked the workbook...

Sir,

As suggested, I have checked the workbook but the EDIT LINKS option was found to be “Not enabled”. I believe that there were no links.

However, I found that there are numerous work book...
11. Question: Delete blank rows and columns in excel worksheet

by vks64
12
Views
1,522

Thank you sir for your continuos replies, One...

Thank you sir for your continuos replies,

One small mistake regarding the processor, It is intel core i3 processor with windows 7 OS and Not Pentium I3 as mistakenly posted. I believe it is...
12. Question: Delete blank rows and columns in excel worksheet

by vks64
12
Views
1,522

Sir, I have attached pdf sheet showing the...

Sir,

I have attached pdf sheet showing the screen print image of problems faced in excel sheet.
vks64
13. Question: Delete blank rows and columns in excel worksheet

by vks64
12
Views
1,522

Helpful sir, I checked my excel sheet and found...

I checked my excel sheet and found that there was no links.
I have the following two requirements:-
I want to work further towards the same and to identify the problem in my excel...
14. Question: How to link multiple excel sheets to one main source excel sheet

by vks64
7
Views
2,702

Sir, I am interested in the question posted by...

Sir,

I am interested in the question posted by sarsar 2121.
For the purpose, I badly need to understand the reply posted by yourself sir.

Hence I requested sarsar2121 to put up a sample...
15. Question: Delete blank rows and columns in excel worksheet

by vks64
12
Views
1,522

Sir, 1)The first part of the question is cut...

Sir,

1)The first part of the question is cut and pasted as quote;

16. Question: Delete blank rows and columns in excel worksheet

by vks64
12
Views
1,522

Sir , I could not attach a worksheet showing...

Sir ,
I could not attach a worksheet showing the result, because I could not prepare the results in excel sheet. Hence, I had attached one worksheet with input data and was narrating my requirement...
17. Question: Selected functions not working in excel sheet

by vks64
2
Views
708

Selected functions not working in excel sheet

Sir,

I find that during certain times the functions in excel sheet, for example. delete, copy, paste, insert cut cells etc were not working in my excel sheet. I don't know how many other functions...
18. Question: Delete blank rows and columns in excel worksheet

by vks64
12
Views
1,522

Delete blank rows and columns in excel worksheet

Sir,

I want to delete all blank rows and columns in my excel worksheet and restrict my workspace to the data filled up area. i.e. only the used area must figure out in the excel sheet.

Can...
19. Question: How to link multiple excel sheets to one main source excel sheet

by vks64
7
Views
2,702

Please post a sample sheet for reference and...

Please post a sample sheet for reference and another sheet showing your desired result
20. Question: Modulation of data in excel spread sheets

by vks64
0
Views
1,114

modulation of data in excel spread sheets

Dear members,
I have attached an excel sheet named “Ask me model table” for reference:
1) In the attached table, I have presented the trade data of 10 specific shares for a day, as on 19.11.2012....
21. Question: Stockcharts in excel spreadsheet 2007

by vks64
1
Views
398

Sir,
I was using MS Office excel 2007 spreadsheet for drawing stock graph for "volume High Low Close" as below:-
MS Office excel 2007-> insert-> other charts -> stock -> volume-high-low...
22. Question: Collating information available on excel sheets

by vks64
1
Views
603

Collating information available on excel sheets

Hello sir,
I have some excel sheets (15 to 30 nos) containing identical data on certain x number of items; but relates to different dates. Now I need to collate the data pertaining to particular one...

by vks64
1
Views
190

Is there any anyway you download breaking news from different websites directly into your computer as and when it happens?

by vks64
7
Views
1,004

Comment on JBeaucaire's post

Thank You. It is very useful. I am extremely delighted..
Thank You once again!
vks64

by vks64
7
Views
1,004

Comment on JBeaucaire's post

Thank you sir. I have my requirement met. But I have to copy the formula over the full field to get the result. And it is not returning the result for time column sir. Finally please explain what do...
26. Question: Compare related data stored in two or more excel sheets

by vks64
18
Views
3,555

Thank You

by vks64
7
Views
1,004

Comment on JBeaucaire's post

Workbook enclosed

by vks64
2
Views
518

Thank You

by vks64
2
Views
307

Thank You
30. Question: To work on a lower version

by vks64
2
Views
307

To work on a lower version

I was using the latest version of ms office 2007 in my laptop but I had learned ms office and ms access respectively in the ms office 2003 and ms acess 2000 version only.

Hence I was comfortable...

by vks64
7
Views
1,004

Dear sir, For the comfort of explaining I have...

Dear sir,
For the comfort of explaining I have enclosed a real time data as per the actual requirement

In Data-sheet1,End of the data released by the STock exchange are available as released at...
32. Question: Compare related data stored in two or more excel sheets

by vks64
18
Views
3,555

Dear sir, First accept my apology for not...

Dear sir,
First accept my apology for not visiting the site for a long period and hence could not attend your remarks.

Now I enclose the sample excel sheet to illustrate my need.

Sheets no 1...

by vks64
2
Views
518

I have large numerical data stored in excel sheet. I wanted to write simple formulas to compare the numerical values in the columns A to Z.
For Example to compare the values in columns A,B,C,D of...

by vks64
7
Views
1,004

Sir
I have a set of data in excel sheet A as below:
Sheet A
Name of the students Marks in english Marks in maths
A 45 74
B 38 58
C 52 65
D 45 65
E 88 72
F 36 45
35. Question: Unable to browse the site with add-ons enabled

by vks64
1
Views
1,171

Unable to browse the site with add-ons enabled

I am having a broadband internet connection and I regularly visit the National stock exchange of India website and view the intra day charts and other stock charts provided in the site. Recently...
36. Question: Compare related data stored in two or more excel sheets

by vks64
18
Views
3,555

Sir, Your suggestions were of great use and I...

Sir,
Your suggestions were of great use and I would certainly make use of it in simple and smaller applications everyday for which I thank you wholehearted. But I would like to say you that my daily...
37. Question: Compare related data stored in two or more excel sheets

by vks64
18
Views
3,555

Sir, You have correctly assessed my view and...

Sir, You have correctly assessed my view and requirement. The sample enclosed is a selected list of shares traded in the National Stock Exchange of India. Actually the total number of rows in the...
38. Question: Compare related data stored in two or more excel sheets

by vks64
18
Views
3,555

Originally Posted by JB If you'd like...

Originally Posted by JB
If you'd like assistance on this, post up usable sample sets of sheets with enough data in them for me to show you how to do this. Make sure all the hurdles that need to be...
39. Question: Anuitty tables

by vks64
6
Views
1,402

I don't understand the last line '... growing...

I don't understand the last line '... growing taxfree' Please explain.
40. Question: Compare related data stored in two or more excel sheets

by vks64
18
Views
3,555

Compare related data stored in two or more excel sheets

How to compare related data stored in two or more different excel sheets?
For example, annual sales figure of a number of companies relating to two OR more years available in different excel sheets?...
41. Question: Jurisiction of courts in case of online purchases

by vks64
0
Views
189

Jurisiction of courts in case of online purchases

I reside in chennai(formerly Madras) in Tamilnadu state, India. I had purchased a sony ericcson mobile online from an online Trading firm. The supplier was located in a different state (Mumbai...

by vks64
0
Views
402

When I...
43. Question: Preparing charts using excel data

by vks64
2
Views
1,521

preparing charts using excel data

Whether there are any softwares available on the web to prepare detailed charts/graphs showing x and y axis using data stored in MS excel/XML spread sheet?
The chart/graph so...

by vks64
1
Views
3,193

Thank 'U'
45. Question: Transpose rows into columns in a excel spreadsheet

by vks64
3
Views
5,223

Transpose rows into columns in a excel spreadsheet

Can anyone help
1) how to transpose the data in rows into columns and columns into rows in a Excel spread sheet?
2) how to change the numerical order of data in rows/ columns in a Excel spread...
46. Question: Creating a Chart in Excel by including values in X and why Axis

by vks64
2
Views
1,842

Creating a Chart in Excel by including values in X and Y Axis

1) I want to create a chart using the data in my excel sheet.
2) Data in Row 1 should become the x-axis labels in a chart and data in Row 2 should be the y-axis labels and the only data range...
47. Question: Virus removal

by vks64
2
Views
3,611

virus removal

Sir,

I have installed AVG 8.0 free version installed in my windows XP.
It has pointed out that the computer is infected with win32/heur virus.
48. Question: Microsoft Internet Explorer

by vks64
2
Views
1,233

Recently, I had performed the following acts:-...

Recently, I had performed the following acts:-
1) Visited a site http:marketlive.in relating to stock information and allowed it to run certain programmes from the site to enable me to view live...
49. Question: Learning Technical Analysis and interpreting charts of stocks

by vks64
2
Views
3,056

Learning Technical Analysis and interpreting charts of stocks

Sir,
I am a investor in shares and do frequent trading. For the purpose of success in short term investments and day trades I was told that one has to learn Technical Analysis and gain expertise to...

by vks64