Financial Calculations - Strange Result When Subtracting Numbers
Mar 17, 2011
Do a simple thing first... open VB.NET, then open your Immediate Window. And type the following:
? -199037.52 + 198571.0
Its a simple mathematical sum which should return the answer as -466.52, but instead it shows -466.51999999998952. My project which is mainly about financial calculations has gone all screwed up because of these two numbers. All the amounts in my project are based on Double type numbers. Since this calculation is showing a strangest kind of a result, all my program code has gone haywire.
View 7 Replies
ADVERTISEMENT
Nov 19, 2009
I have a project creating a calculator. I have the "add" function working but have no idea how to do subtract. My professor said once we know add we can do the rest.
View 7 Replies
Oct 23, 2010
I am working on a program that takes 12 numbers that the user inputs and calculates the total and average but every time I run it it comes out to be like 6.5 and numbers like that.
' Store the starting values in total and count.
sngTotal = 0
intCount = 1
[code].....
View 2 Replies
Jan 10, 2010
I'm using VB08. I've populated a listbox with numbers and I want to add all those numbers together and display the result in a Label. I've heard about using parse but I don't understand exactly how it works.
This is the code that I have that i think should work.
Dim lblTotal As Decimal
Dim sum As Double
For Each decAdded As Decimal In Me.lstRunningTotal.Items
sum += Double.Parse(decAdded)
Next
lblTotal = FormatCurrency(sum)
When I run it, nothing happens. My "For Each" statement I'm not sure if it's doing what I think it's doing. I can't believe I spent 6 hours banging my head against the wall but I finally got it figured out.
This is my revised code:
Dim sum As Decimal
For Each decAdded As Decimal In Me.lstRunningTotal.Items
sum += Decimal.Parse(decAdded)
Next
lbl_Total.Text = sum
Just some suttle changes made the difference
View 1 Replies
May 18, 2012
I've a very simple situation, which of course I can overcome with logic, but is there a built in VB function to ensure the following:
Dim price
Dim subsidy
if price - subsidy <= 0 then
price = 0
end if
In practical terms, I've lots of other things going on to calculate price, so I want to simplify this to:
Dim price = calculatedPrice - subsidy
and wrap that into some VB formating that ensures if price ever becomes negative it's forced to zero.
I'm thinking that a simple "Type" conversion might do it, but am not sure which type would suit.
View 1 Replies
Jul 30, 2009
I'm trying to do this division and the result to be displayed on a eight decimal number.
Dim r1 As Integer
Dim r2 As Double
r1 = Val(TextBox16.Text)
r2 = r1 / 60
TextBox18.Text = FormatNumber(r2, 8)
The value or R1 on this case is 273.4 but it varies according with the result obtained so I can not allocate a constant number to r1. The problem is the result that I am getting is 4,55000000 instead of 4.5566666
View 2 Replies
Apr 27, 2012
i am designing a billing software. i want to create a fiscal year so i can deal with the stocks, how can i do it ?
View 1 Replies
Jun 28, 2009
My knowledge of programming is very miniscule. I've just started my first language class like 2 weeks ago and i've already been asked to write a program that accepts user input for loan amount, tax rate amount, and the loan term (in years) then it outputs how much interest you will owe and how much in total you will owe
im not asking for a handout as iv'e read the rules and i have no code to post (as im clueless of how to start ) i understand the arguements that the financial.pmt method can accept im jsut wondering how i would get the calculation of such a thing to output to a read-only text box and if there is any way to link the user input to the financial.pmt method without having to hard code the arguments
i tried writing a code as to use all of these arguements with old scool paper like math but when i tried to state which text box variables to multiply and etc. i kept getting an error message saying that the names of my controls where "reserved" words
View 2 Replies
Oct 20, 2011
I want to download a file from a financial site. When I paste the URL in a browser, the file is downloaded. However, when I use webClient.DownloadFile or even HTTPPosts...it returns an html page not the csv file.
View 1 Replies
Feb 15, 2012
just a newbie programmer here. With 1 week experience in VB2008. I'd like to ask for assistance on making one of these inventory systems concepts. I hear its one of the basic programs a newbie can make. This will be made for students financial monitoring. Like how much they should pay in an event. Of course will be needing to input student names and event names.
So I'd like to ask could you give me tips on what to do first?*Set aside the database stuff first.
Like the main window, or a sample of a form to which I could encode and update entry payments for students.Am not asking for codes here just samples of forms or softwares I could get some ideas.
View 4 Replies
Jun 17, 2009
I need to build an application (vb.net or c# or a web application) that pulls financial stocks closing price
for that day.For example:
Input: DELL, IBM, INTC
Output will be a table with the closing prices (pps) of the stocks for that day.Im not sure where to start as far as to find a source that provides that information in a format so that I can extract and place it in Excel (or plain test file). Meaning where do I get the feed?
View 2 Replies
Feb 10, 2012
I have an assignment where I have to use financial.pmt to take input of a loan amount, interest rate, and term and display the monthly payment, total interest paid and total payments.
[Code]...
Our book doesn't talk much about the financial.pmt method. Can I use it to find the interest paid and total payments, or do i have to do that part with regular math like I've done?
View 7 Replies
Jun 24, 2011
Our financial year starts at 1st of April of every year. Therefore the current financial year is 1st of April 2011.How do I get this date no matter what the current date is? For example, today is 2011-06-24, how do I return 2011-04-30. If today is 2012-02-05, I still need it to return 2011-04-30. However, if today is 2012-07-06, it should return 2012-04-30.So basically, the year of the financial date should not change to the current year until the first of May is reached. [code]
View 4 Replies
Dec 30, 2010
I want to make compbobox dropdown for financial year like
2009 - 2010
2010 - 2011
View 3 Replies
Jul 7, 2009
I have a column in a datagridview which is populated with a string. Can I format it to financial type format? Here is what I am trying, but not getting it.[code]This is not working so how should I go about doing this? All I am getting is right justified values.
View 3 Replies
Apr 10, 2011
Any advice on using the financial.ddb function? I need to display a depreciation schedule in a label using only the financial.ddb function. I am able to show the final depreciated value at the end of the period but I don't know how to show the value for each year in the period. For example, if the user entered an asset cost of £1,000, a useful life of 4 years and a salvage value of $100 it should display: [code]
View 1 Replies
Mar 7, 2012
I want to see the source code of Microsoft.Visualbasic.Financial.IRR how would i break it and how would i seee the sorce code of IRR method of financial class?System{" df -k | awk '{sum += $4 }i; END {print sum} '"};
above line is not useful I've tried to view it using different software but it will not work for me is there any software that will view it source code.
View 3 Replies
Oct 16, 2009
I have a form with 3 txtboxes. The user has to enter their date of birth in the 3 boxes in the form
-DD in the first box
-MM in the second and
-YYYY in the third
I then need to get todays date and take their date of birth from todays date so that I can output to 3 labels the length of time they have been alive in years,months and days.I assume I will need to use timespan? in some way but I am not sure how , or is there perhaps a better way?
View 14 Replies
Apr 9, 2010
i have a variable [ Dim mytime = "12:30:00 AM" ]
i want to subtract mytime from TimeOfDay and i also want to get the difference as a integer value... how should i do that..
i have added the following code
Dim mytime = DateTime.Parse("1:16:00 AM")
Dim result = TimeOfDay - mytime
dim finalresult = result.Seconds
but it is giving me negative values
View 2 Replies
Apr 25, 2012
i want to subtract 18 years from a vb date object here's the code example:
Dim someVar
DirectCast(pcontrol, DateTimePicker).Value = Date.Now.Subtract(someVar)
someVar value is ?
View 1 Replies
Feb 11, 2012
I have a DateTimePicker (dtBBDate) and a textbox(txtDBBDate) object in my form....but what i want when user change the date of dtBBDate my text box should show show the date 10 days minus from that selected date i.e. if user select 10 may text box should show me 1st may?
View 2 Replies
Feb 2, 2009
I have a predefine time value of we'll say 1:30 PM. Im wanting to start a process at 5 minutes till 1:30 which would be 1:25. So this is what Ive tried
Dim MyTime As System.DateTime
MyTime = TimeString
MyTime = MyTime.AddMinutes (-5)
[code].....
View 2 Replies
May 15, 2011
i have employee startdate and enddate, i want to subtract them, then determine whether the employee is active during this period or having one day or two days off or not working after the period finish.
View 3 Replies
Jul 15, 2011
I am trying to create a basic tracker where and person clicks on button1 to display the start time in textbox1, button2 displays the stop time in textbox2 and texbox3 displays the difference between stop / start time. Textbox3 keeps showing 00:00:00 and not the difference between textbox2 / textbox1. I am having difficultly getting the format for the final textbox. I have look at Elasped Time and Parse, but without sucess. I have displayed the code below -
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]......
View 4 Replies
Jan 5, 2011
Girl.txt:
Anne
Beth
Caroline
[code].....
View 21 Replies
Jan 7, 2012
I've got a function which needs to take a UInt as a parameter. I'm using the .Net Micro Framework
As a simple example, I'd like to do something like:
Dim x As UInteger
For x = 0 To 100
[code]....
View 1 Replies
May 24, 2012
lets say i have a label with $50 in it. How do i subtract 10% from the $50 in label1?
I Though it would be label1.text -= 1% but apprently not
View 3 Replies
Mar 25, 2009
[2008] subtracting a decimal
View 4 Replies
Mar 9, 2011
Me.Width is what i am having issues with. I can adjust the width to work on my system but the bar is a different amount of pixels on different versions of windows. I was wondering if there was a function that would give u the amount of pixels the side bar is. I was considering writing some code so look for a color change but people can change the color so i do not think it would work very well. Also the program allows you to draw in a picture box so that would make it hard to get it to work correctly.
View 2 Replies
Mar 11, 2010
I am a little new to .NET Developing, and have learned a great deal recently, but I'm stuck with something. I come from an ASP Background, I'm trying to subtract 2 variables, but they don't seem to 'see' one another.
[Code]...
View 6 Replies
