$$Excel-Macros$$ Re: Risk Graphs
Yes, this is what I am looking for. I guess the X-axis is fixed and cannot dynamically adjust. Now I have to figure out how to do this with an Option (put or call). http://www.optiontradingpedia.com/option_trading_risk_graphs.htm I'm not interested in the option combos, but just one option (put or call). Thanks, On Apr 10, 6:36 pm, Tom Jeffries wrote: > Take a look at the attached spreadsheet. I think it does what you want. If > you have any questions let me know. > Tom Jeffries > > > > On Fri, Apr 10, 2009 at 8:44 AM, mother wrote: > > > I'm trying to figure out how to create a Simple Risk Graph (profit/ > > lost diagram) like the one described at Investopedia: > > >http://www.investopedia.com/articles/optioninvestor/05/012605.asp > > > I do not want the add all the extra complexity of stuff. Just a > > simple/basic Risk Graph. > > > Could someone help me with this? > > > If this is not the correct group to post this to, please recommend a > > group. > > > Thanks, > > > > RiskGraph.xls > 23KViewDownload- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Risk Graphs
Take a look at the attached spreadsheet. I think it does what you want. If you have any questions let me know. Tom Jeffries On Fri, Apr 10, 2009 at 8:44 AM, mother wrote: > > > I'm trying to figure out how to create a Simple Risk Graph (profit/ > lost diagram) like the one described at Investopedia: > > http://www.investopedia.com/articles/optioninvestor/05/012605.asp > > I do not want the add all the extra complexity of stuff. Just a > simple/basic Risk Graph. > > Could someone help me with this? > > If this is not the correct group to post this to, please recommend a > group. > > Thanks, > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- RiskGraph.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Formatting of datas
Your example is somewhat confusing but if you just want to copy formats have you tried right click -> paste special -> formats? or the 'Format Painter' which in excel 2007 is on the Home ribbon near cut/copy/paste buttons On Apr 9, 6:09 pm, KARTHIKEYAN B wrote: > Hi, > Can you help me on this file asap. Its urgent from my end. > > The sample file contains the raw datas and it should be formatted as like > the format available > with the Header to be sent to Vendor in the prescribed format. Can it be > possible to send them in > a single excel file? Kindly update this as it is very urgent and also > secret. > > Help the needy with > SIMPLE and SAFE(LY)TY LIFE > Karthikeyan.B > > sample.xls > 39KViewDownload > > Format.xls > 69KViewDownload --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Writing cell contents to seperate files
While looking at other posts I ran across enough info to recall how to
do this.
Thanks anyway
Public Sub WriteXML()
' quick and dirty macro to write generated XML data to seperate files.
' Flename is based on worksheet path, run number and row number
RunCol = Range("run").Column
XmlCol = Range("Xml").Column
FilePath = ActiveWorkbook.Path
Set fs = CreateObject("Scripting.FileSystemObject")
LastRow = Cells.Find("*", ActiveCell.SpecialCells(xlLastCell), , ,
xlByRows, xlPrevious).Row
For Row = 2 To LastRow
XML = Cells(Row, XmlCol).Value
If XML Like " Once, long ago I used to write stuff like this but it's been too many
> years and I don't remember where to start.
>
> I'm using Excel to generate test data.
>
> The sheet has all the data I need calculated.
> Now I need a macro to loop thru a named range of cells and write the
> value of each cell to a new file who's name I can easily calculate
> (like file-a1.txt, file-a2.txt...).
>
> Help appreciated.
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Risk Graphs
I'm trying to figure out how to create a Simple Risk Graph (profit/ lost diagram) like the one described at Investopedia: http://www.investopedia.com/articles/optioninvestor/05/012605.asp I do not want the add all the extra complexity of stuff. Just a simple/basic Risk Graph. Could someone help me with this? If this is not the correct group to post this to, please recommend a group. Thanks, --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help needed : Excel Headers
Thankss it worked :-) On 4/9/09, Manoj S Negi wrote: > > Hi Mahreen, > > Follow the below mentioned procedure for the same. > 1. go to the file menu > 2. select page setup > 3. click on sheet tab > 4. there is option "Rows to repeat at top" click on that and give the range > of required field > 5. than come back by click on ok and print it. > > > > *Unfeigned Regards > Manoj S Negi > "Miles & miles to go before I sleep"* > *¨`·.·´¨) Always > `·.¸(¨`·.·´¨) Keep > (¨`·.·´¨)¸.·´ Smiling! > `·.¸.·´ > (¨`·.·´¨) (¨`·.·´¨) > `·.¸(¨`·.·´¨)¸.·´ > `·.¸.·«*:·. > .·:* > *:·. > *«*:·. > .·:* > *:·. > > * > On Thu, Apr 9, 2009 at 12:38 PM, Mahreen Ellahi < > mahreen.a...@googlemail.com> wrote: > >> I have few cells in excel worksheet that I want to show as header in print >> copy. Can any one tell me how to select those cells to show as print header. >> >> >> Regards >> Mahreen >> >> >> > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Macros in Outlook
It was me who shared this :-)).. Developed by one of my friend. His
name is Prasad Patkar...
On 4/10/09, Dave Bonallack wrote:
>
> Hi Roopesh,
> Thanks a lot.
> Regards - Dave.
>
> From: roopesh.ka...@gmail.com
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Re: Macros in Outlook
> Date: Thu, 9 Apr 2009 08:00:32 +0530
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Dave,
>
>
>
>
>
> Below is
> the code of the macro in the file that Mudassar. I am attaching another file
> that I use for bulk mailing, I have a requirement where in on a given day I
> need to send over 1000 emails and that database of mine is growing each day,
> I
> cannot afford to sit and press “Yes” on the security warning so I
> have altered the code to suit my need and it works perfect. Pls read the
> code
> carefully as there are some fine points that you need to read properly.
>
>
>
> Regards,
>
> Roopesh Kapur
>
>
>
> Sub send(i As Integer)
>
>
>
> Set myOlApp =
> CreateObject("Outlook.Application")
>
> Set mail = myOlApp.CreateItem(olMailItem)
>
> Set attach = mail.Attachments
>
>
>
> Worksheets(2).Select
>
> mail.To = Cells(i, 1)
>
> mail.CC = Cells(i, 2)
>
> mail.BCC = Cells(i, 3)
>
> mail.Subject = Cells(i, 4)
>
> mail.Body = Cells(i, 5)
>
> If Cells(i, 6) <> "" Then
>
> attach.Add ""
> & Cells(i, 6) & ""
>
> End If
>
> mail.send
>
>
>
> End Sub
>
>
>
> Sub email()
>
>Dim count As Integer
>
>Dim i As Integer
>
>Dim ok As Boolean
>
>Dim errcount As Integer
>
>Dim message As String
>
>
>
> Worksheets(1).Select
>
> count = Cells(11, 8)
>
> Worksheets(2).Select
>
> ok = True
>
> errcount = 0
>
> For i = 2 To count + 1
>
>
> If Cells(i, 1) = "" And Cells(i, 2) = "" And Cells(i, 3) =
> "" Then
>
>
> ok = False
>
>
> errcount = errcount + 1
>
>
> End If
>
> Next i
>
> If ok = True Then
>
>
> For i = 2 To count + 1
>
>
> send (i)
>
>
> Next i
>
> Else
>
>
> message = MsgBox("You should have atleast one address in TO,CC or BCC
> field (" & errcount & " errors detected.)", vbOKOnly) =
> vbOK
>
> End If
>
> End Sub
>
>
>
>
>
>
>
>
>
>
>
> From:
> excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
> Behalf Of Dave Bonallack
>
> Sent: Thursday, April 09, 2009
> 7:33 AM
>
> To: excel-macros@googlegroups.com
>
> Subject: $$Excel-Macros$$ Re:
> Macros in Outlook
>
>
>
>
>
> Thanks.
>
>
>
>
>
>
>
>
>
> Date: Wed, 8 Apr 2009 18:42:25
> -0700
>
> From: alokeshwar.tiw...@yahoo.com
>
> Subject: $$Excel-Macros$$ Re: Macros in Outlook
>
> To: excel-macros@googlegroups.com
>
>
>
>
>
>
>
> There is no password.. see attached
>
>
>
>
>
>
>
> _
>
> "There are known knowns. These are things we know that we
> know. There are known unknowns. That is to say, there are things that we
> know
> we don't know. But there are also unknown unknowns. There are things we
> don't
> know we don't know."
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> From: Dave Bonallack
>
>
> To:
> "excel-macros@googlegroups.com"
>
> Sent: Thursday, 9 April, 2009
> 7:07:51 AM
>
> Subject: $$Excel-Macros$$ Re:
> Macros in Outlook
>
>
>
> Hi Mudassar,
>
> Thankyou for posting the email workbook.
>
> Could you please tell us the VBA password so we can see how it works?
>
> Regards - Dave.
>
>
>
>
>
>
>
>
>
> From:
> johnplaye...@gmail.com
>
> To: excel-macros@googlegroups.com
>
> Subject: $$Excel-Macros$$ Re: Macros in Outlook
>
> Date: Wed, 8 Apr 2009 11:05:08 +0500
>
>
>
> Please find the attached file. Maybe
> helpful for you.
>
>
>
>
>
>
>
>
>
>
>
> I didn't remember who share. But its
> better one I have seen ever.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Regards,
>
>
>
>
>
>
>
>
>
>
>
> Mudassar Ramzan
>
>
>
>
>
>
>
> - Original Message -
>
>
>
>
>
> From: shashank bhosle
>
>
>
>
>
> To: excel-macros@googlegroups.com
>
>
>
>
>
> Sent: Tuesday, April 07,
> 2009 11:24 PM
>
>
>
>
>
> Subject: $$Excel-Macros$$
> Macros in Outlook
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hi
>
>
>
> I have to send a same
> mail frequently to all the employee.so i need to some macros where as i
> run
> the macro,the content to automatically apear in new mail
>
>
>
>
>
> Thanks and Regards
>
> Shashank Bhosle
>
>
>
> Life is all about
> Uncertaity
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Add more friends to your messenger and enjoy! Invite
> them now.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Add
> more friends to your messenger and enjoy! Invite
> them now.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> _
> View photos of singles in your area Click Here
> http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fdating%2Eninemsn%2Ecom%2Eau%2Fchannel%2Findex%2Easpx%3Ftrackingid%3D1046247&_t=773166080&_r=Hotmail_Endtext&_m=EXT
> >
>
--
With warm regards,
Subu
--~--~-~--~~~---~--~~
--
$$Excel-Macros$$ Date Time Picker
Guys, I have added a calendar control to an Excel 2007 worksheet. I am trying to pick the selected value in the code section with the calendar_click() function. I havent been able to pick the date part from the calendar control. Am I doing something wrong? Is there an easier way to do this? Thanks in advance. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: How to pull the charts from the excel file to the PPT?
Hi Raghu, Select the charts and run the below macro. Please let me know if there are any problems. Sub CopyChartsIntoPowerPoint() ''' COPY SELECTED EXCEL CHARTS INTO POWERPOINT ' Set a VBE reference to Microsoft PowerPoint Object Library Dim pptApp As PowerPoint.Application Dim iShapeIx As Integer, iShapeCt As Integer Dim myShape As Shape, myChart As ChartObject Dim bCopied As Boolean Set pptApp = GetObject(, "PowerPoint.Application") If ActiveChart Is Nothing Then ''' SELECTION IS NOT A SINGLE CHART On Error Resume Next iShapeCt = Selection.ShapeRange.Count If Err Then MsgBox "Select charts and try again", vbCritical, "Nothing Selected" Exit Sub End If On Error GoTo 0 For Each myShape In Selection.ShapeRange ''' IS SHAPE A CHART? On Error Resume Next Set myChart = ActiveSheet.ChartObjects(myShape.Name) If Not Err Then bCopied = CopyChartToPowerPoint(pptApp, myChart) End If On Error GoTo 0 Next Else ''' CHART ELEMENT OR SINGLE CHART IS SELECTED Set myChart = ActiveChart.Parent bCopied = CopyChartToPowerPoint(pptApp, myChart) End If Dim myPptShape As PowerPoint.Shape Dim myScale As Single Dim iShapesCt As Integer ''' BAIL OUT IF NO PICTURES ON SLIDE On Error Resume Next iShapesCt = pptApp.ActiveWindow.Selection.SlideRange.Shapes.Count If Err Then MsgBox "There are no shapes on the active slide", vbCritical, "No Shapes" Exit Sub End If On Error GoTo 0 ''' ASK USER FOR SCALING FACTOR myScale = InputBox(Prompt:="Enter a scaling factor for the shapes (percent)", _ Title:="Enter Scaling Percentage") / 100 ''' LOOP THROUGH SHAPES AND RESCALE "PICTURES" For Each myPptShape In pptApp.ActiveWindow.Selection.SlideRange.Shapes If myPptShape.Name Like "Picture*" Then With myPptShape .ScaleWidth myScale, msoTrue, msoScaleFromMiddle .ScaleHeight myScale, msoTrue, msoScaleFromMiddle End With End If Next Set myChart = Nothing Set myShape = Nothing Set myPptShape = Nothing Set pptApp = Nothing End Sub Sub CopyChartsIntoPowerPoint() ''' COPY SELECTED EXCEL CHARTS INTO POWERPOINT ' Set a VBE reference to Microsoft PowerPoint Object Library Dim pptApp As PowerPoint.Application Dim iShapeIx As Integer, iShapeCt As Integer Dim myShape As Shape, myChart As ChartObject Dim bCopied As Boolean Set pptApp = GetObject(, "PowerPoint.Application") If ActiveChart Is Nothing Then ''' SELECTION IS NOT A SINGLE CHART On Error Resume Next iShapeCt = Selection.ShapeRange.Count If Err Then MsgBox "Select charts and try again", vbCritical, "Nothing Selected" Exit Sub End If On Error GoTo 0 For Each myShape In Selection.ShapeRange ''' IS SHAPE A CHART? On Error Resume Next Set myChart = ActiveSheet.ChartObjects(myShape.Name) If Not Err Then bCopied = CopyChartToPowerPoint(pptApp, myChart) End If On Error GoTo 0 Next Else ''' CHART ELEMENT OR SINGLE CHART IS SELECTED Set myChart = ActiveChart.Parent bCopied = CopyChartToPowerPoint(pptApp, myChart) End If Dim myPptShape As PowerPoint.Shape Dim myScale As Single Dim iShapesCt As Integer ''' BAIL OUT IF NO PICTURES ON SLIDE On Error Resume Next iShapesCt = pptApp.ActiveWindow.Selection.SlideRange.Shapes.Count If Err Then MsgBox "There are no shapes on the active slide", vbCritical, "No Shapes" Exit Sub End If On Error GoTo 0 ''' ASK USER FOR SCALING FACTOR myScale = InputBox(Prompt:="Enter a scaling factor for the shapes (percent)", _ Title:="Enter Scaling Percentage") / 100 ''' LOOP THROUGH SHAPES AND RESCALE "PICTURES" For Each myPptShape In pptApp.ActiveWindow.Selection.SlideRange.Shapes If myPptShape.Name Like "Picture*" Then With myPptShape .ScaleWidth myScale, msoTrue, msoScaleFromMiddle .ScaleHeight myScale, msoTrue, msoScaleFromMiddle End With End If Next Set myChart = Nothing Set myShape = Nothing Set myPptShape = Nothing Set pptApp = Nothing End Sub On Thu, Apr 9, 2009 at 2:34 AM, wrote: > > Hi All, > > Please find the attachment. > > My requirements is – > > Can anyone tell me how to pull the charts from the excel file to the > PPT? I want two charts to be placed in ONE PPT. For example – Chart 1 > & Chart 2 should go to PPT Slide 1 and Chart 3 & Chart 4 should go PPT > Slide 2 and likewise. I want it be placed centrally. > > I have to update lots of Charts to update in the PPT from excel file > every month and its very annoying to copy and paste one by one and > consumes lots of time. PLEASE HELP. > > > Regards, > Raghu J. > > > > -- Hari kumar --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.exceli
