Function Does .NET NPV() Use? Doesn't Match Manual Calculations?
Jun 17, 2010
I am using the NPV() function in VB.NET to get NPV for a set of cash flows. However, the result of NPV() is not consistent with my results performing the calculation manually (nor the Investopedia NPV calc... which matches my manual results)
My correct manual results and the NPV() results are close, within 5%.. but not the same...
Manually, using the NPV formula:
NPV = C0 + C1/(1+r)^1 + C2/(1+r)^2 + C3/(1+r)^3 + .... + Cn/(1+r)^n
The manual result is stored in RunningTotal
[Code]...
The MSDN page example clearly states that the initial expense should be included in the cash flows list.
View 3 Replies
ADVERTISEMENT
Jan 27, 2010
i want to add calculations in 1 private function I have a textbox named lbldisplay.text when i enter a number.. the number is shown as a string so.. -private number1 as string when i press the button "+", "*", "-", or "/" the number1 must return into a double. So the number in the textbox is now a double.. so for example i press the + button, and i need to fill in a new number.. but this new number is also a string!
[Code]...
View 2 Replies
Aug 24, 2011
I was trying to increase the date value in a textbox automatically be 1 but wont let me do it. I have try to go through the Help but couldnot get something meaningful (or let say i do not get where to go).
View 2 Replies
Nov 29, 2010
how to go about populating some text boxes with results from calculations. To be more specific, I'm trying to do some trig to calculate various parts of a ci0rcle and will be populating any two of the text boxes then click on a button to get the missing values. I was thinking along the lines of a loop until all values have been calculated.
View 14 Replies
Jul 15, 2010
I am trying to duplicate the Match function in excel for use in Access. Public Function Match(T() As Double, TTM As Double) As Double ReDim T(LBound(T) To UBound(T)) As Double
[Code]...
View 1 Replies
Mar 18, 2011
i have a string such as {i|we|my friends} are {just|about} to go {walmart|asda|best buy} i would like to be able to randomly choose any of the words within the {} seperated by the | here is what i have so far and it only works for one {} i need it to work for sentences with multiple {}.
Function UnspinWork(ByVal SpunWords As String) As String
Dim upperBound As Integer
Dim Random As New Random()
Dim ChosenSpunString As String
[code]....
View 2 Replies
Feb 18, 2012
[code]i want to change password for the users [code]
View 14 Replies
May 29, 2010
Am trying to match characters or combination of the characters i specify in any order they appears
vb
Regex.IsMatch(teststring "[nuls]")
what i want matched is either any single character, or combination of any of them in any oder. this means that it should not match any character not specified in the pattern.
For example
it should match
n,u,l,s,nu,un,lun, sl etc
not
ny, nx so etc or any other
View 9 Replies
Feb 6, 2009
I'm using some functions which can be compared to encoding/decoding, but it's a really simple and basic application, not really an encoding function.The problem is, the decoding function doesn't seem to work. For some reason, it doesn't work correctly, and I'm a bit stressed, so even after searching for a while, I can't seem to find it.[code]
View 2 Replies
Jan 26, 2012
I wrote a VB function as:
Public Function StripNewLineFromString(str As String) As String
str.Replace(ControlChars.Cr, "")
str.tempStr.Replace(ControlChars.Lf, "")
Return str.replace(ControlChars.Lf, "")
End Function
and wrote a C# unit test to test it. It works fine. However, when it really run the VB application itself, it does not strip out newline. If I changed the function to this:
Public Function StripNewLineFromString(str As String) As String
Dim tempStr As String = str
tempStr = tempStr.Replace(ControlChars.Cr, "")
[Code]....
, run the VB application, it strips out newline.
View 4 Replies
Apr 6, 2011
On my software , i have a function for search in the list a member . The function have more fields : Girls , Boy , Old , etc ... but the software doesn't work correctly. I want him to search with several conditions, adding AND. Here is the code :
Vb
For Each MemberALister As MemberInfo In _Listemember
If Me.Girl.Checked Then
If MemberALister.Nom.Contains(Me.Genre.Text) Then
[Code]....
View 21 Replies
Feb 16, 2012
I am migrating project from .net 3.5 to .net 4.0 and faced the following issue. There are 2 DllImport statements:
<DllImport("hid64.dll")> _
Public Sub GenerateHardwareID( _
<MarshalAs(UnmanagedType.LPArray, SizeParamIndex:=1)> ByVal Buffer As Byte(), _
[Code].....
View 1 Replies
Sep 22, 2009
say if I have a string 010451-09F2
How to I get left of - from the above string in vb.net
I want 010451
The left function doesn't allow me to specify separator character.
View 7 Replies
Nov 23, 2011
[URL]
I know the error and why. I am just curious. For some projects this show up as warning while for others this doesn't show up at all.
How do I set up so that the warning show up?
View 1 Replies
Aug 9, 2009
I'm using VB .NET and I know that Union normally works ByRef but in VB, Strings are generally processed as if they were primitive datatypes.Consequently, here's the problem:
Sub Main()
Dim firstFile, secondFile As String(), resultingFile As New StringBuilder
firstFile = My.Computer.FileSystem.ReadAllText(My.Computer.FileSystem.SpecialDirectories.Desktop & "1.txt").Split(vbNewLine)
secondFile = My.Computer.FileSystem.ReadAllText(My.Computer.FileSystem.SpecialDirectories.Desktop & "2.txt").Split(vbNewLine)
[Code]...
View 2 Replies
Aug 5, 2010
I am having trouble with some code I am writing to handle an Excel spreadsheet. The idea is that the dialog box is displayed which invites the user to select an Excel spreadsheet. Once they have done that, it is opened and a separate function checks to see whether Sheet1 exists returning Nothing if it is not found. The intention being the try/catch block picks it up and gracefully does nothing. The problem is that when the function returns nothing, the dialog box is still displayed and the sub doesn't seem to exit. [Code]
View 4 Replies
Oct 22, 2010
I have a function to recursively search through windows (and their child windows) to find specific ones, it works exactly as expected, however it causes "function doesn't return a value on all paths" warning. This is the only warning in my entire program, and although it might be silly, I'm interested in knowing if there is a way to stop this error from occurring, but still allowing the function to work properly.[code]
View 4 Replies
Sep 19, 2011
I have this VB crypter I am trying to build, but I am getting 2 warnings. I Would like some help if someone has the time. Please PM me and ill send you the crypt.Warning 1 Function 'ReadEOFData' doesn't return a value on all code paths. A null reference exception could occur at run time when the result is used. I:Usersn oahDesktopI am CrypterI am CrypterForm1.vb 189 13 I am Crypter
Warning 2 Variable 'Buf' is used before it has been assigned a value. A null reference exception could result at runtime. I:Users
oahDesktopI am CrypterI am CrypterForm1.vb 203 19 I am Crypter
View 3 Replies
Dec 11, 2009
Im using TCP cliente to connect and receive data from my server. To read received data im using this code:
[Code]...
It works fine when server response is detected but when there is no connection or there is no server respone the program starts to crash and doesn't work, so i have to break the debuggind process.
View 2 Replies
Feb 25, 2011
I have done research on how to manually create sorting in a grid-view and none of it is thorough enough for me to follow. I need more of a step by step solution, like what event should my sorting code go in, how would i enable the headers to allow sorting. normally, i just have .net do this but for some reason this time it doesn't allow it, maybe because i am not using a datasource.that's my code that creates a datable and then binds to the gridview.
Function toptable()
Dim reader As SqlDataReader
cmd.Parameters.AddWithValue("@yeartoget", DropDownList1.SelectedValue)
[code].....
View 2 Replies
Jun 14, 2010
im trying to get mac adddress from this code but i get eerror on END FUNCTION line it says this "function 'getRemoteMac' doesn't return a value on all code paths. A null reference exception could occur at run time when the result is used." what am i missing here?
[Code]...
View 3 Replies
Jan 29, 2012
[URL] That way if the string that is not recognised that is passed to Color.FromName it returns a SolidColor of
Color.Black = Color.FromARGB(255,0,0,0)
That way, Forms and controls that only support SolidColors are supported.Installing VB6 on Windows 7?
View 15 Replies
Mar 15, 2012
I need to develop CATIA addin using Visual Basic. Does anyone have CATIA programming help or user manual?
View 1 Replies
Jan 15, 2012
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near and I don't know how does this happen because whenever I check the SQL that I have made including the inserted data, it shows no error.
View 2 Replies
Mar 13, 2009
I have my application set up with ClickOnce. It has been successfully published to my web site. I don't have updates performed automatically but on demand. I have a button that the user can click if they want to check if an update is available and install the update if it is. Here's the
[Code]...
After clicking the button a message box appears and says, "Update is available for download" as you would expect but after clicking the ok on the message box my application goes into a not responding state and I have to close it with the task manager. The application builds successfully and I have a reference for System.Deployment added to the project. Everything in my application works fine as long as I don't try to do an update. Any suggestions on what I should check or do? It should actually say "no updates are available for download" since the version of the program that is being used is the most current version.
View 1 Replies
Oct 28, 2009
If I turn off automatic updating of a binding data source by setting DataSourceUpdateMode = Never and then use a button to update the whole lot (using binding.WriteValue), a problem occurs - Namely, only the first bound control's data source is updated. All other controls are reset back to the original values.This is because when the current object changes (as happens after the above WriteValue), if ControlUpdateMode = OnPropertyChange, then all the other controls re-read in the value from the data source.
One way is to derive a class from BindingSource and add a WriteAllValues method.This method does the following:
(1) For each Binding, save the ControlUpdateMode
(2) For each Binding, set ControlUpdateMode = Never
(3) For each Binding, call the WriteValue Method
(4) For each Binding, reset ControlUpdateMode to the saved value
(5) For each Binding, if ControlUpdateMode = OnPropertyChange, call the ReadValue method.
If working with your own classes, would implementing IEditableObject resolve the issue?In another control I'm working on, I implement my own binding. The way I get around the issue in that is with the following code. (I've put in the bare minimum, I hope you can follow it!):
Private Shared ControlDoingExplicitUpdate As MyCustomControl = Nothing
Private Sub UpdateDataSourceFromControl(ByVal item As Object, ByVal propertyName As String, ByVal value As Object)
Dim p As PropertyDescriptor = Me.props(propertyName)
[code]....
So, when UpdateDataSourceFromControl is called, all the CurrentItemChanged events will be called for all other controls in the same BindingSource. However, because ControlDoingExplicitUpdate is set, they will not re-read in the value from the data source unless they happen to be the control that did the updating.ControlDoingExplicitUpdate is set to Nothing after all these events have completed, so that normal service resumes.
View 1 Replies
Jan 28, 2009
I have a DataGridView on a form in VB 2005 Express, of the 10 columns i need on this DGV 6 of them will be pulled from an MSSQL DB and 4 of them i need to manually enter. One thing i have going for me (i think) is that the 4 manual columns have the same data in each row.I have been filling this DGV using a datatable, but i am not figuring out how to add manual columns and databound ones in the same DGV. My column layout would look like this:[code]some one please explain to me how i would do something like this. if you can include the datatable definitions also it would be a big help, in order for me to verify that i am at least doing that the right way.
View 1 Replies
Feb 5, 2012
want to write a program that would have 4 boxes on the menu console:
Box 1) User input ( Ask the user to enter a number)
Box 2) Random Value
Box 3) Rolls value
Box 4) Counter
I want to write a If statement that shows the values of the rolls and the the counter count each time the user enters a number. If however I press the random box, a randomized number between 0-50 is generated and the counted is incremented by 1.
View 8 Replies
Apr 22, 2009
trying to automate some manual tasks. The task to access a web page (asp) login and then get some details from the site. The challenge is that the home page after login is build of 3 frames. when i see the page view source from the edit menu all i see are frame names. Once i right click on each frame and view source i am able to see the complete source - variables javascript function etc. The following code helps me to navigate :
vb.net
Set ie = CreateObject("internetexplorer.Application")
Dim s As String[code]....
After this the page has been logged in. Now to proceed further i have to click a "image" object.
1) I tried qualifying the image like ie.Document..........item("img1").click this doesn't work
2) I tried calling the javascript function directly
ie.Document.all.Item("frame1").Document.parentwindow.execScript "JS_WGorUsers (funcname)", "javascript"
The 1st option gives a run time error and 2nd option says access denied. (if i login manually i am able to click the image.
View 1 Replies
Apr 29, 2009
I had an idea to embed a PDF document into my application somehow.The PDF is a copy of the user manual. I expect that the file will be around 20 KB. This way, if people don't distribute the PDF with my app, they can extract it whenever they need to.
View 3 Replies
