Search results

I have XL2007. I have created my ss using CondFormat (CF). All the colors and logic are correct and the way that I want them. I add a single row at the top of the ss every stock trading day. Here's the issue. When I add a new row I manually enter 4 numbers. The previous cells for these...

To be more precise. Each stock trading day I enter in 2 numbers into a spreadsheet(ss)the advanced (adv) and declined (dec) stocks for the day. These numbers are used to generate 2 additional columns. The total # cols for each day is 4, they are: adv, dec, breadth1 and breadth2. Based on...

I've made some posts over the last few days and want to know how I can respond directly to the person(s) that responded. For instance, Hui responded to a post that I made yesterday. I added some additional q's, based on his response, to his post but not sure whether Hui actually receives the...

Hui, You mentioned "It can't be extended past 2 colors without additional CF rules". To me this implies that it can be done in a single rule but the logic would be more complicated, is this correct? If it can be done in a single rule can you give me some keywords that I can google to get...

Is it possible to have a single rule that controls more than one cell color when doing a conditional formatting rule. For example, assume that we have a single cell that we want to color either red or green. Can we say something like if cell > 0 color green, if cell < 0 color red. I...

I'm not sure this is the place to ask this question. Is there anyway to search for a previous post based on the username. For example, assume I made a post about 6months back and want to retreive how do I do that?

Thanks for both responses. Just what I wanted to do. The avatar is me with 2 grand kids.

I want to color more than 1 cell based on the values of 2 cells. I know how to write the cond. format rule to color a single cell. For example, assume that there are 2 cols names plus and down. The following logic would be used to color the cells. if plus<300 and down<300 and...

The following formula is used to calculate for stochastic oscillator. Do you know if this is available where I can download? Formula: %K = 100 ( C - L14) / ( H14 - L14) %D = SMA3 ( %K ) %K = Fast Stochastic, %D = Slow Stochastic C = Latest close L14 = Lowest close of the 14 previous...

I have a workbook with about 50 worksheets. How can I manage this so that I'm not looking through all worksheets to find the one I want? If I could something like Windows Explorer where there's directory and underlying files would be the best approach. Thanks

I have a scatter plot where the x-axis goes from 0 to 80 but my data's range is from 55 to 75. How can I adjust the scale on the x-axis?

I'm trying to get a simple plot using pilot charts. The example data I have is: y-axis -> -3,-2,-1,0,1,2,3 x-axis -> -5,-5,-3,0,1,2,2 I think what I need is a simple tutorial on how to create a simple pilot chart. I've googled but can't seem to get the plot I want. Do you have any...

I have a data file of stdDev's of volatility. The .csv file can contain anywhere from 100-200 records (1 record=1 line of date,data) of date and the stdDev data. The format for each record is mm/dd/yyyy, %1.2f. The range for the stdDev is +/-5.00. I have a Python program that outputs the .csv...

I want to calc the HV for several diff stock symbols. I would like to download ticker symbol data via Yahoo (it's free) and then calc the HV. I either want to automate this or keep the user intervention to a min. Any ideas? Thanks.

I want to create a ss that performs a calculation depending on the value in a specific row-col. For example, the range for A1 would be the following values, LS,SS, LC, SC, LP, SP. For each value of A1 there would be some calculation. In programming language it would take the following form...

For stock option trading there is a chart called a "Profit-and-Loss" form. I would like to create a template in xl and use during my analysis. The form consists of vertical scale and horizontal scale. The vert scale (y-axis) is left justified and starting from the bottom and working to the top...

I want to have a nested 'for' loop that prints the results to sequential horizontal cells. It would look something like the following: for x = 150 to 200 increment by 50 for y = 2% to 6% increment by 1% z = (some calculation involving x and y) print y and z to cells (see NOTE: below)...

Assume that I have an xl ss with all rows and cols in a nice orderly fashion. What I want to do is resize some of the cols without disturbing the col width for all other cells in that col? For example, assume I have col A that has 5 cells (A1:A5). I want to resize the col width of A3 to be...

Hui, Thanks for your response. This helps me a bunch.

Assume I have the following ss A B L -2 S 3 L 5 L 3 S -1 If colA = "L" and colB > 0 then count += 1 if colA = "S" and colB > 0 then count += 1 else do nothing The answer for "L" = 2 The answer for "S" = 1 Thanks for your time, Jake